Live and work near Swindon, Wilts in the UK

(and that is near not in Swindon)

I don't have any certificates - but then I don't claim to be a DBA (or a developer for that matter). I may be the sort of person that many...

No longer an issue.

System replaced on another server - no one told all the users.

Ain't life grand!

An update

I have now found that these are Imported DTS packages not SSIS created packages.

I can't export these as anything other than DTS files which isn't much good as...

HIPS is the same thing as network intrusion dection systems (IDS) but at the host level. The idea is that it will stop a zero day bug before there are...

Thanks for the reply

Are the machines identical?

Hardware yes software no different users can have variations of a "core" build

Same Service Pack level Build number etc?

As far as...

OK - I've answered my own question.

Although the database and table was set to Latin1_General_CI_AS one of the columns used was set to Latin1_General_CI_AS_KS_WS - hence the issue

Changing result to be in text, I get

(1 row(s) affected)

(1 row(s) affected)

this is an exception

(1 row(s) affected)

(1 row(s) affected)

id

-----------

1

2

4

5

(4 row(s) affected)

Try coalesce - this returns the first non null in a list of values. Full syntax

COALESCE ( value_you_have_calculated,0 )

Agree entirely - I don't mind who helps me out when I post a question here, be they...

San-847017 (12/2/2009)

---

Don't know how..when I opened QOD page today it shows that "My answer is correct" and I have been given 2 points. In fact I had not even seen...

Propinquities

Going back to the thoughts of the OP and coming from the “other side of the fence”, in that I ask more questions than give answers; I feel that it...

Google is great resource.

searching on "cannot load the Report Server DocumentLibrary extension" revealed this:-

http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/e35315ae-3704-401d-947e-cd371afb8c14/

Have you done all that is suggested here?

Many thanks for your work and input to this.

Most confusingly, I have since tried this on various spreadsheets I created my self and didn't have any problems, it didn't matter...