Viewing 15 posts - 676 through 690 (of 26,487 total)
November 8, 2018 at 1:02 pm
Create a Calendar table and use that as the central table to join the other tables using a left outer join from the Calendar table to the other tables.
November 8, 2018 at 11:04 am
Okay, just trying to help you out with the dynamic SQL side of things as I have had to write a lot of dynamic SQL where I work because of...
November 8, 2018 at 9:27 am
I am trying to get all objects created and or modified during last week, but...
November 8, 2018 at 9:00 am
November 8, 2018 at 8:54 am
Per your specs:
if object_id('[dbo].[mytable]','U') is not null
drop table [dbo].[mytable]; -- clean up my SANDBOX DATABASE!!!!!
create table [dbo].[mytable]
(
[StartDate] date...
November 7, 2018 at 4:09 pm
November 7, 2018 at 12:07 pm
November 7, 2018 at 12:00 pm
November 7, 2018 at 11:57 am
Now, show use what you have tried to solve your problem.
Also, the following is a much better way to post the DDL, sample data, and expected results, which I...
November 7, 2018 at 11:48 am
Now, show use what you have tried to solve your problem.
Also, the following is a much better way to post the DDL, sample data, and expected results, which I...
November 7, 2018 at 11:20 am
It may still need some more work as it isn't fully tested against all possible scenarios of data.
November 6, 2018 at 2:05 pm
Viewing 15 posts - 676 through 690 (of 26,487 total)