Viewing 15 posts - 2,716 through 2,730 (of 8,731 total)
You could use SSIS for that. To create the packages more easily, you could use the Import/Export wizard.
June 9, 2016 at 1:31 pm
Ed Wagner (6/9/2016)
Manic Star (6/9/2016)
crookj (6/9/2016)
Luis Cazares (6/9/2016)
Manic Star (6/9/2016)
Ed Wagner (6/8/2016)
crookj (6/8/2016)
Revenant (6/8/2016)
Y.B. (6/8/2016)
Ed Wagner (6/8/2016)
TomThomson (6/8/2016)
HappyGeek (6/8/2016)
SkinflintPinchpenny
Cheap
Me 😉
Windows ME
Barf
Agree
Fight
Club
Sgt Pepper's (Lonely Hearts #### Band)
Abby (Road)
Downton
Uptown
June 9, 2016 at 12:49 pm
Lynn Pettis (6/9/2016)
Sean Lange (6/9/2016)
June 9, 2016 at 12:34 pm
You need to unpivot before pivoting again. This can be done in a single statement.
June 9, 2016 at 11:56 am
Would this article give you the answer you're looking for?
http://www.sqlservercentral.com/articles/T-SQL/105968/
It mentions month, but should work for any range.
June 9, 2016 at 11:25 am
Each statement is assigning a value to a variable. This values will be lost after the batch ends, so basically, they're not doing anything useful unless they're combined with something...
June 9, 2016 at 11:22 am
Manic Star (6/9/2016)
Ed Wagner (6/8/2016)
crookj (6/8/2016)
Revenant (6/8/2016)
Y.B. (6/8/2016)
Ed Wagner (6/8/2016)
TomThomson (6/8/2016)
HappyGeek (6/8/2016)
SkinflintPinchpenny
Cheap
Me 😉
Windows ME
Barf
Agree
Fight
Club
June 9, 2016 at 9:41 am
Y.B. (6/9/2016)
Greg Edwards-268690 (6/9/2016)
Y.B. (6/9/2016)
I realize that...
June 9, 2016 at 9:37 am
Just remember that you might want to consider holidays as well. That's only achievable from a holidays or calendar table.
June 9, 2016 at 9:32 am
This is what I understood from what you posted, or at least it makes some logic to me. I agree with Drew that you might want to use a calendar...
June 9, 2016 at 9:27 am
Y.B. (6/9/2016)
I realize that there are good...
June 9, 2016 at 8:28 am
Sergiy (6/8/2016)
Luis Cazares (6/8/2016)
Thanks, that works abit faster but its still very slow. 16hrs and no where near done
Now, even with the DISTINCT,...
June 8, 2016 at 8:50 pm
I mentioned that because he stated the following:
Thanks, that works abit faster but its still very slow. 16hrs and no where near done
Now, even with the DISTINCT, it shouldn't perform...
June 8, 2016 at 7:46 pm
Jeff Moden (6/8/2016)
prafuljemail (6/7/2016)
check interview questions on forums of winmilestone.com / http://www.winmilestone.com/Topic?InterviewYou want way too much information on the signup sheet. It's not worth it.
Not only that, the page...
June 8, 2016 at 4:13 pm
Read the following article:
http://www.sqlservercentral.com/articles/CROSS+APPLY+VALUES+UNPIVOT/91234/
It explains what you need to do. It's easy if you understand it.
June 8, 2016 at 2:38 pm
Viewing 15 posts - 2,716 through 2,730 (of 8,731 total)