Viewing 15 posts - 16 through 30 (of 30 total)
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...
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 14, 2010 at 6:37 am
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...
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 7, 2010 at 3:15 pm
sysschedules
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 7, 2010 at 9:52 am
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...
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 7, 2010 at 9:23 am
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...
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 7, 2010 at 9:05 am
May be this article would help
http://support.microsoft.com/kb/306269
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 7, 2010 at 8:17 am
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
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 7, 2010 at 7:07 am
Try to use the linked server option.
listed below is a nice article
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 7, 2010 at 7:01 am
Please refer to http://qa.sqlservercentral.com/Forums/Topic458542-148-1.aspx
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 6, 2010 at 3:51 pm
Relating to client libraries there are: DBI/DBD, ODBC, JDBC, Open Client from Sybase, FreeTDS
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 6, 2010 at 3:46 pm
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...
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 6, 2010 at 3:12 pm
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
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 6, 2010 at 3:08 pm
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...
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 6, 2010 at 2:47 pm
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...
---------------------------------------------------------------------------------------
It begins by taking the first step.
October 6, 2010 at 2:34 pm
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...
---------------------------------------------------------------------------------------
It begins by taking the first step.
January 27, 2009 at 1:11 pm
Viewing 15 posts - 16 through 30 (of 30 total)