The costs are just estimates. Proof in the differences between the two plans will be in the compile and execution times, and the amount of I/O.

Several things about the queries...

You basically have it. TSQL isn't the best place to worry about formatting data. Convert is a pretty good method. But if you really need to break it down, take...

george sibbald (10/27/2008)

---

no,no,no, no fees to join sqlservercentral, ever, it would ruin it.

People have a problem, they do a search, a post from this site pops up, and voila there...

Are you sure that it's not a view or a table valued function?

Is there an INSTEAD OF trigger on the table (if it is a table)?

If you are posting answers to questions out on the forums (or, in my case, trying to), you have to be approaching it from a place of enlightened self-interest. Yes,...

Sure sounds like parameter sniffing. Since it's 2005, you might try using the OPTIMIZE FOR method to get good execution plans.

You might try setting these values into two other...

For a little help in posting a zip file and generating an execution plan:

http://www.jumpstarttv.com/uploading-an-execution-plan-to-sqlservercentralcom_385.aspx

Run a trace to capture the performance and use of the procedures. That will assist you in determining needed indexes, etc. It's especially important to do this when you're coming...

Access is Microsofts small scale relational data management tool. I wasn't sure what you meant by DBAccess. IBM DB2 has a program called DB-Access that is for querying databases.

Since we're...

I'd say keep the playing field level. A lot of posts doesn't translate into actual knowledge or special priveleges. I muck up at least as many times as I get...

I'm not sure if it matters or not, but when I downloaded the 2008 version of AdventureWorks, it installed on all the machines where I've installed it so far as...

And the query you're trying to write is an Access query, or you're using Access to connect to SQL Server and you're trying to write a SQL Server query?

The question is, what is it? This is a SQL Server forum. Is that a tool for...

By the way, what's DBAccess?

OK, you lost me. I can't tell what you're trying to do there.

You can't subtract one result set from another one and you have to have FROM clauses to...