Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Finding associations
Hello Newbie to Prolog - never used it yet! - however, looks interesting. I was wondering if Prolog can be used to solve my query below. I write many many queries in sql and it would be great if I could select a known field and something like Prolog could throw out the tables and joins... -
string collection
In the original table each order may have multiple invoice numbers - example ....... TABLE ORDERS order_no order_seq inv_no 1234 1 I14567 1234 2 I23454 4567 1 A34567 7894 1 2348900 7894 2 4459888GH 7894...- psivyer
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
DATE IN NEXT ROW ADDED TO CURRENT ROW
example ........ oc_id issue_id issue_date issue_date (next row date) 10 1234 01\01\2006 10\01\2006 10 1235 10\01\2006 04\02\2006 10 1236 04\02\2006 25 2461 15\01\2006 25\02\2006 25 2462 25\02\2006 01\04\2006 25...- psivyer
- Thread
- Replies: 9
- Forum: Microsoft SQL Server: Programming
