do like this uname="blah" sna=""blahblah" sta="Q"
Select UserName,Sname,MobileNo,Msg,Typ,Lan,Stat from Generate where (Username='" & uname & "')" & AND (SName='" & sna & "')" & And (Stat='" & sta & "')" ----- Original Message ----- From: "David Shen" <[email protected]> To: <[email protected]> Sent: Sunday, March 29, 2009 12:54 PM Subject: [DotNetDevelopment] Re: Sql Insert-Select Does Select UserName,Sname,MobileNo,Msg,Typ,Lan,Stat from Generate where (Username='blah') AND (SName='BlahBlah') And (Stat='Q') returns anything? On Sun, Mar 29, 2009 at 5:23 PM, Jeena Ajiesh <[email protected]> wrote: > Hi all, > Please help me in this SQL Query. Wen i run it, it shows "Query has > executed > Successfully" > But the row has not been inserted into the table. > > Here is the Query: > > Insert into SSM > (Username,Sname,MobileNo,Msg,Typ,Lan,Flag) > Select UserName,Sname,MobileNo,Msg,Typ,Lan,Stat > from Generate > where (Username='blah') AND (SName='BlahBlah') And (Stat='Q') > > Can anyone help in this situation. > > -- > **************** > Regards, > ♪♥♫♥Ĵєєήǎ ♫♥♪♥ > Email: [email protected] > [email protected] > [email protected] > > -- Best Regards, David Shen
