anand.narayanan 87953 (6/21/2012)

---

Lynn Pettis,

Thanks for your reply...

again a strange thing!! that is i am able to retrive the results for top 7 records. where as

if i queried 'Select top...

Please post the DDL, sample data along with the expected output

If you are not clear on how to do this, refer the link in my signature

dwain.c (6/15/2012)

---

Kingston Dhasian (6/15/2012)

---

Yes, the OP's statement actually made us...

Yes, the OP's statement actually made us feel unhelpfull

So, I...

You are over thinking the homework assignment. Plus, having worked in a public school district, if there was a gap in years, I would assume that the mobility indicator...

Lynn Pettis (6/15/2012)

---

Kingston Dhasian (6/15/2012)

---

surma.sql (6/14/2012)

---

Thanks for reply. but please help me.

i need help, thats...

People here...

Its probably defined in the code the OP has

The OP has only posted the final SELECT statement

You will probably need Dynamic SQL for that

Post some sample data and the DDL of the the tables involved

This will make it easier for people to come up with tested...

I am not sure why you are having the HAVING clause

Even if one of the months have values, you will get 13 columns and not 3 or 4 as you...

Creating a script out of a stored procedure is not that difficult

You can replace the parameters in the stored procedures with variables and assign these variables some values as below

DECLARE@ids...

I think you are looking for a "Catch-All" query

Have a look at the link below which gives some ways to do it

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/

bommaka.nagarjun (5/11/2012)

---

I want to update all datecolumns or shift dates to recent so that it would appear as fresh data. I want to have generic query which does this for...

Your code should be changed like below

SELECT ISNULL(SUM([TedadTarhModiriatTafzili]), 0)AS TedadTarhModiriatTafzili ,

ISNULL(SUM([TedadTarhModiriatJame]), 0)AS TedadTarhModiriatJame ,

...

pdanes (5/10/2012)

---

I tried it and I do get only three rows, but what determines which one is returned by the RowNumber function? Or rather, what does the RowNumber function mean?...