Well, then you know what to fix in the query.

You have ast.quantity all over the query. Is there a quantity column in the table tblAssets? In such case, why is the CTE taking quantity from a different table?

As I...

Jeff, if you are going to suggest people to use dynamic SQL, at least show them code that is safe and robust. The construct

SELECT @sql = @sql + col FROM...

Yes, for you and...

I'm a database guy and don't work on the client side, so my knowledge is thin on exactly what products that are out there. I guess could google around, but...

First of all, you should think twice if this is something you really should do in the database. This is for presentional matters, so the presentation layer is the best...

I'm tempted to say that none of them are good. If you really have reason to put this exceptional command in a stored procedure, you should add a comment that...

To be able to help you further we need more information. Here is a question that you need to find the answer to: Say that is is not possible to...

If you run

xp_cmdshell 'TIME /T'

what do you see?

Have you tried restarting SQL Server?

For a question like this, you help yourself quite a bit if you post CREATE TABLE statements for your table(s), INSERT statements with sample data and the desired result from...

Basically anytime when a new record  is inserted into the specific table\column , it grab the record  and bring it over in some way for use in another system.

we...

Yes, you can create an INSTEAD OF trigger on a view. That is, a trigger that fires if an INSERT statement (or which action the view is defined) attempted on...

I don't think dropping the queue helps. Rather it makes things worse.

But the best start may be to ask around. There must be someone who knows what this database is...

If Service Broker is disabled, does anyone care about the conversations? If memory serves, you can do ALTER DATABASE db SET NEW_BROKER and it will clear up everything. And I...

<li style="list-style-type: none;">

1. Set up a stored procedure to produce the output that you want to send to the the other machine in a file.

<li style="list-style-type: none;">

...