Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. trpnbillie

    SET QUOTED_IDENTIFIER = ON (in sproc)

    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.
  2. trpnbillie

    SET QUOTED_IDENTIFIER = ON (in sproc)

    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...
  3. trpnbillie

    How to create comma separated list

    The loop is beautiful. HUGE THANKS!!
  4. trpnbillie

    How to create comma separated list

    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...
  5. trpnbillie

    How to grant access to view jobs

    Thanks folks - this site is niiiiice!
  6. trpnbillie

    How to grant access to view jobs

    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?
  7. trpnbillie

    How to grant access to view jobs

    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...
  8. trpnbillie

    Local Temp Tables in Stored Proc - is it safe?

    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...
  9. trpnbillie

    Local Temp Tables in Stored Proc - is it safe?

    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...
  10. trpnbillie

    How to Compare 2 tables for equality

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

    How to Compare 2 tables for equality

    ...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...
  12. trpnbillie

    Assigning Parameter to Dynamic SQL statement

    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...
  13. trpnbillie

    Assigning Parameter to Dynamic SQL statement

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

    How to identify and return characters in a field

    ...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
  15. trpnbillie

    How to identify and return characters in a field

    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!!! :)
  16. trpnbillie

    How to identify and return characters in a field

    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...
  17. trpnbillie

    How to identify and return characters in a field

    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...
  18. trpnbillie

    Receiving VBScript Error - cannot fix and stumped!

    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...
  19. trpnbillie

    Receiving VBScript Error - cannot fix and stumped!

    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...
  20. trpnbillie

    Receiving VBScript Error - cannot fix and stumped!

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

Part and Inventory Search

Back
Top