Viewing 15 posts - 2,266 through 2,280 (of 5,111 total)
CREATE TABLE dbo.MaterialsWhereUsed (ID...
January 18, 2018 at 10:15 am
Have a look in my signature on how to post a T-SQL question. Rather than pasting your data in a format that we can't use (and is difficult to read),...
January 18, 2018 at 9:51 am
January 18, 2018 at 8:34 am
January 17, 2018 at 1:46 am
And now I can finally start testing the 2012 update. https://www.microsoft.com/en-us/download/details.aspx?id=56490
January 16, 2018 at 2:21 am
January 16, 2018 at 1:43 am
January 14, 2018 at 3:50 pm
You have a GROUP BY on Title. If you simply want a total of the sales of a specific Publisher defined in the WHERE clause, then drop the GROUP BY...
January 14, 2018 at 2:37 pm
Steve Jones - SSC Editor - Friday, January 12, 2018 8:56 AMGlad you solved it.
Not sure the OP has, Steve. That was...
January 12, 2018 at 9:02 am
Only critique I have with the code is with the data type used...
January 12, 2018 at 7:51 am
OK, I've done a solution for you using both a Delimited String, and a User-Defined Table Type. Note that the Delimited String solution user's Jeff Moden's DelimitedSplit8K, which you'll need...
January 12, 2018 at 4:19 am
January 12, 2018 at 3:51 am
January 12, 2018 at 2:28 am
Viewing 15 posts - 2,266 through 2,280 (of 5,111 total)