I am assuming the solution is a correlated subquery.

Like this example, with the difference that you need to use sum and group by instead of AVG.

This must...

that raises an interesting point - I'm slightly misquoting Alejandro here

"memory problems, SQL Server bugs, or IO subsystem"

All of this morning My DR instance has had all 3 of these...

I am assuming the solution is a correlated subquery.

Like this example, with the difference that you need to use sum and group by instead of AVG.

This must be done...

This sounds like a NoSQL situation - basically "eventual consistency"  across many nodes????

am I correct ?

is this causing an issue ? the installation language is pretty much just used for error messages and date formats (as for as I can remember)

your collation will control sort...

you might have to use case statement

for example if I wanted to get a count for all employees who first name starts with 'j'

select sum cnt from

(select  case when firstname...

Another venting.. first thing though, I don't want to get into the whole argument on of using EOM vs BOM.

Where I work currently they use EOM.  Which is fine...

Tends to vary over time. I like some sci-fi, spy...

Jeff

2nd row has data types? I've never seen that before.. but you have no idea what dreams I will have tonight , followed by the nightmares of using the SSIS...

we still use mainframe and AS400.  This is how we get files all the time.  Bulk Insert works well and fast.  I still have arguments with mainframers as they...

good spot.. it's easy to lose a , or ' especially in dynamic sql or badly formatted code

I cant see anything obvious but i'm looking at result sperator as my first guess

my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone else.

In...

Now i'm interested in your reading interests. If I were a betting man I'd go with Ian M banks

my advice - fix the source file, put a delimiter in there and then have whoever designed that file format go and work for someone else.

In my experience...