HI, this is how it worked for me INSERT INTO TABLE2 (COL1, COL2, QL_FLG, ST_FLG, PA_FLG) (SELECT COL1, COL2, DECODE(INSTR(COL2,'QL'),0,0,1) QL_FLG, DECODE(INSTR(COL2,'ST'),0,0,1) ST_FLG, DECODE(INSTR(COL2,'PA'),0,0,1) PA_FLG FROM TABLE1); Thank you so much for your help.

File Transfer Protocol also known as FTP. The linux box runs a FTP server and the client box runs a FTP client.

It's not really possible, because ASP.NET doesn't work that way. On the client side, it's just HTML and javascript. Christian Graus - Microsoft MVP - C++ "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

if you need return output parameter from stored procedure you must to set word out beside parameter for example declare @Time1 datetime declare @time2 datetime set @Time1 = '1/1/2001'--if this output parameter set out beside it set @Time2 = '1/1/2001' ============================================== exec dbo.Usp_Rpt_Proc1 @time1 out ,@Time2 out but this solve must used if the two output parameter CREATE PROCEDURE dbo.Usp_Rpt_Proc1 (@StartDate DateTime output,@EndDate DateTime output) =============================================== exec dbo.Usp_Rpt_Proc1 @time1 ,@Time2 out but this solve must used if the one output parameter CREATE PROCEDURE dbo.Usp_Rpt_Proc1 (@StartDate DateTime ,@EndDate DateTime output) ==================================================== exec dbo.Usp_Rpt_Proc1 @time1 ,@Time2 ,@output out but this solve must used if the one output parameter CREATE PROCEDURE dbo.Usp_Rpt_Proc1 (@StartDate DateTime ,@EndDate DateTime ,@output datatype output) if you need any thing reply with regards Rami Abd Alhalim

hi originSH , Thanks for your reply but my requiremet is store all the date ito one column i cannot chop up teh thing because i am getting that text dynamically..The text in the form of html Thanks in Advance Chandra Gupta

http://msdn.microsoft.com/netframework/programming/breakingchanges/[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips

Instead of doing alert messages using the onload function why don't you look at the Page.ClientScript.RegisterClientScriptBlock method in the code behind page. Michael I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious. Vince Lombardi (1913-1970)

u can use command builder dim da as new sqldatadapter("select * from emp",cn) dim cmb as new sqlcommandbuilder(da) dim dt as new datatable da.fill(dt) dim dr as datarow() dim i as int = 0 while i < grid.items.count -1 dr = dt.select("AccountId=" & s1) if dr.length > 0 then dr(0).item("AccountCode") = s1 dr(1).item("Description") = s2 end if i +=1 end while da.update(dt)

http://msdn2.microsoft.com/en-us/library/a4ey25we.aspx[^] only two letters away from being an asset

Oh, I understand what you mean now. Let me think about how to do it, I have an idea but I want to think about it to make sure that it will work. The only way to speed up a Macintosh computer is at 9.8 m/sec/sec.

that's wasn't i mean..but this is kind of situation( i even contradict with mt lead )we must and should expose all the boxes to be editable though he may update 1 or 2 boxes of many(ofcourse it's a unnesessary burdon,i know) ..anyhow thanqs for ur kind and honest replay:rose::rose:

hi patel....thanqs,,the code snippet worked for me

while retrieving data to grid use select query which returns no rows like SELECT * FROM tblA WHERE 1 = 2 this should work (I've not tried this.) Regards KP

Hi, To get all the user tables for the selected database, u have to connect to that database and query its "sysobjects" table. "select name, id from SysObjects where Type = 'U'" This way you can get names of all the user tables of the selected database. Thanks and Regards, Chetan Ranpariya

Thanqs Krish...this code sippet is quied for my requirement

thanqs imran,,it's worked fine thanqs once again:-D

You can use wizard control available in .net, and on movenext command of wizard you can save the answer in db and can expose the next question. Many Thanks, Adnan Rafiq muhammadadnanrafiq@gmail.com

yuvachandra wrote: i have a path D:\New\NewFolder.Now i have to select the item which contains the text NewFolder.How can i do it. I am assuming D: is root Node and you first have to find New Under it using GetChildItem and GetNextItem and comparing the text with New, after you find Text New, GetChildItem and GetNextItem to Find NewFolder, using TreeHandle you got from search use SelectItem select that item "Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow cheers, Alok Gupta VC Forum Q&A :- I/ IV Support CRY- Child Relief and You