Viewing 15 posts - 4,156 through 4,170 (of 13,877 total)
The only things I want to group by are Products.REFERENCENUMBER, products.PRODUCTGROUP, Products.DESCRIPTION, Customer.CUSTOMERNUMBER,...
August 15, 2018 at 7:34 am
Here's a more formatted version of your query:
SELECT
Products.REFERENCENUMBER
, Products.DESCRIPTION
, PalletQty = SUM(CONVERT(DECIMAL(7, 2), Stock.SINGLESQUANTITY) / CONVERT(DECIMAL(7, 2), Stock.SINGLES) / CONVERT(DECIMAL(7, 2),...
August 15, 2018 at 6:34 am
August 14, 2018 at 3:12 pm
Does putting square brackets around external solve the problem?
August 14, 2018 at 2:44 pm
Perhaps I should have stated that in American English (at least as I...
August 14, 2018 at 12:34 pm
August 14, 2018 at 11:19 am
sidenote, celebrating 375...
August 14, 2018 at 11:16 am
I have a Script task(VB code),I have the output as filename to pick the...
August 14, 2018 at 9:25 am
OK. How about selecting a weird custom colour and then searching the Registry for its int value?
You can get the int value by setting up a registered server...
August 14, 2018 at 5:32 am
Just remembered an easier way. You can export and import your connection settings from within SSMS.
Just right click 'Local Server Groups' in your Registered Servers window and the rest should...
August 14, 2018 at 4:39 am
August 14, 2018 at 4:32 am
August 13, 2018 at 1:25 pm
after 8 hours of work I lose my...
August 13, 2018 at 10:25 am
Viewing 15 posts - 4,156 through 4,170 (of 13,877 total)