fragmentedarray.blogspot.com
Fragmented array: March 2012
http://fragmentedarray.blogspot.com/2012_03_01_archive.html
Friday, March 30, 2012. Finding most recent date? Using query analyzer on a SQL 2000 server. I'm having trouble even. Describing what I want here. Let's try this, here's the query:. Select distinct pt.patient id, payer org id as 'Payer ID', org.name as. 039;Payer Description',. Ppplan name as 'Plan Name', pt policy.policy number as 'Policy Number',. Rank, claim number, posted transaction date. From patient as pt. Left join pt policy on pt policy.patient id = pt.patient id. For each claim number. LinnPlea...
extractingsql.blogspot.com
Extracting Sql: Failed to start jobs in sql agent after restart service
http://extractingsql.blogspot.com/2012/03/failed-to-start-jobs-in-sql-agent-after.html
Thursday, March 29, 2012. Failed to start jobs in sql agent after restart service. We have clustered sql2005 (sp2) installed in win2003 (sp2). Recently, we. Encountered a problem which failed to start jobs in sql agent after restart. Mssql server and aql agent services. It failed with exception error in the. There is no error message in event viewer and we found an error aqlagent.out. 165] ODBC Error: 0, Unable to complete login. Process due to delay in opening server connection [SQLSTATE 08001]. Check y...
ftsindexsize.blogspot.com
FTS Index Size: Flood of SQL services
http://ftsindexsize.blogspot.com/2012/03/flood-of-sql-services.html
Flood of SQL services. I've just setup SQL Express 2005 SP2 on my fresh SBS 2003 R2 system. I never. Had anything to do with and have no idea about SQL, the only reason for. Updating from MSDE was the annoying and ugly event id 1000 relating to. Sharepoint services in my application log. There seems to be no working. Solution for that yet. The point after upgrading to 2005 SP2 now is, that there is a total of seven. Services related to SQL running on my machine. They are named. SQL Server VSS Writer.
ftsindexsize.blogspot.com
FTS Index Size: Floats with no scientific notation
http://ftsindexsize.blogspot.com/2012/03/floats-with-no-scientific-notation.html
Floats with no scientific notation. I've been searching the groups for a way to accomplish this, but I've. Come up short. What I ultimately need is a way to count the number of. Decimal places in a floating point number (ie 37.88955 = 5, 0.02 =. What I'm currently working on is how to convert a float to decimal,. With no scientific notation. Cast(cast(f.formula percent as decimal(20,10) as varchar(20). This almost does the trick, except that I also need to trim off the. Select cast (16.9 as float), c...
formatalignment.blogspot.com
Format Alignment: Filter Help Needed
http://formatalignment.blogspot.com/2012/03/filter-help-needed.html
Thursday, March 29, 2012. Good Day to All,. Need some help with Filters in SQL Reporting 2000. Have a table report setup with a DS going to a Store Proc. need to add a. Filter that is a bit complex. Don't know which filter section I should be. Putting this in but in all cases I've run into errors. Basically when the data is brought back from my Store Proc, I need to filter. Out the data according to the following:. THEN ( -1*TTLBalance) ( -1*CBAlance)*0.25). ELSE (TTLBalance (CBalance*0.25). Other then v...
formatalignment.blogspot.com
Format Alignment: filter for profiler
http://formatalignment.blogspot.com/2012/03/filter-for-profiler_29.html
Thursday, March 29, 2012. How can i actually use the filter for profiler. I have set up the profiler with a filter using the object name ( as like. Tb transaction" w/o the quotes) and i have also bring out the object name. Column and make it into a group. However, it seems not to be work. i have tested with statements like "select. From tb transaction" and "select * from tb customer" and both statements. Were shown in the profiler and the column object name is always empty. Appreciate ur kind advice.
formatalignment.blogspot.com
Format Alignment: March 2012
http://formatalignment.blogspot.com/2012_03_01_archive.html
Thursday, March 29, 2012. Filter in stored procedure. I am trying to edit this query i already have that is fully functional for another report in reporting services. The report has visits sales reps made to stores, broken down by period, week and then date. Now, i need to filter it out by Visits. They want the Sales Reps who had less then 6 visits a day. How would i code that out in my stored procedure? ALTER PROCEDURE [dbo].[Testing Visits Exception]. 64;Region Key int=null). Qry Sales Group.Name,.
extractingsql.blogspot.com
Extracting Sql: March 2012
http://extractingsql.blogspot.com/2012_03_01_archive.html
Thursday, March 29, 2012. Failed to start jobs in sql agent after restart service. We have clustered sql2005 (sp2) installed in win2003 (sp2). Recently, we. Encountered a problem which failed to start jobs in sql agent after restart. Mssql server and aql agent services. It failed with exception error in the. There is no error message in event viewer and we found an error aqlagent.out. 91;165] ODBC Error: 0, Unable to complete login. Process due to delay in opening server connection [SQLSTATE 08001].
commadelimitedfields.blogspot.com
Comma Delimited Fields: March 2012
http://commadelimitedfields.blogspot.com/2012_03_01_archive.html
Thursday, March 29, 2012. Comparing two SSIS Packages? I'd like to know how people out there are comparing (diffing) their DTSX files. Using XML file compare doesn't seem to work, because the package XML appears to be arbitrarily ordered and reordered by the designer in Visual Studio. ApexSQL is supposedly planning to have a tool available in Q3, but even their product page does not seem too hopeful: Compare and Document SSIS Packages (. Be released with ApexSQL Doc and ApexSQL Diff in Q3. I don't know i...
