Viewing 15 posts - 5,896 through 5,910 (of 18,926 total)
You could use a cte as well, but here's my original idea.
SELECT
CASE WHEN ColName = 1 THEN 2
...
May 19, 2011 at 11:08 am
You can set the visibility for the whole row or column for that matter.
May 19, 2011 at 11:05 am
I've got my prompt here...
select
'select ' + case system_type_id
...
May 19, 2011 at 11:04 am
I'd try to test it out but I'm pretty sure it's not in the supported versions list. Maybe you'd be better off sticking with 2000 or 2003 for that...
May 19, 2011 at 11:03 am
SELECT dta.CaseColName FROM (base query here) dta
May 19, 2011 at 11:00 am
Just reverse whatever you did for the subreport visibility and it should work on that extra line.
May 19, 2011 at 10:59 am
asterman_3 (5/19/2011)
I checked a bit that and I think it is not flexible and doesn't include many options. Even more, sometimes blocks the execution of the queries - makes delay.
Not...
May 19, 2011 at 10:58 am
May 19, 2011 at 10:35 am
What's the cost of recompile VS cost of index scan? I'd take the less expansive of the 2.
I'd also strongly consider adding my index to see if the problem...
May 19, 2011 at 10:34 am
ramadesai108 (5/19/2011)
Gail,That was the answer I was looking for. Thanks.
You're still ignoring obvious solutions.
How much data will be left in the table once the delete is...
May 19, 2011 at 10:23 am
skcadavre (5/19/2011)
Ninja's_RGR'us (5/19/2011)
Time to track the guilty party! 😉
Not too difficult - there are two of us that work on the database servers and it wasn't me. . ....
May 19, 2011 at 10:18 am
steveb. (5/19/2011)
Not to keep banging on about the 24 t-log...
May 19, 2011 at 9:53 am
Viewing 15 posts - 5,896 through 5,910 (of 18,926 total)