swingnchad1 (5/24/2010)

---

Nice! Thanks for introducing me to CTE's 🙂 And I don't know why I didn't think of doing a MAX on the date, but that would have...

What would be the reason to rewrite it?

Looks like a well-performing approach...

Don't get me wrong but I think you should get a consultant in to help you resolving that puzzle as a whole.

It's the 3rd or 4th post regarding the...

Something like the following code snippet?

I used a CTE to get the latest update-time per app_id and joined that back to the main table. The result is filtered to show...

Ooopps!! I'm sorry!! :blush:

I totally forgot that the split function I'm using isn't known by anybody by now... 😉

Glad you found it by yourself though... (Isn't this site an awesome...

Since your target table seems to be identical to what you have so far, the solutionis simple: do nothing 😀

To answer your question: based on the given talbe you can't....

If you have a backup from last night you could restore it to a separate server/database and compare the rows...

To get the collation of ...

the table:

right click on the kund table in SSMS -> properties -> Extended properties -> collation

the database:

right click on the database in SSMS ->...

Unfortunately, your sample data don't show either the plasma TV nor any of your special character :crying:

Anyway, here's what I've found so far:

1) Column kund_id is defined as IDENTITY(1,1). In...

Would you mind sharing a sample portion of your XML file together with your target table structure and your original XQuery code? I'm pretty sure the final solution will outperform...

Ok, here's what I came up with (@Jeff: pork chops please before noon your time so I'll have something for my BBQ 🙂 )

A few notes:

The first row for 'India...

See my previous post:

If you need further assistance please provide table definition including any constraints/triggers or the like together with a sample file holding fake data but demonstrate the issue...

It's definitely not the...

You could use the following code:

SELECT TOP 1 *

FROM

(

SELECT TOP 1 * FROM A ORDER BY CurrentTime DESC

UNION ALL

SELECT TOP 1 * FROM B ORDER BY CurrentTime DESC

) C...

I think the problem is that you apply a function (UPPER to be precise) to a column causing the clustered index scan, since the other columns you're using don't seem...