Search results for query: *

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,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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