Brandie Tarvin (7/18/2013)

---

dwain.c (7/17/2013)

---

Brandie Tarvin (7/17/2013)

---

WHOO HOO!

Not only did I just teach myself how to use MERGE (never had time or reason), but I managed to use it correctly with...

You're welcome. Email...

Are you looking for something like this?

DECLARE @AdjacencyList TABLE

(

Parent VARCHAR(20)

,Child VARCHAR(20)

);

DECLARE @PersonsLocations...

Revenant (7/17/2013)

---

dwain.c (7/17/2013)

---

Brandie Tarvin (7/17/2013)

---

WHOO HOO!

Not only did I just teach myself how to use MERGE (never had time or reason), but I managed to use it correctly with a...

Brandie Tarvin (7/17/2013)

---

WHOO HOO!

Not only did I just teach myself how to use MERGE (never had time or reason), but I managed to use it correctly with a Cross Applied...

Sean Lange (7/16/2013)

---

As Phil said, although more gently than me, you do not need a cursor for this at all. There is absolutely NO NEED for one. If you can...

No ROW_NUMBER() necessary.

If you know the largest value stored in each of the 3 columns of interest, you could create a COMPUTED PERSISTED column that is INDEXed and do it...

How should ties in the balance amounts be handled?

Consider using RANK() or DENSE_RANK() instead of ROW_NUMBER().

The title of your thread caught my eye because I had a similar problem with SQL Server Agent across remote servers just recently.

Here is the question and solution I posted:

http://www.sqlservercentral.com/Forums/Topic1455796-391-1.aspx

I...

Steven Willis (7/15/2013)

---

Also available under System Views is the INFORMATION_SCHEMA collection which can give you all the information you need for any metadata in the the database.

For listing out your...

tacy.highland (8/16/2011)

---

I have a concatenated field with name which I'm trying to parse out. The names are entered as so:

Lastname, Firstname

...

I agree with Sean that there's little to go on, but I'll give it a shot even though my suggestion will probably be wrong. All the 2 CTEs do...

Koen Verbeeck (7/15/2013)

---

Sean Lange (7/12/2013)

---

Koen Verbeeck (7/12/2013)

---

Brandie Tarvin (7/12/2013)

---

Yes, there is. Passport allows us to cross borders with...

Probably not a great suggestion but if you can't correct it in the fronte end and if this is happening during an INSERT or UPDATE, you could add an INSTEAD...

If you expect that values will be missing from the non-summary table, do the summary first and a LEFT JOIN to the non-summary table. Columns that are NULL in...