Viewing 15 posts - 2,431 through 2,445 (of 4,080 total)
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2009 at 2:14 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 5, 2009 at 2:02 pm
Can multiple copies of this procedure run at the same time? Perhaps when two users are logging at once?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 4, 2009 at 6:13 am
Please post the procedure with a copy-and-paste, instead of typing?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 4, 2009 at 12:48 am
Three comments.
1. Get in the habit of first storing @@ROWCOUNT in an integer variable. ( I use @rc. ) Do this to preserve the value...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 4, 2009 at 12:42 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 4, 2009 at 12:25 am
Duplicate post. Reply here.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 4, 2009 at 12:02 am
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 3, 2009 at 11:48 pm
No problem, Baz. Glad I could help.
Fortunately, there is a ton of material online. SSC has lots of articles published here, MSDN is...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 3, 2009 at 8:33 pm
Jeff... my wife was just reading over my shoulder at your mirror text... she said (and I quote)....
OMG... WTF... How do you do that without having a seizure?
Then she stormed...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 3, 2009 at 7:47 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 3, 2009 at 7:22 pm
Okay... one example at a time. Here I'm going to add a computed column. (I'm sorry for saying "calculated" in previous posts. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 3, 2009 at 6:55 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 3, 2009 at 5:42 pm
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 3, 2009 at 5:20 pm
I hope Jeff never sees this thread...
You mean Cardinal Moden of the SQL Inquisition? :w00t::w00t::w00t:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 3, 2009 at 10:51 am
Viewing 15 posts - 2,431 through 2,445 (of 4,080 total)