Viewing 15 posts - 5,806 through 5,820 (of 13,877 total)
March 15, 2017 at 12:08 pm
Borrowing Thom's code a little, try adding
AND TRY_CAST(ItemNum AS BIGINT) IS NOT NULL
to the WHERE clause of the code I posted earlier.
March 15, 2017 at 12:02 pm
The column is a SKU, which is all numbers...the current...
March 15, 2017 at 11:47 am
Going to the pub and drinking works usually for me too. It's as if your IMEX=1 wasn't working yesterday, which is irrational (though it was Pi day!)
March 15, 2017 at 10:50 am
Distinct won't work because I need to have the MIN of...
March 15, 2017 at 10:14 am
March 15, 2017 at 10:01 am
March 15, 2017 at 9:04 am
Hopefully this is everything you need. please do tell me if you need anything...
March 15, 2017 at 8:33 am
There's a technique to this.
1) Start with your original SQL & do a global replace of ' with ''.
2) Put a single ' at the start...
March 15, 2017 at 6:00 am
It does look like in my post, sorry. i was making the topic again...
March 15, 2017 at 5:42 am
March 14, 2017 at 12:19 pm
March 14, 2017 at 10:25 am
I'm...
March 14, 2017 at 10:21 am
March 14, 2017 at 5:48 am
What is the best approach to refresh UAT table from Production. Tables have foreign...
March 13, 2017 at 5:18 pm
Viewing 15 posts - 5,806 through 5,820 (of 13,877 total)