peanuts91 (8/26/2011)

---

Thanks Phil,

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...

peanuts91 (8/26/2011)

---

Hi guys,

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...

John Mitchell-245523 (8/26/2011)

---

Henk

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...

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.

...and you should check the date of the original posts 🙂

'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...

karthikeyan-444867 (8/24/2011)

---

Procedural program - some series of computational steps to be carried to solve a problem.

Declare @id int

select @id = id from emp where eno = 5

can we say it...

Ninja's_RGR'us (8/22/2011)

---

New "feature". Order bys are ignored in the views.

Nothing you can do except use order by from outside the view =>

Select Whatever From dbo.View ORDER BY...

Not 'as well' - just change the config file and leave the BIDS version alone.

Got a slight wind problem Jeff? 😀

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

John Mitchell-245523 (8/19/2011)

---

I think it would be simpler if, instead of updating the config file, either you evaluate the variable using an expression, or you output a value at the...

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....

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...

Brian Carlson (8/17/2011)

---

I am reading a flat file that has additional rows I want to ignore. The additional rows are status rows and occur rarely and have no column delimeters....