Yes, that should be functionally the same.

Barkingdog (4/18/2010)

---

The following extract is from http://msdn.microsoft.com/en-us/library/ms175976.aspx

...

Shouldn't the

IF @@TRANCOUNT > 0

COMMIT TRANSACTION;

GO

test occur after BEGIN TRANSACTION but just before the "BEGIN...

What Jeff said....

(I was just about to...

vaibhav.tiwari (4/17/2010)

---

mister.magoo (4/16/2010)

---

yes, you are converting the date to a varchar and then comparing that - which will just be an alphanumeric comparison.

You need to convert your reference date, which...

In one of my previous jobs, we used to have extra holidays if you charged 18+ days in a month as well as cash bonuses and believe me those holidays...

yes, you are converting the date to a varchar and then comparing that - which will just be an alphanumeric comparison.

You need to convert your reference date, which are currently...

Thanks for the interesting Article!

I wonder did you ever take a look at this blog post about using DMVs to analyse store proc usage ?

Five DMV Queries That Will Make...

Good, thanks for letting us know it helped

"Your web app" - that means you need to read Gift Peddie's previous post ...

You're welcome - thanks for the feedback.

Matt Miller (#4) (3/26/2010)

---

You can also do it this way:

AND (P.PAprojmngrid =

CASE

WHEN @Discipline = 'Surveying' THEN '07'

WHEN @Discipline = 'Civil Engineering' THEN '04'

WHEN @Discipline = 'Geotechnical' THEN '03'

WHEN...

Hi, it is not clear if you mean you need the Report Viewer (as in the previous reply) or the Reporting Services Client Printing control....

so in case you wanted to...

Matt Miller (#4) (3/26/2010)

---

While I do see the problem - isn't this a problem with any subquery (i.e. not specific to CROSS APPLY) ? Without fully qualifying every instance...

LHendren (3/26/2010)

---

I have a GridView that I am trying to display projects by Project Manager ID's via a DropDown pick. Only some of the projects have been assigned Project...

Paul Morris-1011726 (3/26/2010)

---

Looks good... let me play with it to see for sure.

I do have a question, so as to understand this better... What is happening in this piece of...