You just need to get rid of the AS statements inside it.

CASE

WHEN column1 = 1 THEN 'column1'

ELSE ''

END

+ ' '

...

Is the IN list an input parameter of some sort, or is it hard-coded into the query? You weren't clear on that, but it's the deciding factor on how...

davoscollective (12/10/2012)

---

I previously provided a link to a website I worked on many years ago containing rough version of the test. The website belongs to a business consultancy, that uses...

Ah. This is pretty much a Microsoft SQL Server site. Someone might happen along who could help, but it's not a high probability. You're probably better off...

If Merge is too slow on this, then Insert will almost certainly be too slow as well. Those are the two main options.

With either one, the usual way to...

Like this:

WHERE (@finclass = 1 AND p.finclass = @FinclassCategory OR @finclass != 1)

AND P.HOSPITAL = @HOSPITAL

Any particular reason to log it to a table, instead of just definining a view that queries the last hour of data?

Either way, you'll get most of your data out...

Steve Jones - SSC Editor (12/10/2012)

---

SQL Kiwi (12/9/2012)

---

Hi Steve,

I did not receive a notification for this post (or perhaps I didn't see it) so apologies for the late reply. ...

So far as I know, there's no such thing as a T-SQL HTML script, so I'm not entirely clear on what you're trying to do.

From what I do understand, you...

Replace the string expression with either a code object or a stored proceduring, depending on what you are trying to do with it.

How frequently does that maintenance plan run? Is it running while you're doing this?

When you were checking to make sure the databases weren't in use, how did you check that? sp_who2? Something else?

Merge with Output is a perfectly good way to do that.

Is there some specific reason you want to change to something else, or are you just trying to confirm that...

Here's a list of what you can track with triggers (DDL triggers, to be precise): http://msdn.microsoft.com/en-us/library/ms189871(v=SQL.90).aspx

Here's some data on Extended Events: http://msdn.microsoft.com/en-us/library/bb630354(v=SQL.105).aspx

As Gail mentioned, Extended Events are probably what you're...

Just to be clear: Are you using an AS400 to connect to a Microsoft SQL Server database? Or are you using some database product native to the AS400?