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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL SELECT HELP
Yes, it was a typo! Lets say you have more than 2 TAGNAMEIDs (50 of them). Is this the only way to get all 50 with a single call? Thank you again for all the replies. -
SQL SELECT HELP
If I add another column to the above given table as LOCATIONID, that means the values will be as: 20, 555, 6-14-2007 12:34:00, 23.51 20, 666, 6-14-2007 12:34:00, 190.32 20, 555, 6-15-2007 12:34:00, 21.31 20, 666, 6-15-2007 12:34:00, 187.35 21, 555, 6-16-2007 12:34:00, 32.37 21, 666, 6-16-2007... -
-
SQL SELECT HELP
I have a database table where TAGNAMEID, DATETIME, TAGNAMEVALUE are the columns. The values in each columns may look as: 555, 6-14-2007 12:34:00, 23.51 666, 6-14-2007 12:34:00, 190.32 555, 6-15-2007 12:34:00, 21.31 666, 6-15-2007 12:34:00, 187.35 555, 6-16-2007 12:34:00, 32.37 666, 6-16-2007...
