Stefan Krzywicki (2/18/2011)

---

GSquared (2/18/2011)

---

Brandie Tarvin (2/18/2011)

---

I agree. In fact,...

You're welcome.

Brandie Tarvin (2/18/2011)

---

I agree. In fact, I was mentally...

Gromey (2/18/2011)

---

Oh yea, absolutely. For the most part, I only use loops when I'm doing mass updates or for copying/moving large sets of data from one database table to...

Is it a named column in the query? If so, try grouping by it in a proof of concept query.

You can use the ranking functions and a CTE for this in SQL 2005 or later.

Will look like:

;with Ranked as

(select Row_Number() over (partition by Ev_Cat order by Ev_Date desc)...

Ian Scarlett (2/18/2011)

---

Don't appologize Gianluca. That sort of behaviour needs to be brought to people's attention.

I just wish I'd...

David Burrows (2/18/2011)

---

string strsql = "";

strsql += " Select '' AS [CustomerId],' ---Select Customer --- ' AS [CompanyName] ";

strsql += " Union Select CustomerId, CompanyName ";

strsql += "...

Jeff Moden (2/17/2011)

---

danielagger98 (2/17/2011)

---

I want to extend the minimum datetime value(1973), some of the oracle date fields have date 01-01-0006, not that it makes any sense.

But if the management wants...

LutzM (2/17/2011)

---

I'd rather go with

SELECT

x.i.value('(@parentStructId)[1]','int') AS ParentStructID,

x.i.value('(@family)[1]','int') AS Family,

x.i.value('(@subFamily)[1]','int') AS SubFamily

FROM @xmlFile.nodes('/FamilyAndSubFamily/myStruct') as x(i);

It performs better than the x.i.query('.').value approach. (see execution plan and statistics on a larger data...

Jeff Moden (2/17/2011)

---

With only very rare exceptions, I believe that...

If it's XML data, you should store it as typed XML, with defined XML schemas. That'll help with storage size and compressibility.

Do you know how to query a table and join it to another table?

You're pretty much going to be stuck using a string data type for these, and then doing transformations/redirects on them based on the logic your target database needs to comply...

Please don't double-post.