Viewing 15 posts - 1,036 through 1,050 (of 1,464 total)
Now, if your intention is to order by the month, then the following SQL may be what you are looking forSELECT K.Mnth
, K.ProductID
...
July 5, 2017 at 12:02 am
Firstly, What results are you expecting?
Secondly, your select statement is merely a union of 12 identical select statementsSELECT Mnth, ProductID, Project_No
FROM ( SELECT LEFT(DATENAME(MONTH,OrderDate),3)...
July 4, 2017 at 11:52 pm
Firstly, you will need a table to track the last DocNum usedCREATE TABLE dbo.DocumentNumbers (
Prefix VARCHAR(5) NOT NULL
, Yr TINYINT...
July 4, 2017 at 12:27 pm
I have been doing some reading online and discovered the Lead and Lag Functions. ...
July 4, 2017 at 2:36 am
June 30, 2017 at 11:08 pm
June 27, 2017 at 9:07 am
Stuart Davies - Monday, June 26, 2017 12:50 AMNew week, new word:-quiver
tremble
June 26, 2017 at 2:48 am
Below is a table example (Table name: Dummy)
Number Value
12345 ...
June 20, 2017 at 11:43 pm
And yes, I'm also guilty of leaving SSMS open for a long time..over...
June 20, 2017 at 11:32 pm
June 20, 2017 at 10:45 am
June 20, 2017 at 9:33 am
Viewing 15 posts - 1,036 through 1,050 (of 1,464 total)