Pulivarthi Sasidhar (8/29/2011)

---

Hi All,

The CSV file is fixed length with no delimeter, contains rows.

ex:- single row contains

1asdusa1Comp2Elctr3Mech1Engg2Degre

sno,sname,scity,cno,cname,cno,cname,cno,cname,cno,cname,dno,dname,dno,dname,dno,dname

1,asd,usa,1,Comp,2,Elctr,3,Mech,4,Fina,1,Engg,2,Degre

Single row Contains- 3 datasets.

Student (sno,sname) -1 row

Class(cno,cname)- 4 rows

Department(dno,dname)-2 rows

How can i split...

akl (8/26/2011)

---

the restore to another server requires too many steps. back up prod, copy file across network, run restore, remove users due to login SID changes and restore users. I...

I assume you've decided against using BACKUP/RESTORE for some reason? That would be the simplest.

drew.allen (8/26/2011)

---

I think this is what you are looking for.

WITH Test(TestField) AS (

SELECT 'aaa'

UNION

SELECT 'abc'

UNION

SELECT 'bbb'

UNION

SELECT 'bcd'

UNION

SELECT 'ccc'

UNION

SELECT 'cccccc'

UNION

SELECT 'cccccccccccccccccccccccc'

)

SELECT *

FROM Test

WHERE NOT TestField LIKE '%[^' + Left(TestField,1) + ']%'

It...

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