nah. when i build a trace to say return everything w reads over 1000 i was hoping the trace had an export script to sql and maybe it would show...

thats the thing. The proc only does it sometimes. i dont know why. i assume it has something to do w the indexes being rebuild however havent proven that.

Right...

So just to clarify this post deal w/ the number of sql calls relative to the number of cache hits. Meaning what's the percent of times a cached execution plan...

very cool thanks guys. I'm going to integrate into this process a way to backup the trans logs if it goes above 50% free space.

is there a way to temporarily turn off the writting to trans log for this process?

if i were to take the schema route the uses would automatically have the proper rights to those newely created tables correct? Assumeing i set up the users permission to...

Alright, so it turns out the webUser was already tied to a webUser role. Are you guys saying if i ensure the webUser role has access to these new tables...

Very well. Then. Thanks guys. I'm going to tool around w/ urr suggestions and get back to u.

thanks

sorry. i do agree w the indexing just not the loop haters out there

As my name suggests i dont totally agree. It depends where you work at and who or what team will be supporting it. On occasion these guys tend to provide...

Another option is to use the split function and load each column name as a record in a table. U would need to first create the split function. Code at...

I don’t really need help parsing the data. I was just purposing a question. Why is there no substring function that has a starting position and ending position as parameters....

--sorry. i forgot an "and" in there

--somehting like this

SELECT DISTINCT

c.ContactID,

c.ContactName,

c.PhoneNum,

c.Fax,

c.PersonalEmailAddress,

c.CompanyPhoneNum,

c.GroupEmailAddress,

c.Address1,

c.Address2,

c.Address3,

c.Address4,

c.City,

c.State,

c.Zip,

c.CountryCode

FROM

tblDCF_SubAccounts s,

tblDCF_Contacts_Accounts a,...

actually now that i think about it. i would still have the redundant code in the to calculate the end position. I wouldn't have to do subtraction to get the...

--somehting like this

SELECT DISTINCT

c.ContactID,

c.ContactName,

c.PhoneNum,

c.Fax,

c.PersonalEmailAddress,

c.CompanyPhoneNum,

c.GroupEmailAddress,

c.Address1,

c.Address2,

c.Address3,

c.Address4,

c.City,

c.State,

c.Zip,

c.CountryCode

FROM

tblDCF_SubAccounts s,

tblDCF_Contacts_Accounts a,

tblDCF_Contacts c

WHERE

a.ContactID = c.ContactID AND

a.ContactType...