Viewing 15 posts - 676 through 690 (of 26,490 total)
Read this article: http://www.sqlservercentral.com/articles/SQL+Server+2012/106903/
November 8, 2018 at 1:27 pm
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
Viewing 15 posts - 676 through 690 (of 26,490 total)