Viewing 15 posts - 3,526 through 3,540 (of 15,381 total)
DennisPost (11/24/2014)
Here it is again as .doc and .zip.
Can also do .txt or post all 1130 lines of...
November 24, 2014 at 9:42 am
You will get a lot more responses if you post your tables and data in a consumable format. Not many people are willing to download rar files from people they...
November 24, 2014 at 9:03 am
paul s-306273 (11/24/2014)
Reading 'XYZ', I'm surprised that the use of views is discoraged.
You read that document (which btw is more than 6 years old) and you were surprised about the...
November 24, 2014 at 8:58 am
Beatrix Kiddo (11/24/2014)
anglais, svp
Very roughly, it's:
---
Hi, I'm a beginner with SQL 2008. In my project/work I would like to export the output of the 'DetailRaport' procedure into an Excel table....
November 24, 2014 at 8:02 am
GilaMonster (11/24/2014)
Koen Verbeeck (11/24/2014)
Sean Lange (11/24/2014)
prachisaxena201 (11/24/2014)
SELECT @battery_included = COALESCE(@battery_included + ';', '') + CONVERT(VARCHAR(200),Item)FROM dbo.Split(@battery,';')
help me to understand this query
It looks like you have a delimited string...
November 24, 2014 at 8:00 am
Koen Verbeeck (11/24/2014)
Isn't this code splitting @battery and then concatenating it back again in @battery_included? Seems a bit pointless.
Ah so it is...it does seem rather pointless.
November 24, 2014 at 7:45 am
I can't speak French but I can tell you where the problems are in your code. First is the procedure declaration. You were missing parenthesis around your parmeters. Second issue...
November 24, 2014 at 7:37 am
prachisaxena201 (11/24/2014)
SELECT @battery_included = COALESCE(@battery_included + ';', '') + CONVERT(VARCHAR(200),Item)FROM dbo.Split(@battery,';')
help me to understand this query
It looks like you have a delimited string in a variable named @battery...
November 24, 2014 at 7:31 am
Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1638225-2799-1.aspx
November 24, 2014 at 7:23 am
Lynn Pettis (11/22/2014)
Jeff Moden (11/22/2014)
David Burrows (11/21/2014)
Well Jeff would have to employ GBAG (Glass By Agonizing Glass) or get an Overflow Exception 😀
Heh... I've reached the "Overflow Exception" a couple...
November 22, 2014 at 6:37 pm
Jeff Moden (11/21/2014)
Sean Lange (11/21/2014)
andrew gothard (11/21/2014)
Bar in my home town.Can't see it being suitable for a gathering, somehow. Certainly if Jeff Moden's invited,
LOL here is the mug...
November 22, 2014 at 6:36 pm
Hi and welcome to the forums. You didn't provide a lot of details here but I think something like this might be close.
select [YourColumnsHere]
from TableA a
join TableB b on a.Date...
November 21, 2014 at 2:48 pm
Damian-167372 (11/21/2014)
and i also wanted to know how this code can be...
November 21, 2014 at 2:44 pm
muthyala_51 (11/21/2014)
November 21, 2014 at 1:48 pm
Viewing 15 posts - 3,526 through 3,540 (of 15,381 total)