Viewing 15 posts - 2,146 through 2,160 (of 2,469 total)
Any idea why I'm not able to get the columns in row format ???
June 16, 2005 at 1:20 pm
Govinn - I'm not able to recreate this (the QA trick...)
Also, could you please tell me what "where 1 = 2" does ?!?! Thanks!
June 16, 2005 at 1:14 pm
Many ways to skin this cat - <;-) - though object browser is the way to go for a quick dekko!!!
June 16, 2005 at 12:10 pm
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...
June 16, 2005 at 11:03 am
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...
June 16, 2005 at 10:05 am
Check your Sql Server Service Manager - is it running ? Is it configured to start automatically ?
June 16, 2005 at 7:09 am
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...
June 15, 2005 at 1:50 pm
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!
June 15, 2005 at 1:47 pm
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...
June 15, 2005 at 1:28 pm
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...
June 15, 2005 at 1:18 pm
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,...
June 15, 2005 at 1:07 pm
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....
June 15, 2005 at 12:48 pm
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...
June 15, 2005 at 12:33 pm
"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! <;-)
June 15, 2005 at 12:16 pm
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...<;-)
June 15, 2005 at 11:47 am
Viewing 15 posts - 2,146 through 2,160 (of 2,469 total)