Example Table : Cl1 Cl2 ID SecndClmnNAme Delete From Tab Where ID NOt In Select Distinct ID From Tab)

Asp.Net with C# (2.0) i am just novice user to this Gateway service, i wants to make enable my user at my site to by items and pay through Visa or master card.... What should be the my first step ? can you please help me ..... Thanks in advance... Niraj

hi...

SELECT StarRate, date FROM BasicSearch WHERE date BETWEEN '2008-06-03' AND '2008-06-05'
Order By Date

By.. Tc :-D

Hi.. Sure You Can Have This One....

@Filter int,
@theRows int output
AS
BEGIN
SET @theRows=(SELECT Count(Field)
FROM MyTable
WHERE FilterField=@Filter)
END

Hope It Will work... do Reply.. Have Nice Day.. :-D

Hi... Try This One Will Work Select Convert(varChar(20), Role) + LogInID From LogIn By Take Care.. :)

Sure you can try this One... Declare @qry VarChar(1000), @clmname VarChar(100), @tabname VarChar(100) Set @qry = (Select @clmname from @tabname) Exec(@qry) hAVE A nICE DAY.... bY... :-D

hi... Try This one.... Declare @loopId int set @loopId=1 Declare @vr varchar(100) declare @variable varchar(100) Declare @qry VarChar(1000) while @loopId<=4 begin set @vr='Q'+''+Convert(varchar,@loopId)+'' Select @variable=@vr from test print(@variable ) Set @qry = (Select @variable=@vr from test) set @loopId=@loopId+1 Exec(@qry) end Take Care .... sure there will not be any prob now if still having prob..then reply.. take care... By :-D

i do not how it is in mysql but in MS SQL you can use stored procesure.. if you want to knw abt that tellme... :)

CAn you Explore it more with Code.... I can try on it..... By

if u wants to run both qries one after another then the Solution is.... SqlQry 1 Go Sqlqry 2 Go . . . . Try Go Statement in SQL it will help you... Enjoy your coding.. :-D

hi Niraj Here , I hope this will work for you.... try this.. Select fieldnamewhich containst1t2ec as [1945] From Tablename Where year = 1945 Have a noce Day.. Stay Tune ..... Take Care.... :-D