Thanks For your solution...:-)

Rao Aregaddan.

Hi,

    Thanks allot for both...........:-)

This information is useful to me.......

Rao Aregaddan,

Hi,

   Thanks for Your suggestion.I have searched there and found so many and need order wise.That's why i have asked.

Thanks,

Rao Aregaddan.

Ok thank you....

I will go through that......:-)

Thanks,

Rao Aregaddan.

SELECT r.Renter,o.Owner

FROM A r,B o

WHERE r.House#=o.House

If a person is having two houses then how can u differentiate?

Thanks,

Hello,

   I have no idea about the financialyear function...

But tried as below...check it out...

ALTER PROCEDURE Financial_Year @Enter_Date DATETIME=NULL

AS

DECLARE @Mt INT

DECLARE @Yr INT

BEGIN

SET @Mt=0

SET @Yr=0

IF @Enter_Date IS NULL

SELECT @Enter_Date=GETDATE()

SELECT @Mt=CONVERT(INT,DATEPART(M,@Enter_Date))

IF @Mt<4

BEGIN

SELECT...

Hey Thanks,

   Thats what i want.That is only one table and the columns are dynomic.After creating the table i am adding one more column(generatedid) for sequence numbers but i dont...

It is an 'integer' field and i want to use this type of query in reports that would not display the last columns.

This is the one small task i have to do.Is...

Thanks,

Ya You are right...that would be the last column that i dont want to include in my quuery....

Table name will not be dynomic,columns will be dynomic.In that i want to exclude the...

For ex:-

I have a table with 3 columns as below

select * from emp

no name sal

2   Joe    2000.00

3    Mary   1000.00

4    Julie   5000.00

2    Joe    1000.00

1     Ram   1000.00

Now my question i want to...

Thanks for the reply...

   But i did not explain my view clearly in that....

    I want to display 99 columns with data.i think now u got wot my query is?

Thanks,

Thanks for the reply to all.....

Ohh........Finally i got the solution..Excuese me for I did not read the complete mail which is next page....

Ok...Thanks for the reply..

  But  i need the query for  dynomic purpose  ......as per my requirement we cant expect that with how many cols the table will  be created in the sp....

Regards,

Rao Aregaddan.

 ...

sorry... make it left side of the browser for the above provided link....

Thanks,