Viewing 15 posts - 2,986 through 3,000 (of 26,490 total)
March 20, 2017 at 10:15 am
The other issue I did see is that if node elements were missing the nodes() returned empty strings for character columns, 0 for integer columns, 1900-01-01 for date columns all...
March 20, 2017 at 10:02 am
March 20, 2017 at 9:46 am
March 17, 2017 at 1:33 pm
I know it may be late in some locales, but is there anyone on that could help with some XML work? I am try to move from OPENXML to using...
March 17, 2017 at 12:39 pm
March 17, 2017 at 11:16 am
One cross apply, two FOR XML PATH concats, one for each column. I have the code, but I'll wait to see what the OP has to say.
March 17, 2017 at 10:11 am
March 17, 2017 at 9:54 am
March 17, 2017 at 9:36 am
Then there are the times I just give a one sentence answer with nothing else. In this case, it just seemed easiest as the code the OP was using is...
March 17, 2017 at 8:45 am
Use two cross applies, one for each column.
March 17, 2017 at 8:44 am
Differences in linked server query results after migration
Note: Remote server is the same.
Upgraded Version:...
March 17, 2017 at 8:40 am
Viewing 15 posts - 2,986 through 3,000 (of 26,490 total)