Viewing 15 posts - 136 through 150 (of 3,544 total)
This looks like a standard pivot, for six levels thus
SELECT[No_],
MAX(CASE WHEN Num = 1 THEN [Minimum Quantity] END) AS [MinQty1],
MAX(CASE WHEN Num = 1 THEN [Maximum Quantity]...
Far away is close at hand in the images of elsewhere.
Anon.
November 13, 2019 at 12:16 pm
Anyone understand the life cycle. I thought MS were stopping SP in favour of CU but the life cycle is dependant on SP!
Looks like it CUs again as...
Far away is close at hand in the images of elsewhere.
Anon.
November 6, 2019 at 8:53 am
2019 is finally out for general release: SQL Server 2019 is now generally available
Time to start looking at the specs and what it really includes in the Standard...
Far away is close at hand in the images of elsewhere.
Anon.
November 5, 2019 at 8:42 am
To the person with the crystal ball, any prediction when SSIS projects will work properly in Visual Studio 2019?
To the person with the crystal ball, any prediction...
Far away is close at hand in the images of elsewhere.
Anon.
October 29, 2019 at 4:16 pm
I'm with Drew on this one. However some observations
Firstly, the relationship between PRData and TData should be 1-to-many otherwise TData will be repeated many times
Second, GROUP BY will return one...
Far away is close at hand in the images of elsewhere.
Anon.
October 29, 2019 at 2:05 pm
I wouldn't fetter a machine with replication for something that runs just once per night. Contrary to what most seem to say, I'd make a linked server, drag what...
Far away is close at hand in the images of elsewhere.
Anon.
October 29, 2019 at 10:08 am
P.S. I also strongly agree with Scott... there's no way that I'd rely on DateFirst settings never mind actually change them.
What is wrong with using DATEFIRST?
Why the...
Far away is close at hand in the images of elsewhere.
Anon.
October 28, 2019 at 3:39 pm
P.S. I also strongly agree with Scott... there's no way that I'd rely on DateFirst settings never mind actually change them.
What is wrong with using DATEFIRST?
Why the strong negativity?
Far away is close at hand in the images of elsewhere.
Anon.
October 28, 2019 at 9:16 am
The default for DATEFIRST is 7 (Sunday)
So
set @dayOfWeek = datepart(dw,@Thur)
will set it to 5 when you want it to be 4
This will return 44 for both dates
DECLARE...
Far away is close at hand in the images of elsewhere.
Anon.
October 25, 2019 at 1:24 pm
There's been a few games played over here (not that I've seen any of them). I thought they were played at Wembley or the Olympic Stadium.
What "criteria" is it...
Far away is close at hand in the images of elsewhere.
Anon.
October 22, 2019 at 4:16 pm
Also, the Browns … haven't even hosted a Superbowl. That's just sad.
London has been cited several times for possible Superbowl and the new Tottenham Hotspur stadium was lauded for playability...
Far away is close at hand in the images of elsewhere.
Anon.
October 22, 2019 at 2:30 pm
Any format containing yyyy-mm-dd can also throw you for a loop if the data had French origins because SQL Server uses YYYY-DD-MM with the French Language.
There is NO WAY...
Far away is close at hand in the images of elsewhere.
Anon.
October 3, 2019 at 7:44 am
TF 1118 and 1117 are automatically implemented in 2016. You can turn them off for all databases except for TempDB. I wouldn't turn 1118 off anywhere but I would...
Far away is close at hand in the images of elsewhere.
Anon.
September 24, 2019 at 4:09 pm
I don't think it is possible as Dynamic Data Masking is applied to column(s) not rows.
One thing to try is to create view that does your own masking of columns...
Far away is close at hand in the images of elsewhere.
Anon.
September 18, 2019 at 9:34 am
To really help we need CREATE AND INSERT statements for the tables and what is the expected output for the data supplied.
However this might get you going
SELECTStockCode
FROM(SELECTw.StockCode,w.Warehouse,MAX(w.DateLastSale)
FROM#InvWarehouse...
Far away is close at hand in the images of elsewhere.
Anon.
September 10, 2019 at 1:21 pm
Viewing 15 posts - 136 through 150 (of 3,544 total)