Search results for query: *

Thanks Robert. randy : )

thanks redham. however, i would like to store the result in a datetime type field. can i still use the CONVERT(VARCHAR(@DaTE),108)

Say Rajeev, How do I insert a TIME only in a datetime character minus the date e.g. 0000-00-0000 21:00:00 thanks. Randy : )

Hi, Try replacing the "=" sign with a LIKE. .Find ("QuotationNo LIKE '%10881'") This might do the trick Randy : )

I've been using it all along! I just didn't know the terminologies. Thanks a lot guys. btw, visit the Philippines sometimes. I'll bring you to places far from the Abu Sayyaf..: ) randy : )

oh shoot! : ( based on what you've told me, can you give me a substitute for set? left()? cast()? thanks man. randy : )

hello again. Can anyone help me understand in the simplest way what FOREIGN KEY means, and how it is used in a SQL statement? I've been reading about it a long but I can't comprehend. Thanks so much. Randy : )

hello guys. can anyone tell me the difference between a Sybase SQL and MS SQL? thanks. randy : )

many thanks john. stay cool.

Hello again. I'm having difficulty with the LIKE condition. e.g. CREATE PROCEDURE sp_NAME @lastname varchar(10) AS SELECT * FROM tbl1 WHERE wholename like %@lastname% How do I use a variable in a LIKE condition? I'm going to execute the SP in VB6. Thanks for any suggestion Randy : )

Thanks again Terry. MOD and DIV are functions that I use in VB6. I haven't tried them in SQL though. : )

Hello again. My fetch statement looks like this. DECLARE r_cursor CURSOR FOR SELECT * FROM rtemptable OPEN r_cursor FETCH NEXT FROM r_Cursor INTO @subdistcode,@itemcode, @qtycases,@qtypcs,@amtcases,@amtpcs,@convfac DECLARE @jj numeric, @jj1 numeric WHILE @@FETCH_STATUS = 0...

Thanks again Terry. For my last question.....hehehehe...gotcha. Randy

Thanks again Terry. Now for my final question. How do I insert the result of this select statement into a table? randy

Thanks Terry. For example I have 2 tables, the first (tbl1) contains the distinct IDNo, Name , the second (tbl2) contains IDNo, Order, Total tbl1: tbl2: IDNO Name IDNO Order Total A0001 MJ A0001 Sauce 3 A0002...

Thanks man.

Hello. I am a VB6/ADO/SQL user. I have an upcoming project and I will be tasked to use VB4/SQL. How do I connect to SQL? Could anyone give me a sample program to connect to SQL? Any help would be highly appreciated. Thanks. Randy

Hello. Can I store the values of a cursor into a temporary table? Can you give me a sampe code? Thanks. Randy

Thanks Terry but i got it figured out. the table field where I am copying the data doesn't match the field length in the source.

I created a BULK INSERT stored procedure in SQL installed in an NT station and it worked. I copied it in a Windows 98 platform and there was an error regarding "STREAM". No error description. Please help. Thanks.