Viewing 15 posts - 33,181 through 33,195 (of 59,102 total)
I don't know if it'll help for sure but I seem to remember an old wive's tale that may help. If you put all of the fixed length columns...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 9:11 pm
I got real curious and looked it up. Out-of-row pointers are freakin' huge... they're 24 bytes. I'm thinking that's likely the problem.
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 9:00 pm
rathod.balu (7/21/2011)
Could you please elaborate as for whr i am going worng...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 8:41 pm
CodePage = 'RAW' simply supresses any codepage conversions. There's more information in Books Online on the subject under "BULK INSERT".
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 8:01 pm
Yes. But, since you're in the "Newbie" forum, I have to tell you that ...
1) Formatted data should not be permanently stored in SQL Server, period.
2) SQL Server should...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 7:57 pm
JKSQL (7/21/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 6:25 pm
Kath Smith (7/21/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 5:50 pm
ALZDBA (7/19/2011)
Welsh Corgi (7/18/2011)
There was a post on SSC of an example of the file copy using Powershell about a week ago.
# copy all jpg files from c:\temp to c:\temp\jpgs
Copy-Item...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 3:41 pm
This looks like it might be a problem easily solved by a Tally Table. If I get the chance tonight, I'll see what I can do. Of course,...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 3:33 pm
Got it! Lynn Pettis has a similar problem. Apologies for the typical American mistake on the name. :blush:
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 2:31 pm
shannonjk (7/21/2011)
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 1:24 pm
David Burrows (7/21/2011)
SELECT DATEADD(minute, (t.N - 1) * 30, @DateStart)
FROM dbo.Tally t
WHERE t.N BETWEEN 1 AND (DATEDIFF(day, @DateStart, @DateEnd) + 1) * 48
ORDER...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 1:23 pm
CELKO (7/21/2011)
I have started asking if this is possible in my standard "cut & paste" asking for minimal Netiquette. My experience for...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 8:20 am
jbnv (7/21/2011)
I confess I'm still a little confused why this trick is necessary rather than just using a table variable inside the function, which is permitted?
Mr. Dvorak stated that he...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 8:08 am
Jakub Dvorak (7/20/2011)
Comments posted to this topic are about the item <A HREF="/articles/UDF/74231/">How to use temporary table in function</A>
+10 for thinking outside of the box, Jakub. There have been...
--Jeff Moden
Change is inevitable... Change for the better is not.
July 21, 2011 at 8:06 am
Viewing 15 posts - 33,181 through 33,195 (of 59,102 total)