Search results for query: *

when you write your query you can use the TRIM() function on that column

Try replacing the server name in the TCP/IP box with the ip address of the server. Host=192.168.XX.XX;MyIP=NONE;ServerPort=49163;TO=45 On the database tab, put in the server name. On the login tab, put your username and password. Click test connection on the ODBC tab and see what you get. Mitch

Is this a 1 to 1 relationship? (One entry in table1 directly correlates to 1 entry in table2?) Run this SELECT table1.a_id, count(table2.b_id) as TOTAL FROM schema1.table1 as table1, schema2.table2 as table2 WHERE table1.a_id = table2.b_id group by table1.a_id order by TOTAL desc; You can...

Great! It's always best to avoid the use of <> for performance reasons.

Try putting an non unique index on (claim_ref, s1seq). Also, your delete could just be where claim_ref = @Claim_Ref and s1seq < @Last; Last is the max value, and you want to delete the ones less than max, correct?

Sybase manual says this: "INTO clause If EXECUTE INTO is used with an INSERT statement, the inserted row is returned in the second descriptor. For example, when using auto-increment primary keys or BEFORE INSERT triggers that generate primary key values, the EXECUTE statement provides a...

Are you using ASA or ASE? What version? I work in ASA V10 and the only way to do this is to declare your view and MATERIALIZED view. Mitch