Viewing 15 posts - 661 through 675 (of 928 total)
Oddly enough Celko, I agree with you.
It is maddening that the formatting is done within the SQL and if I was here when the system was designed I would...
November 10, 2011 at 1:56 am
Thanks for the prompt responses.
I'm going with Mark-101232's answer, as it's easier to implement in the real code, but I appreciate the two solutions.
November 9, 2011 at 10:03 am
2008R2 SP1 - runs without error.
2008 SP2 - 'severe error'
2005 - 'severe error'
November 8, 2011 at 1:23 am
WayneS (11/1/2011)
Thanks for your replies. The fact that he co-authored a book with Bob Beauchemin does help things a little bit. Still wondering just how much use these...
November 2, 2011 at 2:32 am
I'd never heard of SQL_VARIANT, thanks for the question.
November 1, 2011 at 2:31 am
As a starting point, the following code produces a csv string of the IDs from the selected Adventureworks table:
use AdventureWorks
select stuff((select ',' + cast(ContactID as varchar) from person.contact FOR XML...
November 1, 2011 at 2:24 am
And if you should (for some strange reason) have 2 iPad 2s, halloween is upon us:
http://gizmodo.com/5854649/best-costume-use-two-ipads-to-create-an-awesome-gaping-hole-in-your-gut
October 31, 2011 at 2:33 am
GilaMonster (10/26/2011)
BrainDonor (10/26/2011)
October 26, 2011 at 9:09 am
I thought we'd hijacked that thread enough, so I've moved over here:
Ninja's_RGR'us (10/26/2011)
BrainDonor (10/26/2011)
October 26, 2011 at 8:35 am
Available now over there, but not over here. By the time it was shipped over I could probably get it over here now and that also requires some additional effort...
October 26, 2011 at 7:57 am
GilaMonster (10/26/2011)
Chapter 8 of SQL Server MVP Deep Dives 2. </shameless plug>
Two more weeks before Amazon in the UK have that. Not a happy bunny.
October 26, 2011 at 7:45 am
In the UK it isn't illegal to use a hands-free mobile phone system, although it isn't recommended (Highway Code - para 149). Research has shown that even hands-free is a...
October 26, 2011 at 2:25 am
This article may give you a starting point:
October 26, 2011 at 1:52 am
When you say 'it errors'. I assume you mean the line of code is highlighted as an error once you leave it? Or are you getting an error when executing...
October 26, 2011 at 1:45 am
What Data Type are the variables? If FeedType is not able to store string values or pNeedPorSessions is not configured for numeric values then you will get this error.
If they...
October 26, 2011 at 1:22 am
Viewing 15 posts - 661 through 675 (of 928 total)