Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rwaldron
Posting Yak Master
131 Posts |
 Posted - 2008-07-03 : 05:22:26
|
| Hi all..I can create a connection in Visual web developer to my ODBC Pervasive connection.Then the query below runs ok.I want to run this query purely in SQL server NOT VWDCan someone tell me how to go about this in an sql query or do I need to do it using DTS ??ie: Create a connection in the query for jobse and jobnotes then run below code...Thx Ray..The query in VWD isSELECT JOBSE.RefNumber, JOBSE.InWorkshopDate, JOBSE.InWorkshopTime, JOBNOTES.Invoice_TextFROM JOBSE, JOBNOTESWHERE JOBSE.RefNumber = JOBNOTES.RefNumber AND (JOBSE.InWorkshopDate >= CURDATE() - 4)ORDER BY JOBSE.InWorkshopDate DESC |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-07-03 : 05:43:23
|
| You need to use SQL Management Studio, this is the client tool for SQl Server 2005 and can be found on the SQl Server install disk. |
 |
|
|
|
|
|
Defining an ODBC Connection in SQL