Viewing 15 posts - 11,161 through 11,175 (of 13,877 total)
peterzeke (9/6/2011)
Phil -- thanks for the quick reply!Looks like I need to learn about setting breakpoints and viewing the values of variables....
--Pete
That will take approximately 1 minute 30 seconds!
September 6, 2011 at 3:57 pm
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;...
September 6, 2011 at 3:19 pm
Just wondering where the Mozilla reference is coming from - could Firefox be involved?
September 6, 2011 at 9:02 am
engrshafiq4 (9/6/2011)
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...
September 6, 2011 at 3:33 am
engrshafiq4 (9/6/2011)
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...
September 6, 2011 at 3:08 am
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')
September 6, 2011 at 3:01 am
engrshafiq4 (9/6/2011)
how i can do these steps in stored proceedure
1)load all...
September 6, 2011 at 2:48 am
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...
September 1, 2011 at 2:05 am
Perhaps the lack of response is the result of a lack of question.
August 30, 2011 at 1:32 am
harry.sh16 (8/29/2011)
August 30, 2011 at 1:31 am
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...
August 30, 2011 at 1:25 am
Pulivarthi Sasidhar (8/29/2011)
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...
August 29, 2011 at 10:38 am
akl (8/26/2011)
August 26, 2011 at 9:41 am
I assume you've decided against using BACKUP/RESTORE for some reason? That would be the simplest.
August 26, 2011 at 9:12 am
drew.allen (8/26/2011)
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...
August 26, 2011 at 9:02 am
Viewing 15 posts - 11,161 through 11,175 (of 13,877 total)