look at the post from GSquared regarding the StringParser in this thread: http://www.sqlservercentral.com/Forums/Topic439094-338-2.aspx

with it your statement becomes:

select * from table join dbo.stringparser(@id_list, ',') as list

on table.id = list.parsed

or

select *...

ejoeyz_85 (2/16/2008)

---

ok i 've changed the statement that suggested from u... when im trying to insert values then i got new error as u said..

subquery returned more than 1...

remember that if you set ansi_warnings on/off at the db level, you must disconnect/reconnect for the setting to propagate to your session.

let's start over. the code you just posted is your from your original post which results in this error: The objects "OrganizationDetail" and "OrganizationDetail" in the FROM clause have the...

SEAH SZE YIN (2/15/2008)

---

Please allow me to further explain my concern here:

The SQL script i posted here is extracted from an existing stored procedure of my system using SQL2000...

ejoeyz_85 (2/14/2008)

---

i have changed using ur recommendation... but when im trying to insert values into table v_OrganizationDetailType... its really done... but when i want to select to view data that...

ejoeyz_85 (2/14/2008)

---

i've changed the trigger command that u given to me buat when i was insert the value, i got this message Msg 512, Level 16, State 1, Procedure trg_InsertOrganization,...

insert OrganizationDetail (Org_name, Org_address, Org_tel_no, Org_fax_no, Org_email, Org_description, Type_application_id)

select distinct inserted.Org_name, inserted.Org_address, inserted.Org_tel_no,

inserted.Org_fax_no, inserted.Org_email, inserted.Org_description, OrganizationType.Type_application_id

from inserted inner join OrganizationType on inserted.Type_name = OrganizationType.Type_name

left join OrganizationDetail on inserted.Org_name =...

With that many addresses, you might want to look into the USPS address matching system. With it, you can cleanup and standardize mailing addresses, city, state, zips. Once...

store only minutes as an integer. you can get hours and minutes with a simple formula.

total_min = (hr * 60) + min

hour = total_min / 60

min =...

i have a problem with my trigger.. I have create my trigger to audit Users Table. The problem is, i want use the same trigger to audit other tables... what...

I agree with m.earl. If you have a large company, then each application/system should not be (re)defninig employees, divisions, departments, etc. A master database is absolutely required. ...

you only posted pseudo-code (CATALOG [...] WITH ) so this might be a case of the 'real' code differing slightly from the posted example. and now you're stating that...

what's the value of serverproperty('IsFullTextInstalled') on the server without fulltext indexed?

i still think there's something odd about your original post, since the create fulltext catalog should have failed. but...

so, you're saying that this block executes without error:

if (select serverproperty('IsFullTextInstalled')) = 1

Begin

EXEC sp_fulltext_database 'enable'

CREATE FULLTEXT CATALOG [...]

WITH ACCENT_SENSITIVITY = OFF AS DEFAULT

/*

CREATE FULLTEXT INDEX...