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: washaw
  • Content: Threads
  • Order by date
  1. 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,
  2. 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...
  3. washaw

    Dynamic property task

    What is equivalent to dynamic property task of dts2000 in SSIS 2005 Thanks
  4. 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...
  5. 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...
  6. 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...
  7. 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
  8. 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...
  9. 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...
  10. 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...
  11. washaw

    run DTS from query analyzer

    I have posted the thread in DTS forum but couldn't get response, I know this thread doesn't belong in this forum, but I am posting this incase somebody should respond. I have a DTS called myDTS wich has one input parameter called inputParam, I am trying to run it from query analyzer and wrote...
  12. washaw

    running a DTS package from Query Analyzer

    I have a DTS called myDTS wich has one input parameter called inputParam, I am trying to run it from query analyzer and wrote this query EXEC @hr = sp_OACreate 'DTS.Package', @object OUTPUT if @hr <> 0 BEGIN print 'error create DTS.Package' RETURN END EXEC @hr = sp_OAMethod @object...
  13. washaw

    timeot error on vbscript

    I have wriiten this code and when I executed it, I am getting the following error which I spent hours to figure it out but couldn't can somebody help me Error source Microsoft OLe db provider fro sql server error description error code 0 error sourcr= Microsoft OLe db provider fro sql...
  14. washaw

    run a stored procedure from a vb script

    Hi, I am designing a DTS package and in my DTS package I have an activeX script task, I am thinking of writing a vb script, my script is excuting a stroed procedure 'IsAllDataloaded' wich has input parameter and output parameter of integer type, my question is how am I able to invoke this...
  15. washaw

    execute stored procedure from vbscript

    Hi, I need to be able to execute a stored procedure from VBScript, the procedure has input parameter of integer type and output parameter of integer type aswell - can anyone give me any pointers with how to do it? Thanks
  16. washaw

    excute stored procedure from vbscript

    Hi, I need to be able to execute a stored procedure from VBScript, the procedure has input parameter of integer type and output parameter of integer type aswell - can anyone give me any pointers with how to do it? Thanks
  17. washaw

    performance problem

    I have a view, The view has 5 simple select statements joined by union all statement, each select statement in the view runs under 1 sec except one which takes > 1 sec to run but when this view is joined in procedure, the procedures tend to run very slow, what could be the cause Thanks
  18. washaw

    what is wrong in this code

    This thing is giving me a headache, in our database we have 200 table out of wich 119 have additional two columns "Inserted" and "modified" which keeps track of which rows are inserted and which are modified (N.B all rows in a table are either inserted or modified or non). I am planning to...
  19. washaw

    need faster query

    In my little assignment, I am doing some data archival with the data older than 120 days after I did archiving I delete data from these tables I use the following query for each tables (they are 10 of 'em) delete from table1 where DATEDIFF(DAY, CREATED_DATE, GETDATE()) > 120 But it is...
  20. washaw

    selecting data from more than two tables

    Hello I have four tables create table tbl1 (id int, value varchar(100)) insert into tbl1 select 1, 'aa' union all select 2, 'bb' union all select 3, 'cc' create table tbl2 (id int, id2 int, value varchar(100)) insert into tbl2 select 1, 1, 'dd' union all select 2, 1, 'ee' union all...

Part and Inventory Search

Back
Top