GSquared (7/21/2008)

Unless you're talking about...

Sure you can make it format better by adding Carriage Returns, Line Feeds, and Tabs. You would do this using the CHAR() function. I believe it is CHAR(10)...

DateTime fields store date and Time so if you are using Between '6/1/08' and '6/30/08' then you are actually saying give me all the data From 6/1/08 00:00:00 to 6/30/08...

It sounds like the OLE DB Command task it what you want then.

The code looks like it will create...

You can use the Execute OLEDB Command to do this.

What are you doing in the stored procedure?

No you cannot. temp tables created using #table_name are only available to that session and when you end step 1 and start step 2 sessions change. You...

Chris,

Thanks. I have not used all the new statistical functions in 2005 yet and had forgotten about rank. I changed my solution to use RANK and had about...

I think this may do what you want (I created some dummy data):

[font="Courier New"]DECLARE @customers TABLE(AccountNum INT, DM_Source_Id INT, Address VARCHAR(10))

DECLARE @i INT,

             @j-2 INT

SET @i = 1

SET @j-2 =...

The first risk is poorly performing code. Why do the developers want to use the CLR? There have been a couple of threads here on SSC where there...

As far as separating databases and database backups, yes they should be on separate drives. Having backups doesn't to much good if the data drive fails and that is...

In SQL Server 2005 you can use Create Database [db_name] With Attach instead of sp_attachdb. You can also specify a new database name using sp_attachdb.

There was a follow up to the first article in my earlier post, Return Query Text Along With sp_who2 Using SQL 2000[/url], that may help. You can...

This line:

HR = ""

is causing .NET to throw an "Conversion from String to Integer" error. The way you are referencing the code in the report is fine. The...

Idle connections should not be causing blocking as they are doing nothing. Using sp_who or sp_who2 shows any blocked processes and the SPID which is causing the blocking. ...