Viewing 15 posts - 6,361 through 6,375 (of 7,168 total)
...same results but a little more concise:
SELECT INDACCOUNTNUMBER ,
TOTALPYMTAMT ,
NETPAID ,
...
May 23, 2011 at 8:29 pm
It's all about the parentheses...try it this way:
SELECT INDACCOUNTNUMBER ,
TOTALPYMTAMT ,
NETPAID ,
...
May 23, 2011 at 8:27 pm
opc.three (5/23/2011)
Closed "as Won't Fix" with the reason being "Backward Compatibility Issues"...Booooo!
I guess we can officially call STUFF a...
May 23, 2011 at 5:50 pm
dankwart menor (5/23/2011)
Thanks, that is working exquisitely
Excellent! I love it when a plan comes together 😀
May 23, 2011 at 5:43 pm
Craig Farrell (5/23/2011)
GilaMonster (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/2011)
May 23, 2011 at 4:47 pm
Closed "as Won't Fix" with the reason being "Backward Compatibility Issues"...Booooo!
I guess we can officially call STUFF a legacy...
May 23, 2011 at 4:29 pm
Query Analyzer only returns the first 256 characters of a column by default. You can increase it to a maximum of 8192 in:
Tools > Options > Results Tab
May 23, 2011 at 3:47 pm
Unfortunately you will not be able to have an actual "#" appear in your element name. It is not supported in the SQL Server implementation of XML...i.e. it must be...
May 23, 2011 at 3:07 pm
Your decimal to hex conversion needs some work 😉
x35 = decimal 53 = the number 5 on the ascii map
x23 = decimal 35 = the hash sign on the ascii...
May 23, 2011 at 2:46 pm
Are they fixed width files or delimited?
If fixed you can seek to the end of the file and then seek back this number of bytes:
10 * ([bytes in each row]...
May 23, 2011 at 1:34 pm
A try/catch structure around the code you think may be having an issue would be a wise move to capture and output the error message.
May 23, 2011 at 12:17 pm
How are you connecting to the remote server? Windows Authentication? If yes, make sure the Windows login running the SQL Agent job (Windows service account or proxy account) can connect...
May 23, 2011 at 12:16 pm
I bought a Kindle about two months ago because of the issues with backlit tablets interrupting melatonin production (i.e. interfering with sleep patterns). I wish it had a browser sometimes...
May 23, 2011 at 11:42 am
Direct all replies here:
http://www.sqlservercentral.com/Forums/Topic1113404-364-1.aspx
May 23, 2011 at 11:26 am
Viewing 15 posts - 6,361 through 6,375 (of 7,168 total)