Viewing 15 posts - 991 through 1,005 (of 1,988 total)
The simplest option if you can do it is to simply strip out the comma from that column in the select statement. Another option is to use a different delimiter...
October 18, 2017 at 8:25 am
October 16, 2017 at 12:24 pm
What exactly is the problem? Your query is returning rows that have not a 25 in GLAcctId so that field is NULL. Looking at case statement posted not the one...
October 13, 2017 at 1:31 pm
How consistently are you able to generate those results?
October 12, 2017 at 11:27 am
You'll likely also see it go back to an index seek on the non clustered index if you increase the uniqueness of GID. Trying change the values for GID and...
October 11, 2017 at 11:56 am
October 11, 2017 at 10:51 am
October 11, 2017 at 9:44 am
Steve Jones - SSC Editor - Tuesday, October 10, 2017 8:27 AMThis was interesting. CSV Injection: http://georgemauer.net/2017/10/07/csv-injection.html
So..... excel is even...
October 10, 2017 at 8:44 am
Is there some reason you can't just add two new columns with those formulas to the SELECT?
October 10, 2017 at 8:06 am
October 9, 2017 at 1:55 pm
I really think most people just don't understand what the difference is between a unit test and an end to end test.
October 6, 2017 at 9:38 am
I think this might apply more to POC type work, and I'll usually go through several iterations of a new idea before running with a final version. However for some...
October 5, 2017 at 8:05 am
guh.... I just had a senior DBA type person ask, after breaking a file extract in prod.
What difference does the order of the fields...
October 5, 2017 at 7:51 am
Viewing 15 posts - 991 through 1,005 (of 1,988 total)