GilaMonster (7/22/2010)

---

I must admit, I don't agree with that....

I've got a QotD question for you'll...

Is it sufficient to base the answer off of BOL?

I'm getting a lot of grief today over a few index types that people are...

In your code, you have:

SELECT @CurrentTime = getdate()

SET NOCOUNT ON

The select before the "SET...

As the others have already mentioned, you need to PIVOT your data. Take a look at the two Pivot/Cross-tab articles (Part 1 and Part 2) linked to in my signature.

I would agree that Unique, filtered and included indexes are a sub-type of the clustered (for Unique) or non-clustered index types. However, according to the latest Microsoft documentation, they are...

Thanks for the early morning chuckle! Yes, you are right about this. 😀

You might want to look at STUFF also. If you use this, it might be easier to add the dashes from back to front.

This code might help you out. Just take the deadlock XML info you posted above, put it into the @deadlock variable, and run.

declare @deadlock xml

set @deadlock = 'put your deadlock...

Eduardo Gutiérrez (7/21/2010)

---

Hello everyone, how have you been?

I have some problems with the following, I am trying to execute a statement to insert the percentage of the amount of money...

Create a new step with T-SQL code to call sp_send_dbmail with the appropriate parameters to send your email.

On the step with the SSIS pkg, have it fail the job if...

Anthonykush (7/21/2010)

---

Please help me to write a query. This is the task. I have Table a and B. Table B has millions of rows.

I want to insert into Table A...

Are the names of the tabs known in advance? If so, use a For or ForEach container to loop through each tab. Inside that, put the name of the tab...

From what I see in your code, you are building a temp table, then opening up a cursor and inserting all columns from all rows from the Employee table into...

The INTO clause goes before the first FROM:

Select A, B, C

into YourNewTable

from (Select A1, B1, C1 from (Select A2, B2, C2 from Table1 Union Select E2, F2, G2 from...

Instead of using a correlated subquery, you might want to look into using a derived table:

UPDATE a

SET a.ShipQty = b.ShippedQuantity

FROM TempTotal a

...