That means:

1. You are inserting new records

2. You specify values for the new records so they match certain criteria.

In...

Not sure what you're trying to do here...

You have an "insert...values..." command and then "select...where..."

What are you trying to achieve? Do you mean to update records that correspond to...

This should get you going.

The trick is to flip your criteria:

You want all records that start before your end date and end after your start date...

However, I couldn't see...

Assuming your target table is called TargetTable, your code should look something like this:

INSERT TargetTable (anadesc,idenvaseana,idegrupoana,matid,tipaid)

select anadesc,idenvaseana,idegrupoana,matid,tipaid

from dbo.analisis

where (anadesc like '%disuelto%') and (matid = 'am') and (tipaid = 'mt')

Congratulations on your first post here.... 🙂

Welcome buddy.

You have planty of choices. Top 2 would be:

1. run SQLCMD with format file

2. use SSIS to export data

For further info, have...

Numbers are possiblr to be saught by configuring noise.dat file on your server and re-indexing whole content.

Special chars, however, require you to write a new language analyzer... See MSDN online...

Assuming your inline comamnds are plain SQL or through exceptions when there are internal erros, you could simply use the built in mechanism in SQL 2005:

BEGIN TRY

BEGIN TRAN

--ALL...

Assuming your inline comamnds are plain SQL or through exceptions when there are internal erros, you could simply use the built in mechanism in SQL 2005:

BEGIN TRY

BEGIN TRAN

--ALL...

Assuming your inline comamnds are plain SQL or through exceptions when there are internal erros, you could simply use the built in mechanism in SQL 2005:

BEGIN TRY

BEGIN TRAN

OK, now we'll step into the optimization phase:

Initially, you had 2 problems: Delete action took too long + command action allowed only short term command to run. Some tried to...

Why not run these checks before your backup operation?

As for existing backups, just restore them to another location, check the DB and then restore again if needed onto real DB...

Norman-Jet.O-Calub (9/6/2009)

---

Hi Benyos,

Thanks for your reply, the first part i agree with that now how about the Second suggestion you mention about the "execution time to itsef and...

Well...

First, you might wanna try and replace the 'DELETE' WITH 'SELECT COUNT(*)' so you know how many records are going to be affected.

Second, you set the connection timeout but that's...

Well, your mistake is by calling it "open". You don't open databases. You access them if they reside on your server.

You first need to bring that DB onto the server...

I didn't get what is the function that gives the % value for each month...

Cuold not see the connection between the numbers (10,15,25%,...)