Viewing 15 posts - 46 through 60 (of 10,144 total)
I've been trying to fix some performance issues recently and started by swapping temp tables to table variables , testing performance gains at every step- quick win. until I...
March 5, 2020 at 12:08 pm
Get the best information you can.
About COVID-19: https://www.who.int/docs/default-source/coronaviruse/who-china-joint-mission-on-covid-19-final-report.pdf
WHO situation report: https://www.who.int/docs/default-source/coronaviruse/situation-reports/20200304-sitrep-44-covid-19.pdf?sfvrsn=783b4c9d_2
WHO Q&A: https://www.who.int/news-room/q-a-detail/q-a-coronaviruses
COVID-19 mortality rate by age (seeking a better source): https://www.sciencealert.com/covid-19-s-death-rate-is-higher-than-thought-but-it-should-drop
March 5, 2020 at 11:45 am
How big is this 256-row table? What's the pattern of usage?
February 21, 2020 at 11:44 am
Less than four functions, anyone?
SELECT string, numbers
FROM ( VALUES
('Total # of bytes : 128270200832 (119.46GB)'),
('Total # of bytes :...
February 18, 2020 at 4:30 pm
I remember doing this many years ago, but it didn't get coded up at the time. The same in principle but not quite the same code. Just for S&G I...
February 17, 2020 at 1:39 pm
/*
For FUN.
I like puzzles, I like T-SQL coding, I like to show off :-), so why not combine these.
This project was for FUN only, but I did learn new...
February 14, 2020 at 2:50 pm
I did not know this... are there any ms documents around it?
Not that I've seen. The observed behaviour is necessary to support correlated subqueries, where columns from both inside...
February 14, 2020 at 1:17 pm
Sorry to jeff, but i'm going to make light of the split functionality, it ends up in a function that goes RBAR - Use a TVP instead
again - sorry...
February 14, 2020 at 1:13 pm
You're UPDATE statement is incorrect. If you are going to alias something, you need to use that alias throughout.
UPDATE o -- use the alias here.
SET...
February 12, 2020 at 11:08 am
THIS works:
WHERE ((T.record_Key_4 = '1' OR T.Record_Key_5 NOT IN('I', 'X')) AND PS.popup_gid = 2)
OR ((T.record_Key_4 <> '1' AND T.Record_Key_5 IN('I', 'X')) AND PS.popup_gid = 5)
thanks for your help !!!
Just...
February 10, 2020 at 1:13 pm
Either SELECT or VALUES
DECLARE @ID int
DECLARE @multiVariable table
(
ID int,
FName varchar(20),
Company varchar(20),
State char(2)
)
INSERT INTO @multiVariable
--VALUES
SELECT ID, fName, address, state
FROM baseTableExample;
February 10, 2020 at 12:42 pm
WHERE 1 = CASE
WHEN T.record_Key_4 = '1' OR T.Record_Key_5 NOT IN('I', 'X') THEN CASE WHEN PS.popup_gid = 2 THEN 1 eLSE 0 END
ELSE CASE WHEN PS.popup_gid = 5 THEN 1...
February 7, 2020 at 4:38 pm
WHERE
(PS.popup_gid = 5)
OR
(PS.popup_gid = 2 AND T.record_Key_4 = '1')
OR
(PS.popup_gid = 2 AND T.Record_Key_5 NOT IN ('I', 'X'))
Add an extra column to your temp table:
MyFilter =...
February 7, 2020 at 4:04 pm
OK, something I've never done before. Would anyone object if I posted a GoFundMe link here? It's not for me in any way, shape, or form, but it is...
February 5, 2020 at 8:50 am
This article, along with this one from ten years ago, should be enough to assist in solving most Moving Average problems. Thanks for posting.
February 4, 2020 at 4:27 pm
Viewing 15 posts - 46 through 60 (of 10,144 total)