Viewing 15 posts - 11,176 through 11,190 (of 13,877 total)
peanuts91 (8/26/2011)
but actually I need to check if all characters in my string are the same without to know the length of my string.
Tell me if I'm not clear...
August 26, 2011 at 8:24 am
peanuts91 (8/26/2011)
In order to clean up some tables in my database I would like to find all records like 'aaaaaaaa' or 'bbbb' or 'ccccc'....'zzzzz'.
Is there any functions existing to...
August 26, 2011 at 8:09 am
John Mitchell-245523 (8/26/2011)
I don't know of any way to change the order in which the derived columns are displayed. However, I can't think of any reason why it would...
August 26, 2011 at 3:05 am
Are you really intending to put millions of rows into a spreadsheet?
May I ask what the business driver is? - there might be a better alternative.
August 25, 2011 at 1:52 am
Amar009 (8/24/2011)
You should check this post.
...and you should check the date of the original posts 🙂
August 24, 2011 at 7:40 am
'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
Viewing 15 posts - 11,176 through 11,190 (of 13,877 total)