paganpaul: (Computer)
For work I wrote a complex SQL query that generates an even more complex SQL query.

Would you think I have a knack for SQL?
--
Posted through qtxpost.
paganpaul: (Computer)
Last thing before I left work, I found out that the new assignment is not for me. The customer opted for 'the other candidate'.
Right, so for now that means no suit and tie for me, and continuing to work on the cinema-software reports in easy trousers and t-shirts.

A bit of a pity, though, would've been nice to go out again.

<rant on>
What the frack is wrong with the combination of MS Sqlserver and MS C# in the MVC framework??
I built a query in Sqlserver that hands me 8 rows of consolidated data, the way I want them on the report. Easy peasy. Stuff like:

Avatar 2010-05-20 7 60,80
Avatar 2010-05-22 1 12,00
Prince of Persia the sands of time 2010-05-20 5 26,10
Prince of Persia the sands of time 2010-05-21 2 7,00
Prince of Persia the sands of time 2010-05-22 1 5,00

When I pull that in through the framework, for some insanely stupid reason the Microsoft framework shows me:

Avatar 2010-05-20 7 60,80
Avatar 2010-05-20 7 60,80
Prince of Persia the sands of time 2010-05-20 5 26,10
Prince of Persia the sands of time 2010-05-20 5 26,10
Prince of Persia the sands of time 2010-05-20 5 26,10

Quite cool but no cigar, as that is not what Sqlserver sends. I think. Because of the ridiculous architecture, I can't see what is sent. I only see that the context retrieves the faulty blurp. The only way I can make this right is to send all 60 rows of data across, unconsolidated, which then arrives on the framework spic and span, and do all consolidating in the report, using a few big handcoded functions.
Now 60 rows is not much, but this is test-stuff. When the thing goes live, we're talking about 100s of 1000s of rows of data, that can be consolidated in 8000 to 9000. Hello bandwidth!
<rant off>
--
Posted through qtxpost.

Apple...

Jan. 29th, 2010 06:14 pm
paganpaul: (Computer)
So there it is. The Apple iPad. No punch card reader. No Cobol compiler. I mean, what good is it that way?!

April 2012

S M T W T F S
1234567
891011121314
1516 1718 192021
22 232425262728
2930     

Syndicate

RSS Atom

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags
Page generated Jul. 25th, 2017 10:43 pm
Powered by Dreamwidth Studios