Hi, please can anyone let me know the date formats in sql server for this query. my table structure is" PDate PMonth PYear 10 05 2007 03 05 2004 12 10 2007 o1 12 2005 now i have to retrieve the records based on some specified dates. for example, i want the records which matches "12/10/2007" i know how to write the code for these 3 columns to format (mm/dd/yyyy)using C# & vb.Net but i want to know how to write using Tsql Thanks, Suketh

hi Friends, i am working on ASP. i just updating my skills ASP to ASP.NET (using MSDN, and some other sites). some one asked me what is ASP.NET Layout? i googled for ASP.NET Layout, but found different concepts on this ASP.NET Layout. please can anyone give me the idea about this ASP.NET Layout? thanks in advance, Suketh

thanks Apurva. do u thinkis this statements are correct?? a DataSet will have all the data locally. However, this is both a curse and a blessing. It means all the data will have to be fetched before any work can be done, which may increase latency and memory usage substantially. The Recordset is cached behind the scenes, so there will only be roundtrips to the server when needed to refill the cache. BTW, in .NET the equivalent of a Recordset is the SqlDataReader (or equivalent for datasources other than SQL Server). It can return multiple results, but you have to process them one by one in order. Most of the time a DataReader is the fastest method. if u know more points let me know thanks again Suketh

hi, **Creating Threads :**Create new instance of Thread object. Thread constructor accepts one parameters which is delegate Thread dummyThread = new Thread( new ThreadStart(dummyFunction) ); Executing Thread: To run this thread us the method start provided by Threading namespace DummyThread.Start (); Joining Threads: There is always the requirement to join thread specially when a thread depends on some other thread for completing its task. Lets assume that DummyThread has to wait for DummyPriorityThread to complete its task and then run again. In this case we need to do the following: DummyPriorityThread.Join() ; Suspending Thread: This will suspend the thread for the given number of seconds DummyPriorityThread.Sleep(); **Killing Thread:**When there is a need to kill a thread use the following to achieve the same. DummyPriorityThread.Abort(); hope this will give u some idea... thanks, Suketh

Hi, please can anyone tell me the diffrences b/w Dataset & Recordset? Thanks, Suketh

Hi, can anyone tell me how to write the code for this: If any number stored as a string, how can we convert the string in to number. I mean number 18 stored as a string. I want to retrieve this string as number. How can I write the code for this? thanks, Suketh