Viewing 15 posts - 91 through 105 (of 132 total)
Hi!!!
Thanks for your patience!!!!!!!!!!!
I know the values in the columns other than PK columns , having different values then that are not eliminated (Duplicate Records issue) but if the values are...
September 22, 2005 at 6:24 am
Hey GilaMonster !!!!!
I really appreciate what you did, just one little thing
that if i have more columns in both table that are not having primary constraint then what modification should...
September 22, 2005 at 5:43 am
Hey Sushila and my dear friend RGR'us
Thanks for ur interest , now i cleared everything @ that datatype!!!!
Thanks for your reply from both so heavely!!!
Shashank
September 21, 2005 at 9:54 pm
hi!!
you canot use iif in sql server but you can you equivalent to iif as CASE or DECODE
and your code might be like this
SELECT clinno, ssn, dateof, Depressed = case...
September 21, 2005 at 1:58 am
Hey !!!
Thats worked fine!!!
Regards
Shashank
September 6, 2005 at 9:46 pm
Hey !
Any way thanks sushila
Take care
Shashank
September 3, 2005 at 12:14 am
Hey
i got your point !!!
just one small question if i want the same output in EM as i got in QA then will...
September 2, 2005 at 5:54 am
Hello friends
philcart has given me some code like
UPDATE empt
SET M_Name = CASE WHEN JobCount > 1 THEN 'Y'
ELSE 'N'
END
FROM empt ,
(
SELECT COUNT(JObID) as...
August 30, 2005 at 4:00 am
Hey..philcart
You really makes me smile
Thanks very much that is...
August 30, 2005 at 2:42 am
Hey Gilamonster!!
I got the things!!!
That makes me smile
Thanks
Regards
Shashank
August 19, 2005 at 12:37 am
Hi gilamonster!
ALTER PROCEDURE lnt.textt
@qurstr VARCHAR(10)
AS
DECLARE @in AS VARCHAR(10)
DECLARE crs_cc CURSOR FOR SELECT job_id FROM empt
OPEN crs_cc
--FETCH NEXT FROM crs_cc INTO @in
WHILE @@fetch_status = 0
FETCH NEXT FROM...
August 18, 2005 at 10:40 pm
Hello friends!!!
Thanks for your help , the only biggest mistake i was doing in procedure was
I write my fetch (fetch next from crs_cc INTO @in ) statement before @@fetch_status =...
August 18, 2005 at 2:45 am
Hey!
I just wanted to know how cursors are working here nothing more than that
But I am getting one problem , I created that procedure like below--------
CREATE procedure lnt.textt
@qurstr varchar(10)...
August 17, 2005 at 2:37 am
Hey chris !!!
I got what i want
Thank you so much
Shashank
August 16, 2005 at 3:47 am
Viewing 15 posts - 91 through 105 (of 132 total)