Hi there,

If you want to be able to do this, I would use SSIS (SQL Server Integration Services), which is purely designed for what you are trying to accomplish.

The weird...

Glad it helped,

Have a nice day,

I find it a lot easier to use the Update From statement, here's how I would do it:

UPDATE crt_concept

SET state_average_percent = kc.state_average_percent ,

...

You should be able to figure this out... Charindex has an optional parameter, look it up in BOL.

You can use the REVERSE() Function, to help start from the end, and the charIndex, to find the comma. I added a case to ensure a comma is added at...

tripri (8/31/2010)

---

Thank you so much J-F

That clears my doubt most of it.

I got one more question

Suppose if i have given that package to 20 persons and i dont know...

Under SSIS -> Package Configurations

You could use a variable for the connection, and under 1 of the menus at the top, there is a Parameter config that you can implement. You can use a...

Sadly, no, it's a sql server 2005 function. Sorry to have mislead you, I...

Or just drop this approach, and use the row_number() windowed function to insert into the other DB, everytime using a new sequential number, based on your requirement.

Looks like a stats problem to be, have you tried updating them?

Also, is your database creating statistics automatically? This could help, as I see missing statistics for the Clustered indexes...

Edit: Nvm wrong advice.

Well, the easiest way I know is to run the app, while running a SQL profiler, and filtering on the number of rows returned by each query. You can do...

Thanks guys,

I think you've showed me some helpful points, and also that I need to read a lot more on the subject, to be able to come to a conclusion....

Thanks for the query tuning, but I have to say this is pretty much my strength in this field. I have optimised all I could in this query, and now,...