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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
query
Sorry I was not clear TABLE ALPHA aplha_id team1 team2 -------- ------ ----- 1 100 106 2 109 111 3 100 0 TABLE TEAM teamid teamname ------ -------- 100 ars 106 mtc 109 juv 200 aja I want a query that retrieves only...- platp
- Post #3
- Forum: Microsoft SQL Server: Programming
-
query
hello, I have a noob question I have a table called Alpha aplha_id team1 team2 and a table called Team teamid teamname I cannot get the correct query in order to retrieve all the data from table Alpha where team1 to exist in table Team and team2 to exist in table Team OR TO be 0...- platp
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
mailmessage date
Well silly me!! I changed the regional settings to yyyy/mm/dd and when I have dw_1.SetItem(ll_row, "date_registered", datetime(msg.DateReceived)) it gives me the following error Microsoft OLE DB Provider for SQL Server Invalid character value for cast specification. when I have...- platp
- Post #3
- Forum: Sybase: PowerBuilder
-
mailmessage date
Hi, I writing an app that takes mails, parses them and put them in a db. I am using PB 10.2 , MS sql server 2000 and connect using OLE DB. Among others I have this piece of code mailMessage msg . . messagebox('date',msg.DateReceived) . dw_1.SetItem(ll_row, "date_registered"...- platp
- Thread
- Replies: 2
- Forum: Sybase: PowerBuilder
