When I checked the BOL i found that there is a line stating:

If a table name is aliased in the FROM clause, only the alias name can be used to...

+1 🙂

Thanks Sean for that link of Gail 🙂

This is not an Oracle forum...

It will be good if you post your query in proper forum

ChrisM@Work (7/12/2013)

You're welcome! I learn...

Thanks Chris :-),

In past also you make me learn Tally table n many things, its my pleasure to learn new things from you always.. :-P:-D

Chris, I am not clear what you did....

Will this query be work in this manner..

If a voucher is 'Active at Ho' or its status is 'Dispatched' it is correct But...

IF (SELECT COUNT(*) FROM table_name) > 2

BEgin

SELECT * from Table_name

END

ELSE

BEGIn

Print 'Min Row Cond not valid'

END

Ok I will change my code in that manner...

But can you please suggest me how can I accomplished my required query

This can be achieved using PIVOT...

Refer this link:

http://blog.sqlauthority.com/2008/06/07/sql-server-pivot-and-unpivot-table-examples/

Thanks Hanshi, I also solved in similar manner 🙂

I tried and got the solution in the below manner but I am looking if there is any other approach for this:

Declare @count int , @count1 int

SELECT @count = ...

Good question...

learn something new today 🙂

can you please post your actual query so that we can look into that

+1 🙂