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 wOOdy-Soft 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: Windy77
  • Content: Threads
  • Order by date
  1. Windy77

    Which StoredProc triggered a TRIGGER ?

    Background to problem: We have a problem in that for the last two weeks at the start of business on Thursday morning a single row from a Customer Master table has been missing. The first time we were confused but thought it was accidental, the second time it became more obvious that it may be a...
  2. Windy77

    identify table name

    Is there any way to identify the name of the table last updated (just like @@identity provides the last updated row identity). We have a need to update one of several tables based on dynamic sql statement and then need to trigger further updates based on knowing the table name rather than...
  3. Windy77

    WRAP adds blanks to cell with text

    I have a user who is adding text to cells within a spreadsheet. When these are full she used the Format / Cell Wrap option to allow the full text to be visible. Then she double clicked on the lower row nukber divider to re-siae teh height of the cell and in each case the row height changes to be...
  4. Windy77

    need to select on COUNT (WHERE / HAVING ??)

    I am trying to identify from a table of clients, only those who have handled a particular type of case (kf1.WorkSource2 = 4). This is in addition to more standard cases (there are some who never have kf1.WorkSource2 = 4 so the COUNT would be 0), so I want to ignore those where the COUNT is 0...
  5. Windy77

    DTS error : Cannot open database requested in login

    I have inherited two DTS packages with the same name (in two different SQL (2000) Servers). I need to find out what they do to see why we have two versions so I right click to "Design Package" to see the Source is a Text file (csv) and the Destination or Result is a SQL table. However...
  6. Windy77

    COUNT DAYDIFF > required value

    Hi, I need to calculate average response times in days (from the date a letter is posted to when a reply is received). I use the following to get the total days difference, and when output to Excel with the count of letters sent it works just fine. DECLARE @DAYDIFF INT SET @DAYDIFF = (SELECT...
  7. Windy77

    Problems with Data Type Conversion - CAST vs STR

    Sorry it’s a long explanation but I’ve tried to cover everything I’ve tried so far. I’m trying to do a comparison between values in two fields (they’re supposed to match up), but one field is defined float(8), and the other varchar(50). Using the code here (I’ve stripped out all unnecessary...

Part and Inventory Search

Back
Top