Recent content by suenram

This is one area that starts out simple and grows complex as you get many, many stored procedures. I started by following this recommendation: http://vyaskn.tripod.com/object_naming.htm I believe Ins/Upd/Del/Sel should be in the name as well as having them in some sort of logical grouping so...

This works better for an ERwin reference:<br><A HREF="http://www.cai.com/products/platinum/appdev/erwin_ps.htm" TARGET="_new">http://www.cai.com/products/platinum/appdev/erwin_ps.htm</A><br>

You might want to look into buying ERwin.&nbsp;&nbsp;If you want to read about it, go to <A HREF="http://www.platinum.com/products/appdev" TARGET="_new">www.platinum.com/products/appdev</A>.<br><br>We keep our MVS DB2 models organized with ERwin.&nbsp;&nbsp;We also use this tool for Oracle, Sql...

I think there was a problem with the comma or having 2 values in 'where (tbl_nm, tbl_refresh_ts)' but you got us on the right track and the following seems to work:<br> <br> Select distinct tbl_nm, tbl_refresh_ts,project_nm, data_Source_nm, refresher_id, data_asOf_dt <br> from control_log<br>...

I am trying to get the latest time that a table was refreshed in our database and then<br> print all the information related to that table. The Group by clause keeps us from printing the whole row of data. Could someone help me get the whole row of data after I have found the row I want with a...

I would like to know if there is any maximum on the number of items you can have in an IN CLAUSE with SQL Server 6.5 or 7.0. Thanks for any input. Karen Suenram

Thank you for the warning. We do have one group in our area using Access97 as a frontend to DB2 MVS on the mainframe. They are not having any trouble. They use Pass-through queries but do not have Access linked tables. <br> Karen Suenram

Hello, I am interested in your opinion on Access97 Linked Tables. We have upsized an Access application to Sql Server and are testing 3 ways.<br> Multiple users in the Access database (original form)<br> Multiple users using application (upsized with linked tables)<br> Multiple users using...