Viewing 15 posts - 3,031 through 3,045 (of 5,109 total)
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 28, 2017 at 10:01 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 28, 2017 at 9:51 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 28, 2017 at 9:07 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 28, 2017 at 7:41 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 28, 2017 at 7:24 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 28, 2017 at 7:14 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 28, 2017 at 6:30 am
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 28, 2017 at 6:20 am
\\YourFileShare\SharedFiles\Folder\Generic20170928.csv
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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",...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 28, 2017 at 4:42 am
The OP doesn't give us a lot to go on here, but I have (bad) feeling that those date columns are subject to change, thus the need for some "D-SQL"...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
September 28, 2017 at 2:20 am
Viewing 15 posts - 3,031 through 3,045 (of 5,109 total)