Viewing 15 posts - 31 through 45 (of 191 total)
October 18, 2018 at 11:06 am
October 18, 2018 at 10:53 am
error msg:
Incorrect syntax near 'partition'
With CTE
as (
select *, row_number() over (partiton by HdrID , TabName order by HdrID) as RN
from xlshdr_EC
May 24, 2018 at 3:12 pm
I want all the columns... This will only return Hdrid and tabname, right?
May 24, 2018 at 2:24 pm
April 13, 2018 at 3:43 pm
April 13, 2018 at 12:03 pm
'%[^-a-zA-Z0-9.&_#$\\() ]%'April 13, 2018 at 11:08 am
April 13, 2018 at 11:02 am
drew.allen - Monday, January 29, 2018 1:21 PMSince you're on SQL 2012, you can use TRY_CAST() instead of just CAST().Drew
forgot about the...
January 29, 2018 at 1:37 pm
October 20, 2017 at 3:19 pm
On another update, I am getting the same error msg and I can't find the needle in the haystack. I was thinking of doing an update on a portion of...
October 20, 2017 at 2:55 pm
October 20, 2017 at 2:49 pm
October 20, 2017 at 1:16 pm
October 20, 2017 at 11:52 am
Viewing 15 posts - 31 through 45 (of 191 total)