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 Rhinorhino 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: *

  • Users: tokuzumi
  • Order by date
  1. tokuzumi

    Using exec('select...') in an update statement

    Dr. Sql, Thanks for the reply. However, there are only 3 single quotes in your reply. I would get a syntax error.
  2. tokuzumi

    Using exec('select...') in an update statement

    What is the proper syntax for using the exec('sql statement') inside of an update statement? I have an update statement like this: update #tmp_tbl set field1 = (exec('select ' + (select fieldname from fieldnametable where category = id) + ' from datatable where trans_id =...
  3. tokuzumi

    My hard drive crashed. How do I get my iTunes songs back?

    My hard drive crashed, and I had many songs from iTunes downloaded. I have another computer,with iTunes installed, and want to redownload my songs from apple, but apple wants $50 to start troubleshooting. Someone may know how to download my songs again. I have no iPod, and everything on the...
  4. tokuzumi

    putting a stored procedure directly into a temp table?

    Here is what I ended up doing: I created a UDF, that returns a table, that returns the same recordset as the stored procedure I was trying to execute. Then I used the following syntax; select * into #table from dbo.udfname(param1,param2) Using that methodology, it works like a champ.
  5. tokuzumi

    putting a stored procedure directly into a temp table?

    I want to insert the results of a stored procedure directly into a temp table. Is there a way to do that without first declaring the temp table? Using TSQL, you can do it like this; select field1, field2, field3 into #table from tablename If I try to do this: exec storedprocname param1...
  6. tokuzumi

    When calling a stored proc, how can I get the number of records?

    Well, sorry to say, but that didn't help me. It looks like the recordcount method isn't very reliable. I tested your code on a stored proc that definately returns a recordset, and it gives me a value of -1. Also my stored procedure accepts two parameters....both integers.
  7. tokuzumi

    When calling a stored proc, how can I get the number of records?

    I have a stored procedure that I need to know how many records were returned in the recordset. I have been reading up on the recordset.recordcount method, but everything seems to be for inline sql, not stored procedures. Any help is appreciated. Thanks.
  8. tokuzumi

    How to disable a trigger only when doing bulk updates...

    I would like to thank both of you for your help. Rdroske, that looks like a pretty cool thing, knowing what statement caused the trigger to fire. That may be useful to me down the road.
  9. tokuzumi

    How to disable a trigger only when doing bulk updates...

    ...@@FETCH_STATUS = 0 BEGIN -- Log the change IF substring(Columns_Updated(),ceiling((@ColPos-1)/8)+1,1) & POWER(2,((@ColPos-floor((@ColPos-1)/8)*8)-1)) > 0 Begin SET @OldValue = (SELECT CASE When @ColName = 'A' Then A When @ColName = 'B' Then B When @ColName = 'C' Then C...
  10. tokuzumi

    Can temp table created in a string be made available outside of string

    I do use the exec (@String1) statement at the end of the procedure. The temp table I use works perfectly. The only problem I have is when I try to call the temp table after I have executed the string. declare @string1 varchar(8000) set @string1 = ' create table #table1 (...
  11. tokuzumi

    Can temp table created in a string be made available outside of string

    I have a stored procedure, that I build a temp table, using a string. The reason for building the temp table in a string, is I have a dynamic number of columns, depending on how many metrics a user selects. This string built table is the first of many temp tables to be utilized in this stored...
  12. tokuzumi

    Help modify a UDF returning the Nth value of a CSV

    That was almost too easy! Thank you very much!
  13. tokuzumi

    Help modify a UDF returning the Nth value of a CSV

    I have a UDF that takes a CSV, and puts each value into a temp table, and gives it an incremental value. So a string "3,6,9", will look like this; Id Value 1 3 2 6 3 9 What I want the UDF to do, is using the @Id parameter in the UDF, select out the row that matches...
  14. tokuzumi

    Return a delimited list from resultset

    Try this: Looks to be what you may need: http://www.sqlteam.com/item.asp?ItemID=256
  15. tokuzumi

    Is there an end of file (eof) property in SQL?

    Okay, I have found this UDF, that takes a CSV, and breaks out the values into a temp table, so "2,4,6" would look like this: 2 4 6 Now, what I want to do, is add a value field, that will increment by one, so the above row would look like this: Value Field 1 2 2 4 3 6...
  16. tokuzumi

    Is there an end of file (eof) property in SQL?

    In the database, there is a table that has a text-based field, with 13 values, seperated by a comma, and then a space. The field will look like this, minus the quotes: "1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13" The numbers won't always be 1-13, they can be anything, but you get the...
  17. tokuzumi

    Is there an end of file (eof) property in SQL?

    I have an operation I want to perform in a stored procedure. I am building a temp table that gradually gets larger. Now, what I want to do is this; I have found some literature on the "while" statement, which sets a condition for a chunk of SQL to be repeated until a condition is...
  18. tokuzumi

    Problem with (almost) duplicate records, where not all fields are dups

    I was able to run the query with an active server page. Although, if anyone wants to help with encapsulating what I asked above into a stored procedure, or some type of view, that would be great, also.
  19. tokuzumi

    Problem with (almost) duplicate records, where not all fields are dups

    ...Int autonumber Primary Key AcctNumber Int Quantity Int Length float Width float Height float Type int * determines the type of storage (bay, shelf, or floor) MonthYear int * 92003 for sept 2003 datepreped smalldatetime daterevised...
  20. tokuzumi

    Reload on window.opener

    here is how we used to do refreshes of the parent screen upon closing a popup. This code is in the popup window page, not the parent webpage. function RefreshWindow() { opener.location="pagename.asp"; window.close(); }

Part and Inventory Search

Back
Top