Viewing 15 posts - 2,251 through 2,265 (of 2,645 total)
Good Morning Experts,
There is a mega sale on a TV for 5 days, starting...
August 25, 2018 at 3:49 am
August 24, 2018 at 6:10 pm
Thanks in advance. How would you go about normalizing a 300 million record data set...
August 24, 2018 at 3:56 pm
August 24, 2018 at 1:56 pm
August 24, 2018 at 1:41 pm
August 24, 2018 at 1:20 pm
SELECT * FROM dbo.Table_1 WHERE Reason = '' AND SubTypeDesc NOT LIKE '%Taxi%' OR SubTypeDesc NOT LIKE '%Parking%'
I think you need to add some brackets:SELECT...
August 24, 2018 at 7:02 am
August 24, 2018 at 6:22 am
Instead of making it a Stored Procedure you could make it a Table Valued Function. A drawback of this is that you cannot have a temporary table in a TVF,...
August 24, 2018 at 5:51 am
August 24, 2018 at 5:20 am
Ok that's fine no problem. Thanks.
If I have another different question related to this code...
August 24, 2018 at 5:00 am
Yeap.
DECLARE @DateFrom DATE = '2018-01-01';
DECLARE @DateTo DATE = '2018-08-21';
IF OBJECT_ID('tempdb..#ClaimType') IS NOT NULL
DROP...
August 24, 2018 at 4:31 am
Can you put the full SQL statement in with the FROM and GROUP BY?
August 24, 2018 at 3:41 am
Very good solution and of course performance is much better. Could you tell me...
August 24, 2018 at 2:35 am
August 23, 2018 at 4:40 pm
Viewing 15 posts - 2,251 through 2,265 (of 2,645 total)