That is what I did initially. It throws an error saying that "ALTER / CREATE" cannot have the database name in the query.

Thank you paul. It worked perfect. That is exactly what I need.

Hi,

sorry for the late reply. I will look at your solutions. When I said adjacent I mean continuous. so for example if I have dates like this for same employee

1/1/2010...

I already tried it but it didn't work.

Thank you. That is what I am planning to do. I am just checking to see if there is any other way to do this with out actually creating a...

Thank you. Please send it to dsridhar10@gmail.com. I appreciate your help.

Hi,

Will it be possible to share the query text of the stored procedure?

Thanks,

sridhar.

OFAC stands for Office of Foreign Assets Control. Their database has a list of names, addresses, passport numbers etc to query against our databases. If we find a matching in...

Hi,

I am also working on the OFAC compliance queries. I am trying to use "CONTAINS" that is available in full text search. you can change the thesaurus file and in...

yes I am using the script task to check if the file exists. Initially the package is written using visual studio 2005 version. so it is generating bunch of warnings...

For now I think we will have 11 procedures if we do a separate procedure for each field. so I am not sure if it is the right way to...

Hi Jeff,

can you please explain how we could do this using a join?

I am thinking that the new table will have fields (oldvalue, newvalue, fieldname). but...

I got it working. I have used the migration tool to convert the dts package to sql server 2005 format. Once I did that it worked fine.

Thanks,

sridhar.

yes I did.

Executing the query "UPDATE STATISTICS [dbo].[##temptable]

" failed with the following error: "Table '##temptable' does not exist.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not...