Recent content by mikej336

Kaht, I managed to get it running. I took about an hour and 2 minutes to process 31 k id's. That seems slower then what I expected but I apprecieate all the help. Here is what I wound up with.... declare @c varchar(25) declare @d varchar(2000) declare @e int declare cur cursor for select...

SQLSister, I agree but unfornuatly the data feeds an imaging system that uses a single field. Kaht I will take a look and see if I can get your example working today. Thanks Mike

There are 10 accounts with over 100 phonenumbers, the highest number being 317. There are 62549 total phonenumber records. Thanks again Mike

Hey Perly, I am getting... Msg 530, Level 16, State 1, Line 1 The statement terminated. The maximum recursion 100 has been exhausted before statement completion. Any ideas? Thanks Mike

SELECT actbrch,[SVCID] FROM [400_Metafile].[dbo].[yad_srvmast] where actbrch = '0000000001ACCT' actbrch SVCID --------------- ---------- 0000000001ACCT 1234635036 0000000001ACCT 1234635003 0000000001ACCT 1234632071 [SVCID] [nvarchar](10) COLLATE [ActBrch] [nvarchar](15) COLLATE...

Thanks guys, for your help I am learning alot. But I am still missing a few things. Let me restate my problem. I have an existing table A. It has a all phonenumbers associated with different customers by customer ID. One record per phone number. Customers may have any number of numbers...

2005 Mike

Sorry, I did not specify. I need the all the records from the first table to be updated to the second table. Thanks Mike

I have a table, ID Phonenums --- --------- 123 1231231234 123 1231231234 123 1231231234 123 1231231234 123 1231231234 both text fields. I need to update anouther table with the above data but I need the Phonenums in a single memo field in a single record. (Preferably...

I suspect that the file not found is the batch file. I would move the file temporarily to the M:\Install_SGAD.bat dirctory and change your shell command, just to see if it works. Mike

Why don't you use a form to collect your year information. Then create a query definition then run the report based on that. Mike

Put "Pause" at the end of the batch file and see what error message you are getting. Mike

Also which application are you talking about? Mike

oops... 4. Once it is correct, delete the old text genre field from the old table. Mike

I have not used db2 but I can give you some general ideas. 1st. create a query to select distinct genres into a new table. Change the structure on the new table to add the auto generate primary key. 2nd change the structure on the movie table to add a field for your numerical genre (probably...