test please delete

[eek]

Meeting to discuss how they will butcher the crap architecture to resolve a problem that is only a problem due to the crap architecture has been cancelled.

Question is how long can I keep quiet when everyone else is a total

Managed 2 cheap digs and left it at that. This is a possible escape time so should I update my linked in profile?

[FiveTimes]

Managed 2 cheap digs and left it at that. This is a possible escape time so should I update my linked in profile?

It'll do no harm

How long you been at this client ?

[eek]

It'll do no harm

How long you been at this client ?

A year. Client is close and work beyond easy but they are utterly clueless.....

[NickFitz]

Seventy minutes to go…

[mudskipper]

Well I learnt something new today. I say 'learnt' - it wasn't something I'd ever thought about, and if I had I might have found I knew it already, but as I hadn't, I didn't.

If you have, e.g. an int column in sql, and you sum it, it assumes the resultant datatype is restricted to int and gives you an overflow error if you blow it.

[eek]

Well I learnt something new today. I say 'learnt' - it wasn't something I'd ever thought about, and if I had I might have found I knew it already, but as I hadn't, I didn't.

If you have, e.g. an int column in sql, and you sum it, it assumes the resultant datatype is restricted to int and gives you an overflow error if you blow it.

I don't think that's an assumption rather it keeps the same data type as the original (unless you explicitly change it) which may result in an unexpected overflow error.

[eek]

In other news just wrote a totally bulltulip email to explain why the test data we sent end end client is utterly insane....

I'm quite proud of the number of lies (5) contained in 2 short sentences....

[mudskipper]

Well I learnt something new today. I say 'learnt' - it wasn't something I'd ever thought about, and if I had I might have found I knew it already, but as I hadn't, I didn't.

If you have, e.g. an int column in sql, and you sum it, it assumes the resultant datatype is restricted to int and gives you an overflow error if you blow it.

I am of course talking Microsoft SQL Server. If SQL Fiddle is to be believed MySQL and Oracle are quite happy to sum them

[BrilloPad]

Well I learnt something new today. I say 'learnt' - it wasn't something I'd ever thought about, and if I had I might have found I knew it already, but as I hadn't, I didn't.

I have red eyes in the morning.

FTFY

[mudskipper]

I don't think that's an assumption rather it keeps the same data type as the original (unless you explicitly change it) which may result in an unexpected overflow error.

Well OK, 'assumes' was possibly not the technical term. I'd created a datatable with a type that was big enough to to take the result, so hadn't occurred to me I needed to convert it on selecting.

SQL Fiddle