Search results for query: *

I did run them and my tests showed me that one setting in ProcB did not affect the other procs. I was just looking for additional insight just in case there was any possible way. thank you.

Hello. In the same database, I want to create two new stored procedures each with different QUOTED_IDENTIFIER settings. That is: --- Script 1 creates PROC 1 first SET QUOTED_IDENTIFIER = OFF GO CREATE ProcA ...... --- Script 2 creates PROC 2 second SET...

The loop is beautiful. HUGE THANKS!!

Hi. I have a table Employee with ID, Name and Country column 1 John Doe USA 1 John Doe CAN 1 John Doe GBR 2 Sally Jo CAN 2 Sally Jo MEX I want to produce this result set: 1 John Doe USA, CAN, GBR 2 Sally Jo CAN, MEX Is there an efficient way to do this...

Thanks folks - this site is niiiiice!

Thanks Jim! Do you know if DTS packages are also at the server level? The new question being: Can I allow the user to access all sql jobs but none of the DTS packages?

Greetings! Is it possible to grant limited access to view and modify jobs? I have some sql jobs set up.. the jobs run queries against a database called "Export". I want to grant a new user full access to the export database and also allow him to make changes to these jobs. At the same time...

Thank you so much! I think I understand. Does this mean that a user cannot have more than one connection/batch at a time? (Nothing happens in query analyzer, they are connecting to SQL via middleware) If they do 2 inserts, the trigger for the second insert does not kick off until the...

Hi guys, I 'll try to be articulate on this one! On Table A, I have an insert trigger that calls a stored procedure. The stored procedure contains local temp tables (#tempTable). Considering that many records can be inserted into Table A at any time, at close intervals and by the same person...

Now don't i feel silly! Thank you so much for your help!!!

...comparing :( This is what I have: DECLARE @result varchar(300) SET @result = 'Same' --- Look for records in Test1 that are not in Test2 SELECT * FROM TEST1 X LEFT JOIN TEST2 Y ON X.ID = Y.ID AND X.Field2 = Y.Field2 AND X.Field3 = Y.Field3 AND X.Field4 = Y.Field4...

I think I got this to work. Check it out: DECLARE @Table nvarchar(100) SET @Table = 'TestTable' DECLARE @sql nvarchar(4000), @col sysname, @result varchar(20) SELECT @col = N'au_fname' SELECT @sql = N'SELECT @result = status FROM ' + @Table + N' WHERE ID = 1' EXEC sp_executesql...

Hi Everyone! Does anybody know how to assign a variable to a dynamic sql statement result? The code below works until I reach the last line where I try to assign my variable... I am very unsuccessful! ---START DECLARE @Table nvarchar(100) SET @Table = 'TestTable' DECLARE @SQL nvarchar(1000)...

...patindex(@illegalchars, escapedstring), 1), '-'), whatVowels = ISNULL(whatVowels, '') + ';' + substring(escapedstring, patindex(@illegalchars, escapedstring), 1) WHERE patindex(@illegalchars,escapedstring) > 1 SELECT @iUpdatedCount = @@ROWCOUNT END select * from @myTable

Wow. Thank you so much. The cross join indeed does the job. If you have time to share how to roll them up and concatenate them into one row (instead of separate rows), that would be awesome. Again, i thank you for taking my headache away!!! :)

Thank you for your reply! The code now is an ad-hoc query but eventually (if i figure out how to do it) would be in a stored procedure. Also, i forgot to mention that the vowels were used for simplicity. My real life problem does not involve vowels; instead it involves a rather large list of...

Greetings all! Does anybody know how to easily scan a field for a list of specific characters and then return them? I have one simple table with one field: "StringList". My table looks like this: "StringList" ----------- John Doe XYZ aeixyz try try I want to scan the...

Attempted to register CRYPT32.DLL and receive popup message: --- C:\WINNT\system32\CRYPT32.DLL was loaded, but the dllRegisterServer entry point was not found. DllRegisterServer may not be exported or a corrupt version of CRYPT32.DLL may be in memory. --- is this possibly the "differences in...

I have crypt32.dll is that the one? I also have: cryptdlg.dll cryptdll.dll cryptext.dll cryptnet.dll and cryptsvs.dll Do you think i have to register all of these? (Is there a way to tell if they are registered or will it not hurt if I register a .dll that is already registered?) Thanks so...

Hi. I inherited a website and am having problems! I receive the following error: ---------------- Microsoft VBScript runtime error '800a01ad' ActiveX component can't create object: 'CryptCOM.Crypto' /statements.asp, line 124 ---------------- The error occurs on line124, which is set...