Any idea why I'm not able to get the columns in row format ???

Govinn - I'm not able to recreate this (the QA trick...)

Also, could you please tell me what "where 1 = 2" does ?!?! Thanks!

Many ways to skin this cat - <;-) - though object browser is the way to go for a quick dekko!!!

Today is a rushed day at work so addressing what seem to be the core questions...

1) "how do I identify those indexes that are referenced by a primary key?"

You could...

Remi - This is what I get from reading the procedure (& I could be way off mark...)

something like:

Update Jan

Set Status = 1

Where F1 = 'D' AND Len(SSN) > 0

I'm...

Check your Sql Server Service Manager - is it running ? Is it configured to start automatically ?

Surya - I thought you said that you were selecting 7 columns in all - is this not doable with a view - I think a view would make your...

Ha!Ha! - No Remi - I'm still talking about Quarters...

However, I'll pass this on to my colleagues (who are all coincidentally "guys") & see if it has any effect!

That is totally amazing - 'cos I've seen your responses in almost every single forum - ranging from "Administration" to "T-sql", "Access" to "Backups"...quite impressive! I don't think your DBA...

I assure you that none of my actions are illegal - however, I cannot (& will not) reveal classified information....suffice it to say that I'm consistently getting "standing up" results...

Hey - you started it first (shattering the dream ie) - you said that you couldn't change the ansi standard...and compared to you I'm waaaaaaaaaaaaaay down on the DBA ladder,...

I'm working on it Remi (Sheesh - what a slave driver!!!)

I told you that it's really tough for me to make it heads or tails....

Surya - looks like the only thing you can do is build separate Selects based on @sort value...

eg:

IF @sort = 1

BEGIN

Select Col1, Col2, Col3

From Table

Order by...

"Heads I win, tails I don't lose"....

It is IMPLICIT that anything else - I win!

p.s: The obvious need never be stated Remi! <;-)

okay - since we're geographically miles apart I'll toss the quarter and let you know what the result is....

p.s: I am very good at making quarters land standing up...<;-)