I am trying to join the SHIP.INF.INV file to BI_LINES. The fields I am using are Buisness.Unit; Order Number; Order Line No and Schedule No. However, in the BI_lines record it is a numeric field as opposed to a text field in the SHIP.INF.INV. How can I join these tables in Access?
-----Original Message-----
From: Schlieper Paul
[mailto:mssqldba-ezmlmshield-x30292568.[Email address protected]
Sent: Monday, February 21, 2005 10:18 AM
To: LazyDBA Discussion
Subject: RE: To find query that run for long time
Use SQL Profiler.
P
-----Original Message-----
From: chakry
[mailto:mssqldba-ezmlmshield-x22544100.[Email address protected]
Sent: Monday, February 21, 2005 8:51 AM
To: LazyDBA Discussion
Subject: To find query that run for long time
Dear All,
For past few days I found our application is fast for sometime, and suddenly
goes down.
I think there must be few queries which are running for long time.
Can anybody tell me to find out the query which is running for long time?
Thanks & Regards,
Chakry
Mobile: +91 98402 57095
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page