Viewing 8 posts - 61 through 69 (of 69 total)
My recommendation would be to do this using SSIS (or the Import/Export Wizard). you can easily output the result of a query to EXCEL through SSIS, save the SSIS package...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 27, 2012 at 3:04 am
Yes but as dwain.c mentioned, it will get you the intermediate results which you can simply concatenate to produce the final results. (have the Pivot in a CTE and concatenate...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 27, 2012 at 3:00 am
Hmm am not so sure where exactly you are having the bother, and whether its to do with getting the percentage numbers, or formatting the cell as a percent, but...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 26, 2012 at 11:21 am
I would say your best bet other than using that Adapter is to either:
> As suggested earlier, just grab the data from the DB, I have done that before and...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 26, 2012 at 10:57 am
Hmm, there might be plenty of reasons, but here are a couple to get you started:
> When you are submitting your Linq-to-SQL DataContext (through the SubmitChanges method), are you scoping...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
March 25, 2012 at 6:38 am
I think thats due to the ROWTERMINATOR parameter not being supplied to the BULK INSERT procedure. (probably because WYSIWYG not displaying the character \ n)
Try something like:
BULK INSERT [Thesaurus] FROM...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
February 7, 2012 at 3:42 am
You are a genius!!
That article made A LOT of sense, in terms of whats actually happening in the background as well as how to get around the issue.
Thank you very...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
May 24, 2011 at 5:07 am
Aye separating the query seems to be the way forward, although it just feels "dirty". I mean we're talking 11 reporting queries, each will have 3 ISNULL parameters, thats 33...
-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers[/url].
I believe in Codd
... and Thinknook is my Chamber of Understanding
May 24, 2011 at 4:44 am
Viewing 8 posts - 61 through 69 (of 69 total)