jcrawf02 (2/8/2013)

---

Brandie Tarvin (2/8/2013)

---

It is morning and my muscles want exercise. Walking, running, jumping jacks, whatever.

It is morning, and my boss wants "butt in chair" work.

Sigh. Sometimes I hate my...

No, you said same:

mehta.saurabhj (2/8/2013)

---

what is the difference between assertion and the check constraint as both of them do the same function?Please give...

I think I know someone who may be looking for a new job.

Sean Lange (2/8/2013)

---

Count...

wafw1971 (2/8/2013)

---

Hi Lynn

Yes I knew that, the questions isn't really about about querying the data, I know there are plenty of ways to get the information from a query. What...

Knowledge test for wafw1971.

You do know that there is no guarantee on the order of the data returned by SQL Server if you don't have an ORDER BY clause on...

rocky_498 (2/7/2013)

---

Let me correct something for make more sense.

Instead of Right and Left, Is High and Low.

Here is my SP (Inside SP)

-- I am update above table

Update Test

Set UpdateField...

dwain.c (2/7/2013)

---

Better advice is...

O.M.G. SQL Server is using the wrong index!

No piling on now! It's okay to look, but no piling on!

Based on the sample data, what would be the state of the data after running the procedure?

I can't figure out what it is you want from your description.

Your "wrong index" is the clustered index. Since SQL Server needed to go to the table for the additional information not included in the nonclustered index (the "correct index"),...

Based on the sample data provided, what would be the expected results.

Please show, not just describe.

Not enough information. If you could post the actual execution plan (saved as a .sqlplan file) for both queries we could probably give you a better answer.

As it is,...

Since it looks like you are going over the network to another instance, use the CTE to populate a local temporary table and use that table in your update statement.

Sean Lange (2/7/2013)

---

Lynn Pettis (2/7/2013)

---

Sean Lange (2/7/2013)

---

Lynn Pettis (2/7/2013)

---

Everything looks orderd to me. I wouldn't use a while loop to populate the table dbo.Time2 and you really should not...