Viewing 15 posts - 55,801 through 55,815 (of 59,067 total)
| I am writing a stored procedure to populate a table nightly with approximately 2,700,000 records. Each record has... |
July 14, 2007 at 9:47 pm
I don't know what "SP_Generate_Inserts" does... but there's a couple of things I see wrong here...
First, it's a very bad practice to name your procs starting with SP_... those should...
July 14, 2007 at 9:21 pm
Pretty sure the OP said something to the effect of "without using a additional column levelno".
Vamshi,
Lookup "Expanding Hierarchies" in Books Online...
July 14, 2007 at 9:14 pm
Uh... what happens when you have more than 1 year? In other words, why are you storing the salary month and not a salary date/time so you can do multiple...
July 14, 2007 at 9:04 am
Where do you get those? Wouldn't mind seeing the rest of them...
July 14, 2007 at 7:15 am
Gotta love that... a GUI based tool that doesn't support the base product... kinda like EnterPrise Manager with Case statements...
July 14, 2007 at 7:10 am
Heh... or...
Infinity = undefined
Null = undefined
1/Infinity = undefined?
1/Infinity = Null?
Just havin' fun ![]()
July 13, 2007 at 9:52 pm
Didn't think of them that way... operative words were "didn't think"
Thanks, Serqiy.
July 13, 2007 at 9:44 pm
And, if you do have a clustered index in the right spot...
GO
--===== Create and populate a 1,000,000 row test table.
-- Column RowNum has a range of 1...
July 13, 2007 at 9:35 pm
Pretty sure (been a while since I've had to check, DBA's at work normally do this) PCI compliance doesn't allow trusted connections. If you're not worried about PCI, then that'll...
July 13, 2007 at 8:35 pm
From the FROM clause down, updates with joins look pretty much like what you'd find in a SELECT...
UPDATE t1
SET somecol =t2.somecol
FROM @Table1 t1,
@Table2 t2
WHERE t1.someothercol...
July 13, 2007 at 8:31 pm
There's some sort of nasy ol' timeout... I always do a select-all and copy before I try to post... just in case...
July 13, 2007 at 3:52 pm
Better have a good list of logins and passwords, then
And figure out a really good way to change them in the code...
July 13, 2007 at 7:11 am
Viewing 15 posts - 55,801 through 55,815 (of 59,067 total)