That will take approximately 1 minute 30 seconds!

Given that [User::_LoadAssignments] is boolean, I'm wondering if the question mark is merely evaluating if the variable is true/false--> if true, then include the additional criteria of Prov.Scope and Prov.Facility;...

Just wondering where the Mozilla reference is coming from - could Firefox be involved?

engrshafiq4 (9/6/2011)

---

@SSCrazy

ok my questions are

1) how i will load table data to tempData(in your example)?

2) what are star ,Stir,My Fab Company etc in your example....eg (select 'star' Company union...

engrshafiq4 (9/6/2011)

---

Thanks for your reply

But i am facing project Deadline and do not have much time to implement these coding...

Can you please give me a stored procedure which do the...

And here is a soundex example.

;with tempData as

(select 'star' Company union select 'stir' union select 'My Fab Company')

select company from tempData

where soundex(company) like soundex('str')

engrshafiq4 (9/6/2011)

---

i want to search the no of characters in a field and to show the record having more characters matched.

how i can do these steps in stored proceedure

1)load all...

The code sample provided by ColdCoffee works fine except that it also assumed you would want to update strDomainName. So just exclude that part of the update and you're done:

UPDATE...

Perhaps the lack of response is the result of a lack of question.

harry.sh16 (8/29/2011)

---

I already have a package that loops through different (ADO) objects and loads 3 different excel destinations dynamically, need to change excel to access destination dynamically so that it...

So which bit is giving you problems? Are you able to import the file using a fixed-width flat-file connection manager? Or perhaps it is the breaking down of the data...

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