Not necessarily.  The difference is that the first query has a function being used on the left side of the >= where as the second doesn't.  The query engine is...

Actually, problem with the screen I was using.  On my computer I can see it all.  Looks like I need to replace some hardware at home.

While installing SQL Server 2005 Developer Edition on one of our development servers, I ran into issues applying SP 1.  SSIS would not start after applying the service pack.  In...

Based on your test table, there both queries will do a table scan.  There are no indexes defined on dbo.TestPerformance, so SQL will have no choice but to scan the...

I don't see any problem with recertifying periodically.  It ensures that individuals still have the necessary and relevent skills for the certification.

As both a USSF and HSSO certified Referee, I...

Congrats to SSC for reaching the 400,000 members mark!  It is a tribute to support and guidance that its members provide to each other.  I have found answers to many...

I have found the problem and have corrected it.  Turns out SSIS was trying to phone home due to changes in the Cyrpto providers (or something to that effect) and...

Just for the heck of it, change the LEFT OUTER JOIN's to INNER JOIN's in the query Lowell gave you.

The following is based on the original post, give it a try:

create table dbo.Part (

    PartId char(2),

    QtyBreak smallint,

    Price money

)

go

insert into dbo.Part (PartId, QtyBreak, Price) values ('p1',100, 5.00)

insert into...

I have a possible suggestion for a change in your process, but I need to have one question answered first: Is it possible for a CLOSED invoice to be REOPENED?

Sounds like a permissions issue with the directory or the share.

Have you tried dropping the the distinct from the derived table?

truncate table #tablename

Your problem now may still be permissions, but share permissions, not file permissions.  We had an issue with a new hire accessing our VSS.  He had permissions to the file,...

Is it me, or does it appear that you haven't found someone that truely fits with this company?