No. I am using sql2000.

Garadin,

Whatever format...

Greg,

is there any other work around to do the same ?

Lynn,

Well 🙂

A team around 10 members developed my project three years back. They had written more than 400 stored procedures. They mixed upper case and lower case in each and...

Greg,

You are absolutely correct. I asked to change the report format so many times. But he is expecting the same report format.

Gila,

I dont want to change all the text into lower case.

Just i want to change upper case keywords into lower case.

say for example,

1)

SELECT eno

from emp

expected result:

select eno

from emp

2)

SELECT...

Greg,

Thanks a lot for your help & effort taken for providing me the solution. I really appreciate your effort and help.

But i think you have hardcoded the managerid's. But it...

Anybody want to share their idea apart from VSS method ?

Jeff,

Actually i have used your first method to sort the data.

SELECT/UNION ALL and and ORDER BY clause in the last select. It works fine.

Can you help me to get the...

Dugi,

Good idea 🙂

I have to change more than 400 stored procedure. So i am looking some common code to do it.

The way you did it is fine, Karthik... only change I would make is to change all the UNION's into UNION ALL for performance and data integrity reasons. UNION...

Greg, forgive me for posting wrong code.

Please find the correct code.

CREATE TABLE dbo.mgr_calc

(

sID ...

Oh..Sorry !

Please find the correct one.

CREATE TABLE dbo.mgr_calc

(

sID varchar(15)...

Anybody want to add some more points ?

Any inputs ?