|
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. 
|
|
|
|
|
Alright, no more going around in circles. I hate circles. What's the deal with circles anyway? They're pointless!
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
Quote: What's the deal with circles anyway? They're pointless!
Not if two circles intersect 
|
|
|
|
|
Vincent Maverick Durano wrote: Not if two circles intersect
Venn would that ever happen though?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
