Additionally to the test data it would be nice to how you'd provide those multiple reportids (e.g. comma separated, table, xml aso).

Basically, being a little more specific what you mean...

Justin James (1/4/2010)

---

mister.magoo (12/30/2009)

---

For the sake of it, a solution which copes with new "ColumnName" values by using dynamic sql (go ahead - pork chop me or whatever you do...

The namespaces you need to declare are those used within your xml file.

In the given case it would be "ns:" and "ax29:".

The DEFAULT clause within the namespace declaration is the...

Your xml should include the namespace declaration in the first row. Something like

<ns:getPersonnel xmlns:ns="http://www.w3.org/2001/XMLSchema-instance" xmlns:ax29="uri">

Then you could query your data as follows:

;WITH xmlnamespaces(

DEFAULT 'uri' ,

'http://www.w3.org/2001/XMLSchema-instance' AS ns,

'uri' AS ax29)

SELECT...

please give us some sample data to play with in a ready to use format. See the first link in my signature for how to do it to get the...

select * from wce_history where recordedtime >= dateadd(mm,-2,getdate())

dateadd is used to calculate date offsets based on a given date. Getdate() is current date, current time. Please see BOL (Books Online,...

duplicate post.

Please continue here

Is it possible that you're confused by the "hint "Books Online"?

If so: Books Online (aka BOL) is the help system usually installed together...

The reason why the code in your first sample will not give you the expected results is your ELSE condition:

since your ELSE condition is of data type DECIMAL, SQL...

Jeff Moden (1/1/2010)

---

... Also remember that the definition of high performance "Set Based" code should not be confused with "doing it all in a single query" which may include...

Anamika (12/30/2009)

---

Actually my question is can't I use the CTE in further part of the procedure. I found the answer is 'no'. before mentioning the CTE in query...

Not true.

Count(*) will count all records in the table (Basically counting the internal id that...

Yep, I live in Germany. Right now it's...

@Gus:

Great everything turned into something "different" before the year ends. Let's hope that "different" = "better"!!

All the best for you and your family!

@Lynn:

Glad to hear that both of your...

lobbymuncher (12/31/2009)

---

Don't do it like this. Write a query which works, then encapsulate it into a stored procedure. A stored procedure is a query (or set of statements) which has...