Search results for query: *

Thank you

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

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

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

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

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

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

THanks George

NO suggestion for this? THanks,

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

Thank you SQLSister, I really appreciate that

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

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

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

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

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

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