You can delete directly from the CTE:

DELETE from CTE_SCC

where Rec_No > 1

John

Sounds like your employer is putting the cart before the horse. If your applications don't have the facility to reset expired passwords then things are going to start breaking...

Have you tried using bcp or SSIS?

John

I don't understand - if it's got a unique index, how can there be duplicates? Please will you post full table DDL (including indexes) and sample data in the...

No, you can certainly put them in any order you like, and as far as I know, it doesn't make any difference to performance.

John

roy.tollison (11/1/2013)

---

at various times i need to copy the rows to another table but it has minor differences.

table1

t1.f1 int,

t1.f2 char(25),

t1.f3 varchar(50),

t1.f4 smallint,

...

It could well be something to do with the .Net Framwework service, since it's only the script task that appears to be causing you problems. However, I'm afraid we've...

I don't recommend using triggers. By the time you've thought of everything you want to audit, you'll have so many triggers that you won't know how to manage them...

Please go on to the server with the msdb database on it and check whether there's a service called SQL Server Integration Services xx.x (where xx.x is the version), and...

If you don't have any logging and auditing set up on your server, you may be out of luck. You could try the default trace, if it goes back...

I'm afraid not. I know you've got a lot of tables, but maybe you could simplify it, please, and then provide some sample data and expected results?

John

I don't understand. What do you get by looping through those dates that you don't get from the results of the query as it stands?

John

Paul, surely you just use the REPLACE function (or its .Net equivalent) on FileSystempath to replace each single quote with two single quotes?

John

I read Kurt's post as saying that temp tables should not be used at all where not necessary. I've seen result sets be inserted into a temp table, only...

Yes, it's possible, but it depends on what you want it to look like. You first query will return a result set like:

ThemeA

ThemeB

ThemeC

The second will be like:

Theme2A

Theme2B

Theme2C

Theme2D

The third will...