In general, I too prefer NOT EXISTS, although SQL will often generate identical plans for either one.

It's definitely strongly preferred whenever possible to have an index to support the lookup,...

I think this gets you pretty close, w/o having to resort to CLR:

WHERE

--one +/- optional, but must be first if used

PATINDEX('%[+-]%', varcharValue)...

SQL Server explicitly discards SET values at the end of the stored proc and, AFAIK, there is absolutely no way to change that directly.

You could, of course, save the desired...

Please substitute your db name below,

and your table name in BOTH places below where <your_table_name> appears, then run the queries and post the results.

USE <your_db_name>

SELECT

GETDATE()...

You likely should have (at least) column A as the clustered index on the table.

Would need more details and info to determine if another column(s) should be in the clus...

SQLKnowItAll (7/9/2012)

---

ScottPletcher (7/9/2012)

---

SQLKnowItAll (7/9/2012)

---

What am I missing... How can it...

Join...

I agree that the fillfactor should be carefully reviewed, but not...

OmegaZero (7/6/2012)

I'm not 100% sure of how to handle the AccountSales table though - since if I did it by id the dates would not match up correctly if joined...

Dev (7/9/2012)

---

ScottPletcher (7/9/2012)

---

False, of...

False, of course. ...

Dev (7/8/2012)

---

As a matter of fact, you can’t avoid the scans (table / index) in real life or practical scenarios but you can minimize those and that’s what Gail is...

I suggest avoiding "WEEK" or anything that could or does rely on SQL settings such as @@DATEFIRST (I don't think WEEK actually does, but I think it does always use...

case

when degree1id = "@Degree" then (select d.Name from AcademicExperienceTypes d where p.Degree1id=d.Id)

when degree2id = @Degree then (select d.Name from AcademicExperienceTypes d where p.Degree2id=d.Id)

when degree3id = @Degree then (select...

case

when degree1id = "@Degree" then (select d.Name from AcademicExperienceTypes d where p.Degree1id=d.Id)

when degree2id = @Degree then (select d.Name from AcademicExperienceTypes d where p.Degree2id=d.Id)

when degree3id = @Degree then (select...