|
|
I like the picture next to "Stonehenge completed". I'm just surprised the temperature didn't go to 11 at that point.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
LMAO
#SupportHeForShe
Government can give you nothing but what it takes from somebody else. A government big enough to give you everything you want is big enough to take everything you've got, including your freedom.-Ezra Taft Benson
You must accept 1 of 2 basic premises: Either we are alone in the universe or we are not alone. Either way, the implications are staggering!-Wernher von Braun
|
|
|
|
|
Auto generated sql query over 11000 characters long. I will have to do something drastic to make it readable.
|
|
|
|
|
that ain't be a problem if you were writing it on VB.
|
|
|
|
|
Start with installing Notepad++, go to the plugin manager and add "Poor Man's T-SQL Formatter"
It's not perfect, but it becomes fairly readable
|
|
|
|
|
I'm just going to dump everything in a cell in excel and just point to that cell when doing a query.
The readability problem isn't really a formatting problem but rather a comprehension problem. But since the returned results are enough for me to work with I'll just do what I need post query to present a report and sweep everything under a nice big rug and home for the best.
I did panic first when I saw the extent of the query until I realised that I could work around it. I can honestly say that if I would have to dissect the query it would take two weeks non stop and that's being optimistic.
|
|
|
|
|
Only 11,000? Have you seen some of the SQL queries Entity Framework can put together for you? 11K is nothing.
|
|
|
|
|
I've found that the best thing to do with such queries is print them out, run them through a shredder, and use the shredded paper to light a barbecue.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Crystal Report 2008 slow in loading in win application c#
|
|
|
|
|
|
Perhaps
Anything that is unrelated to elephants is irrelephant Anonymous
- The problem with quotes on the internet is that you can never tell if they're genuine Winston Churchill, 1944
- I'd just like a chance to prove that money can't make me happy. Me, all the time
|
|
|
|
|
|
|
Leslie Nielsen is dead, too.
(what did he know about Hillary Clinton?)
".45 ACP - because shooting twice is just silly" - JSOP, 2010
- You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
- When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013
|
|
|
|
|
Push the Turbo button on the front of the computer.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
That's clear.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Mark_Wallace wrote: That's clear. Crystal clear.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Remarkable.
You actually figured it out.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Mark_Wallace wrote: Remarkable I humbly agree.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
RyanDev wrote: I hum Probably. I'm not in the same room as you, so I , thankfully, have no empirical evidence of it.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
Mark_Wallace wrote: I'm not in the same room as you That would explain the weird looks I've been getting.
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
RyanDev wrote: Crystal clear.
Thanks for your report
|
|
|
|
|
ThePhantomUpvoter wrote: Thanks for your report Mark is often subtle so I was clarifying his profound observation. Is that clear?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
RyanDev wrote: Is that clear?
Obviously the correct answer here is, crystal clear.
|
|
|
|