Seth,

The way I understand the...

CTRL + L will show an estimated Execution plan. CTRL + M will show the actual execution plan when you run the query.

There are some videos on Execution plans...

David Lester (12/26/2008)

---

Jack Corbett (12/9/2008)

---

Looks like someone to some persons fell in love with UDF's.

Developer1 - "Hey why write it over and over again, we can encapsulate it...

Garadin (12/26/2008)

---

:hehe: Mornin Jack :hehe:

I had an almost identical post typed out, then decided to try to get used to the new 2005 stuff that I always ignore....

I think this will work:

select

apprentice_id,

agreement_id

from

apprenticeshiptraining.tbl_apprentice_agreement AA Join

(

Select

apprentice_id,

Max(start_date) as max_date

From

apprenticeshiptraining.tbl_apprentice_agreement

Group By

apprentice_id

) MA

AA.apprentice_id = MA.apprentice_id And

AA.start_date = MA.max_date

It is difficult to find that information as a stored procedure that returns rows can also insert, update, or delete rows or include insert, update, and delete statements on temp...

Apparently nothing is off topic for this thread.

In regard to retirement, a lot of companies are just taking the lead from the U.S. government which borrows from Social Security, which...

You can also take a backup using SMO in your C# application. Check out this video at jumstarttv.com for the how-to.

Duplicate post. Please post answers here

Please don't post multiple times at it fragments responses and wastes some people's time as you may get similar responses on each thread.

Or's will also often cause table or index scans.

I'm not sure what your question is. If you want to limit access to your database you do that through logins (access to the database server, which can be...

Duplicate post, please post answers here.

Duplicate post, please post answers here.

I would say can't. This is something the retirees...

Use an Expression, something like this:

=IIF(Fields!State__Name.Value Is Nothing, IIF(Parameters!DIMBRANCHMASTERStateName.Label = "ALL", "N/A", Parameters!DIMBRANCHMASTERStateName.Label), Fields!State__Name.Value)