I've worked with both styles - a POS system that stored the images for cash register buttons and pictures of products, and a traffic management system that stored both the...

I would use a calendar table for the cutoff dates. Have each row contain the start (last cutoff) and current cutoff to you have a BETWEEN type range for...

simorgh,

A set based update works on the SELECT statement, which is processed and returns a record set before any updates are actually done. If you expect a cumulative sequential...

Great article Craig! I've been put off by job postings that have the SQL God requirement in the past. I'll never look at job postings in the same...

I would use some variables in the query to make it easier to read and do the whole thing in one pass rather than use 3 subqueries.

Something like:

DECLARE

@TheDate...

Surev,

Your fiscal table should have enough columns defined to determine this...

faisalkhanbk (4/4/2011)

---

i got the idea out of it but i am bit confused because in our case its Date difference not the between, i cant give hardcoded date there to...

Brandie,

My rule of thumb on CTE vs derived table (when they are functionally equivalent) is use whichever is easiest to read in the code. I use both liberally and...

Giles,

As Kevin pointed out you're probably not going to get anything better than a table scan from the way your data is distributed in the table. You want to...

Dave Ballantyne (3/27/2011)

---

Assuming that you have a finite list of ID's used, you can use cross apply with TOP, as demonstrated at the end of this article http://www.sqlservercentral.com/articles/T-SQL/71571/

As you want...

Tim,

Was the view Schema Bound?

Todd

I actually had a strange problem about 5 years ago that is somewhat similar. The database was 2005 before SP2. There was a table that had various VARCHAR...

A simple way to delete dups that works on versions earlier than 2005 is:

DELETE EMP

FROM Employees EMP

INNER JOIN

(SELECT MIN(EmpID) AS EmpID, EmpName

FROM Employees

...

Aparna,

Yours is a classic example of reporting on something that is usually there, but for some reason isn't there now. I've seen what you call pseudo records (I call...

There's another way to do this without joining Inserted to Deleted and it reads a little easier on the eye. This one gets the old values before the update....