[Richard Ward]

Has anyone used this feature in Collections Management?  I’ve read through the documentation, but I can’t quite figure out what SQL code I’m supposed to insert into the Advanced Query window.

An example would be AWESOME…but if not a clearer explanation of what I’m supposed to insert would be great.

My specific question is this:

1. Am I supposed to insert code to do a SQL Select?
2. Or are they asking me to create SQL code to insert records into CN100100?

Thanks for your help!

——————————
Richard Ward
Vice President – Controller IPD
Storm Industries, Inc.
Torrance CA
——————————

[Brad Gilks]

Hi Richard,

The way I do it is to create a view to return any results I want to insert into the CN100100 and then paste the following query in the build query window. Just change the view name to whatever your view is called.

insert into CN100100 (USERID,CUSTNMBR,CPRCSTNM,CUSTNAME,BALOVER,CUSTBLNC,CUSTCLAS,CNTCPRSN,STMTNAME,ADRSCODE,ADDRESS1,ADDRESS2,CITY,STATE,ZIP,COUNTRY,PHONE1,FAX,SLPRSNID,SALSTERR,USERDEF1,USERDEF2,PreferredContactMethod,Time_Zone)

SELECT ‘@%USERID%@’ as USERID,CUSTNMBR,CPRCSTNM,CUSTNAME,BALOVER,CUSTBLNC,CUSTCLAS,CNTCPRSN,STMTNAME,ADRSCODE,ADDRESS1,ADDRESS2,CITY,STATE,ZIP,COUNTRY,PHONE1,FAX,SLPRSNID,SALSTERR,USERDEF1,USERDEF2,PreferredContactMethod,Time_Zone
FROM MY_View_Name_Here

——————————
Brad Gilks
Senior Programmer / Analyst
Medavie Blue Cross
Moncton
——————————
——————————————-