Viewing 15 posts - 11,176 through 11,190 (of 13,872 total)
'Thinking In Sets' is the important phrase.
Non-SQL developers tend to write sub-optimal SQL as a result of their general tendency towards row-by-row processing, something which SQL developers tend to avoid...
August 24, 2011 at 3:48 am
karthikeyan-444867 (8/24/2011)
Declare @id int
select @id = id from emp where eno = 5
can we say it...
August 24, 2011 at 2:16 am
Ninja's_RGR'us (8/22/2011)
Nothing you can do except use order by from outside the view =>
Select Whatever From dbo.View ORDER BY...
August 22, 2011 at 8:51 am
...to change it there as well?
Not 'as well' - just change the config file and leave the BIDS version alone.
August 22, 2011 at 8:26 am
..Please see the farticle at
Got a slight wind problem Jeff? 😀
August 19, 2011 at 9:03 am
As it's required only for a small proportion of results, you could try a UNION
select coalesce(a,b)
from ...
where coalesce(a,b) is not null
union
select [complex expression]
from ...
where coalesce(a,b) is null
August 19, 2011 at 7:36 am
John Mitchell-245523 (8/19/2011)
August 19, 2011 at 4:54 am
Please provide more info. How much data, how frequently and why continuously? You make it sound like a migration, rather than something which needs to run over and over again....
August 18, 2011 at 2:27 pm
I should have paid more attention - I didn't notice that you had only two columns. You've found a good solution - fingers crossed you don't ever get any more...
August 17, 2011 at 10:09 am
Brian Carlson (8/17/2011)
August 17, 2011 at 9:09 am
dji (8/17/2011)
August 17, 2011 at 4:28 am
Anyone has faced this issue and solved it?
Save yourself from Excel hell and output to CSV instead. Then (apart from max row issues) it doesn't matter which version of Excel...
August 16, 2011 at 10:00 am
Maybe change your query to return 'true' (has data) or 'false' (no data) instead and build your precedence constraint accordingly.
August 16, 2011 at 9:03 am
spin (8/16/2011)
i mean something like..
select * from openquery('select * from thisTable where date >=...
August 16, 2011 at 8:51 am
Is it Informix? You might do better in a Unix db forum ...
August 16, 2011 at 7:30 am
Viewing 15 posts - 11,176 through 11,190 (of 13,872 total)