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

You really haven't given us much to go on here, just a series of terse requests for help. For example, do your tables contain only one row? If...

Where did you read that WHILE loops are better than cursors? They're both loops. Far better is to do what you're trying to do in one set-based operation....

Luis is right about scalar functions. In addition, you've missed out the bit where you execute the string that you've built. However, it still won't work, since:

(a) Your...

First thing to check - is the query on SSMS and SSRS definitely running against the same database?

Second, connection options can make a difference to query performance. Things like...