Bloody hard and tedious work awaits.

You have to update all the data and find the different variances for the company names. Worst possible problem to have. Follow the steps outlined...

I think Sarvash hit the issue with the single quotes.

Instead of "3/3/2008" in your SQL code. It should be '3/3/2008'

Single quotes define a string, not double quotes, in TSQL.

That's a huge collection of really fundamental questions that just aren't going to be answered easily in a little post in a discussion group.

In terms of database design, you should...

Yeah, Brandie is right, kick your monitor "accidently" across the room. Keep Mr. Murphy happy!

I am definately going to try the "Fear is the mind-killer" chant next time we're deep...

Ah, well, that makes sense then. Still, I think you'd be able to avoid the scan. Look at the execution plan and see what criteria are being used by the...

TheSQLGuru (3/7/2008)

---

I guess someone has to play devil's advocate here, so here goes:

Brandie, you are totally off the mark. Do whatever you can to make the most money so...

All you can do is call them on it. If you're not satisfied with their answer, then evaluate your options.

Based on the query above, I'm seeing slightly different results. I'm getting an index seek on the userlogin when I've got it indexed and a scan on the tableofdates (shock,...

And COUNT and possibly GROUP BY

The company I'm at currently has an annual review process. You may or may not get a raise, but you'll at least know what the boss thinks of you and...

Did you try putting an index on the time table? I think it'll make a bit of a difference. Same with your user login table.

May as well pile on...

Good Job Brandie. I couldn't agree more.

Enjoying the work allows you to bring passion to the job. That passion will translate to accomplishments within...

Use the OUTPUT clause from the DELETE statement to insert the data as it gets removed.

From what you described, I'd move on to coding now. As you code, when you get portions of the app working, run Profiler while you test the app so that...

I tried it. It worked.

I took your table & loaded it with data (still beta testing Red Gates SQL Data Generator). I then created this table:

CREATE TABLE tableofdates

...