it looks like the data consistently has a dbl quote ending the last comment, followed by a three char monthly abbreviation that starts the next comment.;

if you did a repetitive...

Jeff Moden is the resident king of the Tally Table, and has contributed a number of articles on it here on SSC; you can find them in the search for...

can we see the trigger itself? it might not be written correctly, or not using the INSERTED table correctly and causing an error.

your problem is your function; to do a split you must return a TABLE, not a nvarchar string.

try this instead:

select *

from Loss_Mit.DM_ER_Portal_Usage_TBL

where Loan_Num in (select Item from dbo.DelimitedSplit ('1100123408,1100226532,1127116374',','))

order...

Angela S. (3/9/2010)

---

I don't want to delete ANY tables, I just want to create a copy of the database and remove the data. I need the tables, intact just...

here's a script that generates the DELETE FROM / TRUNCATE TABLE statements in foreign key hierarchy order; like i said before, i've found it's rare you want to delete all...

My question is similar to Paul's; what is it you want to see;

if you look at the data, which changes do you want to track? if you ignore the...

huston you can use something like this:

select

case

when myvalue like '%[^0-9]%'

then 'has chars'

else ;is numeric'

...

you can use the ALTER LOGIN command, i believe.

--name change due to marriage

ALTER LOGIN [DOMAIN_NAME\gallan] WITH NAME = [DOMAIN_NAME\gshepherd];

--domain name change?

ALTER LOGIN [DOMAIN_NAME\lowell] WITH NAME = [NEW_DOMAIN\lowell];

Ben have you ruled out parameter sniffing?

if your procedures have default values for some of the parameters, no matter whether you updated statistics or not, parameter sniffing could occur,...

Lowell (3/8/2010)

---

halifaxdal (3/8/2010)

---

thanks. it won't work.

The records are all associated with a UserID, all non 0 value.

When the input parameter is 0, all records should be pulled out.

When the input...

halifaxdal (3/8/2010)

---

thanks. it won't work.

The records are all associated with a UserID, all non 0 value.

When the input parameter is 0, all records should be pulled out.

When the input parameter...

yeah, to get you an intelligent example, instead of a crappy peudocode example, we'd need...

since you posted this in SQL Compact Edition, I'm guessing you are asking how to connect to a compact database?

http://www.connectionstrings.com/sql-server-2005-ce

Data...

there's a lot of factors in optimization; you'd really want to attach the execution plan here to get any really significant answers.

are all your joins on PK to FK relationsships?...