Viewing 15 posts - 991 through 1,005 (of 1,957 total)
TheSQLGuru (2/22/2013)
Hey, NOT COOL!! We do PUBLIC performance testing around these parts! You test it, you post it! :hehe:
Right, if I get flamed for this, you have to save me...
February 22, 2013 at 6:15 am
Hi Jeff,
I just sent you an email with some interesting performance test results if you get a chance to have a look.
😎
February 21, 2013 at 5:41 pm
Thanks for the article, my only criticism being the lack of examples or links to further reading, which would have been nice.
But, I can Google, so no biggie 😛
February 21, 2013 at 7:59 am
Maybe someone else can help with the server side excel - I know from past experience there is a reason MS don't support it :crazy: so I steer clear...
February 21, 2013 at 7:52 am
SQL_Surfer (2/21/2013)
I have a table which stores date per week. I am passing those dates to my inline statement (in execute sql statement).
How? Show us please 😀
What error are you...
February 21, 2013 at 7:33 am
wafw1971 (2/21/2013)
February 21, 2013 at 6:18 am
dwain.c (2/21/2013)
Magoo you've done it again! (love that catchphrase)Seriously, +1 because that's I think the OP needs.
Can't hear it enough TBH 😛
February 21, 2013 at 6:11 am
Sorry to jump in late into the party and all, but if you want
30% should 2 night stays
20% should be 3 night stays
and the other 50% to be...
February 21, 2013 at 5:48 am
If you are using OpenXml style workbooks (xlsx) then I would suggest using the OpenXml library to create them, or if that proves too difficult, you might investigate the structure...
February 21, 2013 at 3:21 am
It's actually not that hard...
Step 1. You need your dataset to include a few extra columns
;with data as
(
select GroupName,ArticleNumber,Subject,row_number() over(PARTITION BY GroupName order by ArticleNumber) as rn
FROM Articles ...
February 21, 2013 at 3:15 am
keval.bhatt (2/21/2013)
Yes, our DBA logged on and initialised Excel. We worked through that last week...
Our DBA has tried logging into the server as the SQL Agent and no dialog...
February 21, 2013 at 2:26 am
C-kweldude (2/20/2013)
Hi Miste.MagooThanks for that, worked like a dream.
Appreciate the assistance!:-)
A
You are most welcome 🙂
February 21, 2013 at 2:21 am
Good luck. It sounds hellish!
February 21, 2013 at 2:20 am
SQL_Surfer (2/20/2013)
February 21, 2013 at 2:19 am
Phil Parkin (2/21/2013)
Alternatively, add a Conditional Split in the data flow and split the data into four streams - to four separate files.
I like this idea, but only if every...
February 21, 2013 at 2:16 am
Viewing 15 posts - 991 through 1,005 (of 1,957 total)