Recent content by trpnbillie

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!!!

Hi everyone, I have two tables (with the same structure) that i want to compare for equality. Is there an easier way to do it than 2 left joins? If possible, I would like just one statement to return a single result (same or different). Unfortunately, there are 5 fields that i am comparing :(...

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)...

Thanks everybody! I tried the inner join as well and it worked with the same speed - though my tables are very small at this point! Something else and very neat that i found was this: A recursive update! It works for my purpose and hopefully it can be useful for somebody else too. Check it out...

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!!! :)