andre-394971 (1/29/2012)

---

Thanks for that...

The number of rows I need to process is less than 1000 in the worst case...

Yes it would be possible to do on the front end but...

We've been taking on a somewhat similiar task (trying to standardize an integration layer), and it's been a LONG road for us.

From what I've seen:

- your first step...

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 consistent results. This...

When you're in a MDB file, the label attached to the names (e.g. dbo_table1) are just that - arbitrary labels. Once you've attached the tables the name itself doesn't...

True - but I doubt that Linus...

Jeff Moden (1/23/2012)

---

I have to ask... is a FOREACH loop in SSIS going to be as effecient as creating a result set in a stored procedure that uses FOR XML...

It's not a WHILE loop, but you can accomplish the same effect using the FOREACH control container. Just point it at the table, and start building.

Here's a good place...

sturner (1/23/2012)

---

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

---

So developers and DBA's are on the hook for not spitting out solutions they don't understand, but it is imperative to remember that they're the end...

Steve Jones - SSC Editor (1/23/2012)

---

Gus,

I wouldn't call experimenting "jiggling". Now if you try things and then slip that code into a deployment without understanding it, which implies incomplete testing...

Here's a CTE version that should do what you need to see:

;with OrderingCTE as (

SELECT ROW_NUMBER() over (PARTITION by [job] order by oper_num) RN,

* from #JobSample)

select

...

I would be throwing this back at the developer of your sealed application (using unsupported and deprecated procedures with no documentation whatsoever sounds like a winning combination by the way)....

You can always use NTILE() to come up with the records making up the 3rd quartile (and then compile them to whatever values you might need).

; with DosageCTE as (

SELECT...

I am not sure if it works or not, but one of the big reasons to use service broker is in fact to get away from linked server hell. ...

DeanORenO (1/5/2012)

---

I don't know why it is taking me so long just to figure out something that should be so simple, but anyway, here it is, I just need to...

Stefan Krzywicki (12/29/2011)

---

I can't even get them to buy...