What are you hoping to use this for? It vaguely looks like a pivot table to total things up by date, or some kind of running total. Am...

ACtually - using an ORDER BY during the insert would guarantee the ID's be generated in the correct order. Conor Cunningham confirmed that to be true a long while...

PaulB-TheOneAndOnly (2/11/2012)

---

Rowles (2/10/2012)

---

Generally I understand that SSIS allows for a wide-variety of services/applications to be used with SQL Server. Isn't ETL (extract, transform, load) the importing of raw data...

Steve Jones - SSC Editor (2/13/2012)

---

Jeff Moden (2/12/2012)

---

Does anyone know how to block "Site Owners" in the "Recent Posts" for today? Although I certainly appreciate links to blog subjects,...

Here's about as simple as it gets:

select

phone.value('(NUMBER)[1]', 'VARCHAR(40)' ),

...

Try this one on. You'll find more info on how to set the inline XML queries up in the W3C xquery examples

declare @xmlstr XML

set @xmlstr=cast(@str as XML);

select item.value('(var[./@name="ITEMID"]/number)[1]','float')...

The issue is that you're repeating sequences of nodes (i.e NUMBER and TYPE) without encapsulating them, so the querying is reasonably ugly. If you were to add the PHONE...

Have you looked at computed columns to render the contents of the CASE? They all look to be deterministic calculations, so you could even include the "post-calc" values in...

This also might be a way to capture this. SQL Server triggers system events based on firing or executing procedures. You can use SQL Server (event) Broker to...

AS400 is a midrange operating system (think mainframe). You're not going to be able to hook up to it directly because it has a very different file structure (and...

mmiller 85218 (2/6/2012)

---

J Livingston SQL (2/6/2012)

---

mmiller 85218 (2/6/2012)

---

Sean Lange (2/6/2012)

---

J Livingston SQL (2/6/2012)

---

2 type of House

4 type of Colour

3 type of Size

5 type of Flavour

2*4*3*5 = 120 combinations

though...

CELKO (2/1/2012)

---

In the current ANSI/ISO standards have the IS [NOT] DISTINCT FROM theta operator, but only DB2 might have it -- I am not sure. We can use

COALESCE...

Question still is - why would you WANT to? As in - why would you not use the best and most obvious methods?

Knowing the structure doesn't hurt, but having...

GSquared (1/30/2012)

---

Matt Miller (#4) (1/27/2012)

---

In terms of validation: you can run aggregate functions in both the excel file and against the table to make suer you end up with...

Jeff Moden (1/30/2012)

---

I'ts not my solution. JLS posted it.

It uses the MODULO function (% operator) which simply returns the remainder of a division. Try running just Amount %...