You could try something like this,

CREATE TABLE #TESTY(COL_ONE datetime) 

DECLARE @seconds int = 31536000 --total seconds in the year

INSERT INTO #TESTY
SELECT DATEADD(second, CAST(FLOOR(RAND(CAST(NEWID() AS varbinary )) *...

Middle

I'll add one, please add the forum a post is in back to the most active threads page, it's really helpful.  I know you're going for a more mobile centric...

You can add multiple schedules to a job, just make two schedules that run M-F one that runs at 7 and and on 1PM.

It's as much MS fault as anyone for being so inconsistent with when you need a semi colon.  For example with CTE's they could have made it so...

It's as much MS fault as anyone for being so inconsistent with when you need a semi colon.  For example with CTE's they could have made it so CTE's also...

Run just the query from the first CTE 🙂

Well what happens when you run this,

DECLARE @Attachments VARCHAR(MAX);

SET @Attachments = 'E:\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Scripts\QMfiles\MedQuest\BH_' + 'CONVERT(VARCHAR(12), GETDATE(), 107' + '.xlsx) '

SELECT @Attachments

Great name for a beer!

  Yay. Um, so what are those points redeemable...

• This reply was modified 6 years, 5 months ago by ZZartin.

Indexed views can't reference other views, you'll have to put the nested view directly in the view you want to index.

There doesn't seem to be a recent posts option anymore, there's only latest topics which doesn't help if you want to see recent responses to older topics.

Does the Latest Topics section not include this thread/forum anymore?

One option might be to normalize all your dates back to starting on 1/1 then just use DATEDIFF week, there's some trickier here since you'd have to account for leap...