Viewing 15 posts - 3,031 through 3,045 (of 5,111 total)
Have SQL server 2017 officially released or not?
From Microsoft site, I can see there is...
September 28, 2017 at 11:36 am
September 28, 2017 at 10:01 am
September 28, 2017 at 9:56 am
Great to see that SQL 2017 has a date. Would love to know when SP4 for 2012 is due though. That was due this month but no sign as yet.
September 28, 2017 at 9:51 am
September 28, 2017 at 9:19 am
I'm now sure why you want to use a Window Function for this task. Would a GROUP BY not achieve what you're looking for instead?SELECT MAX(o.orderid) AS...
September 28, 2017 at 9:07 am
September 28, 2017 at 7:41 am
September 28, 2017 at 7:24 am
September 28, 2017 at 7:14 am
September 28, 2017 at 6:55 am
hoseam - Thursday, September 28, 2017 6:23 AMIt will always have time, datetime in that format.
/facepalm then why did your initial...
September 28, 2017 at 6:30 am
September 28, 2017 at 6:20 am
\\YourFileShare\SharedFiles\Folder\Generic20170928.csv
September 28, 2017 at 6:00 am
Personally, I prefer CamelCase. I know that some prefer Underscores though, and I don't specifically have anything against that. Like everyone else has said, names with spaces it are not...
September 28, 2017 at 5:06 am
Without a full filepath, this is an example, however, the following expression would return: \\YourFileShare\SharedFiles\Folder\20172809\Generic20170928"\\\\YourFileShare\\SharedFiles\\Folder\\" +
(DT_WSTR,4) DATEPART( "YYYY", GETDATE()) +
RIGHT("0" + (DT_WSTR,2) DATEPART( "M",...
September 28, 2017 at 4:42 am
Viewing 15 posts - 3,031 through 3,045 (of 5,111 total)