Not sure why you are looping and then running the job based on the client records.

Instead have a single job that would loop through the client records and run the...

xp_blowfishencrypt and xp_blowfishdecrypt will not work in 64 bit environments.

Please stay away from this encryption method as you may have trouble when migrating to a 64 bit box.

Why not use...

sysschedules

If this is a time one thing then you can get the output of the string and execute the SQL statement

If this needs to happen dynamically then you can do...

look at this this sample example and generate your SQL statement for creating table using COALESCE

People Table

---------------

Mary

Joe

Fernandez

DECLARE @Names VARCHAR(8000)

SELECT @Names = COALESCE(@Names + ', ', '') + Name FROM...

May be this article would help

http://support.microsoft.com/kb/306269

Use the combination of charindex and substring function to get the results you want and then perform the linking

http://msdn.microsoft.com/en-us/library/ms186323.aspx

http://msdn.microsoft.com/en-us/library/ms187748.aspx

Try to use the linked server option.

listed below is a nice article

http://www.aspfree.com/c/a/Microsoft-Access/Configuring-a-Linked-Microsoft-Access-Server-on-SQL-2005-Server/

Please refer to http://www.sqlservercentral.com/Forums/Topic458542-148-1.aspx

Relating to client libraries there are: DBI/DBD, ODBC, JDBC, Open Client from Sybase, FreeTDS

You could do that and verify if the rows are listed in order you had inserted.

Then open a cursor, loop through the records ordered by this identity field and update...

Now Parthi's previous comments comes into play, may be you have another field in the table that identifies how the rows were inserted. List the entire table definition

Am I am guessing your question correctly, when ever a Null is encountered in the group field, you want to update the null to previous records group value which is...

I am not sure what error you get, but check the max length of the "Text" field and if it's higher than the "varchar" value you are setting it to...

please login as the user that starts the sql agent and run the exe or the bat file manully to store the key in the cache. So next time job...