Jacob... this may help you understand the chart. Single digit styles are for character strings that show only the last two digits of year. Three...

Just to keep this clear for the newcomers. A "numbers" table and a "tally" table are the same thing.

But "Tally Table" is much more...

The proper way to do an insert with a cte is like this:

;with cte (a,b,c) as (select whatever)

insert into #temp (x,y,z)

select a,b,c from cte

-- or

;with cte (a,b,c) as (select...

Can multiple copies of this procedure run at the same time? Perhaps when two users are logging at once?

Please post the procedure with a copy-and-paste, instead of typing?

Three comments.

1. Get in the habit of first storing @@ROWCOUNT in an integer variable. ( I use @rc. ) Do this to preserve the value...

EXEC sp_dropserver @server=ServerName'', @droplogins='droplogins';

That's not even going to run. You'll get a syntax error because the quotes are in the wrong place.

What line does it say...

Duplicate post. Reply here.

Please post your exact query, and the actual data you are running.

(1) We need to know what columns you are joining ON. Row 1 in both...

No problem, Baz. Glad I could help.

Fortunately, there is a ton of material online. SSC has lots of articles published here, MSDN is...

Jeff... my wife was just reading over my shoulder at your mirror text... she said (and I quote)....

Then she stormed...

Here's the example of a stored procedure that concatenates the addresses and puts them into a target table. Obviously you would use your own code with permanent target...

Okay... one example at a time. Here I'm going to add a computed column. (I'm sorry for saying "calculated" in previous posts. ...

Use the CONVERT function instead of CAST.

declare @datestring varchar(10)

set @datestring = '04/08/00'

select CONVERT(datetime,@datestring,3)

result = 2000-08-04 00:00:00.000

Look up the date styles table under CONVERT in books online. If...

Sudhanva,

Please do not think for a moment that we are making fun of you personally. Obviously, those of us who volunteer to help others have a...