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

    charindex usage

    Thank you
  2. washaw

    charindex usage

    what is the easy way to get a index number of a third or fourth or fifth space in a string. using carindex, it is easy to get first and the second, but it gets complicated on the third and afterwards easy there an easy way to get it Thanks,
  3. washaw

    error handling in sql server 2000

    I am writing a big query and trying to do some error handling. I have a squence of insert statements, and what I want is if one insert statenet failes I don't want the whole process fail insttead it ignores the error and proceedes to the next insert statement; ( on error move next kind of...
  4. washaw

    Dynamic property task

    how do I loop through all my oldb connections using foreach loop container. I was able to do it for files in single folder but got confused for the source servers I have. please help, I spent two full days to figure it out and now I am giving up Thanks
  5. washaw

    Dynamic property task

    Here is my problem I am designing a SSIS package, this ssis package collects info from different servers and dumps the info onto one server. for this I have a data flow task, in the dataflow task I have souce server and destination server; my source servers are many; therefore I want to make...
  6. washaw

    Dynamic property task

    What is equivalent to dynamic property task of dts2000 in SSIS 2005 Thanks
  7. washaw

    query help with count

    Sorry forgot to post what the recordset should looklike here it is monitor quarter count john moyares 1Q 2005 4 john moyares 2Q 2005 2 lori kumar 1Q 2006 3 lori kumar 1Q 2007 2 lori kumar 2Q 2007 1
  8. washaw

    query help with count

    I have a table, the table contains a data of a Site and a monitor which monitors a site, A monitor picks certain sites quarterly to do monitoring, for instance monitor k picks site1, site2, site3 to do monitoring in the first quarter of the year 2008 then for the second quarter he picks some...
  9. washaw

    error with table values function used as a column value

    THanks George
  10. washaw

    error with table values function used as a column value

    NO suggestion for this? THanks,
  11. washaw

    error with table values function used as a column value

    I am having a problem with a table valued function, see the code attached, what is wrong withe code, I am calling the tables valued function as a column value, but it is not allowing me to pass parameters to the funcion declare @today datetime set @today = getdate() DECLARE...
  12. washaw

    oracle databas econnection problem

    I was trying to extract data from oracle databse in my DTS package and was getting the following error Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later cleint software installion...
  13. washaw

    stored procedure review

    Thank you SQLSister, I really appreciate that
  14. washaw

    stored procedure review

    Hi all, we are planning to upgrade our database to 2005, and one of the process is to review all stored procedures wriiten in 2000 and change'em in such a way that they should work fine in 2005. my question is what should I do when reviewing the procedures Thanks
  15. washaw

    delete statement takes time

    The indexes are in place, and they helped a little bit, I am thinking of isolating this process and not creating a log file after deletion; log files are taking much of the resource, what isolation level do you suggest ans what should I do to prevent the delete process creating a log file Thanks
  16. washaw

    delete statement takes time

    Truncate doesn't work for me, the tables have foreign key related and I am using inner joins to delete data from some of the tables Thanks
  17. washaw

    delete statement takes time

    Hello, I am doing some old data archival, and one part of this process is deleting data from the tables after archiving 'em I am facing one problem, deleting data from the tables is taking one heck of time and slows the whole process and takes much of the resources, what should I do to make...
  18. washaw

    problem with dynamci sql

    Thank you for your suggestion SqlSister, what I am not quite understanding is say I have so many tables in my database and I want to get the number of records only for those tables whose names are in the table say tbl; tbl looks like this id name_of_table 1 tbl_table1 2...
  19. washaw

    problem with dynamci sql

    hello, I have a table tbl (have identity column) contains name of tables, and need to do count the number of records for each table --code declare @int int, @str varchar(1000), @tblName varchar(100) select @int = min(id) from tbl while @int is not null begin select @tblName = tblName...
  20. washaw

    what is wrong with this script

    Can any body tell me what is wrong with this script I spent the whole day to figure it out error Error Description: Procedure 'PROC_CHECK_ARCHIVED_DATA' expects parameter '@numDate', which was not supplied. '********************************************************************** ' Visual...

Part and Inventory Search

Back
Top