I'm needing to convert some varchar figures to decimal for sums, but can't quite find an example that works... the second block of code just returns the list of...

This is a bit like saying I have something that I want to store in the pantry.  What type of container should I use?

What does the data you're trying to...

With the understanding that I've never tried it before, have you tried using EXEC?

Ran into an issue that caused me some issues.  It seems that when I backup a database that is in FULL recovery mode and restore it to a different...

Although sometimes unavoidable, killing sessions is actually a pretty dangerous thing to do in SQL Server.  Killing sessions automatically is about 3 times worse.

Prevention and privs control is the best...

Hello,

In my application, with a DB running on SQL Server 2012, I've got a job (scheduled task) that periodically executes an expensive query and writes the results to a...

Yep, and when I look over both documents, they seem in some ways contradictory.  The problem is that TABLOCK can lock up other metadata things in the db, so...

+1000 Either that OF he has an explorer window open and maybe has even clicked on one of the files OR he...

https://techcommunity.microsoft.com/t5/sql-server/sql-server-2016-minimal-logging-and-impact-of-the-batchsize-in/ba-p/385537

Table IndexesRows in table   Hints               With or Without TF 610...

solved!

1st friday : (SELECT DATEADD(DAY, DECODE(EXTRACT(DOW FROM START_DATE), 0,5, 1,4, 2,3, 3,2 ,4,1, 6,6, 0), START_DATE) third_friday FROM (SELECT date_trunc('month',current_date) START_DATE))

2nd friday : (SELECT DATEADD(DAY, 7 + DECODE(EXTRACT(DOW FROM...

Practically, methods like that work just fine.  Technically, it bugs me because the "Tally" sequence generator had to build 366 values  and then were filtered out to just 12 quite...

As you said, the Order By will be ignored if it's not needed.  It costs nothing to include it just to be sure.

As for TABLOCK not being required, the 2nd...

On a...

Can you post your code, Scott?

Fwiw in 2021.  In the FROM clause use dbo.fnTally and CROSS APPLY (both twice) to hierarchically generate the first 7 days of each month.  Then in the WHERE clause...