Viewing 15 posts - 271 through 285 (of 5,685 total)
SQLRNNR (6/27/2014)
Evil Kraig F (6/27/2014)
Eirikur Eiriksson (6/27/2014)
The Dixie Flatline (6/27/2014)
Grant Fritchey (6/27/2014)
Koen Verbeeck (6/27/2014)
Grant Fritchey (6/27/2014)
June 27, 2014 at 4:46 pm
kathy.plamann (6/27/2014)
June 27, 2014 at 4:41 pm
Eirikur Eiriksson (6/27/2014)
The Dixie Flatline (6/27/2014)
Grant Fritchey (6/27/2014)
Koen Verbeeck (6/27/2014)
Grant Fritchey (6/27/2014)
June 27, 2014 at 4:29 pm
Loner,
Don't feel bad. I failed my Microsoft interview so hard I excused MYSELF from the interviewing process. To give you an idea: I forgot GETDATE(). I was...
June 27, 2014 at 1:54 pm
Dennisql (6/26/2014)
if 3-4 tables join, does the order of table join in from clause matter? or the sql server will figure out the best execution plan for it?
Under most circumstances,...
June 26, 2014 at 6:27 pm
The crystal ball is malfunctioning. Sorry, I'm sending it back to the shop. The next person who wants to try using it is welcome to grab the fees.
PM:...
June 26, 2014 at 4:56 pm
wendy elizabeth (6/26/2014)
June 26, 2014 at 4:53 pm
I'd approach this differently than T-SQL.
First, I'd be doing this in SSIS. Drop your distinct list of items off to a recordset object and use that as a feeder...
June 25, 2014 at 4:44 pm
Is this a simplified version of a much larger problem where the values in Table2 need to be pre-generated?
The reason I ask is because you're re-inventing the wheel called IDENTITY()...
June 25, 2014 at 4:22 pm
I need to see the sourcing code or specifics about the technique the originator is using Michael to really nail down why that's happening.
Jay's recommendation above is your best bet...
June 25, 2014 at 4:15 pm
rocky_498 (6/25/2014)
What I am trying to do, Extract the data from SQL table and Insert in Email Body and email to user. I got good article on Internet,...
June 25, 2014 at 4:13 pm
wendy elizabeth (6/25/2014)
1. Can I use a temp table called '##temp' in the firstdata set and have the other 4 datasets refere to '##temp'? I am asking...
June 25, 2014 at 3:55 pm
Koen Verbeeck (6/25/2014)
Evil Kraig F (6/25/2014)
Sean Lange (6/25/2014)
Lynn Pettis (6/25/2014)
Sean Lange (6/25/2014)
Ed Wagner (6/25/2014)
Koen Verbeeck (6/25/2014)
Ed Wagner (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
SQLRNNR (6/25/2014)
Koen Verbeeck (6/25/2014)
ChrisM@Work (6/25/2014)
djj (6/25/2014)
June 25, 2014 at 3:46 pm
LOL,
Go, go mighty snark club! 🙂
I can't seem to find my favorite image of a crystal ball with the matrix code running down through it, otherwise I'd throw it...
June 25, 2014 at 3:44 pm
Do you have any downtime for this database/table?
I would expect a pretty heavy hit for this. Heavy enough that I'd recommend you do a table swap if you can....
June 25, 2014 at 2:39 pm
Viewing 15 posts - 271 through 285 (of 5,685 total)