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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: rsmithinfo
- Content: Threads
- Order by date
-
Select distinct and multiple rows
My tables are little more complex but the example below explains my problem in more simple terms. Table1 test_id test_name Table2 table2_id test_id test_questionyes1 test_questionyes2 I would like to select the distinct test_id's where all the rows in Table2 have questionyes1 set to 1 and...- rsmithinfo
- Thread
- Replies: 11
- Forum: ANSI_SQL
-
Connecting to multiple databases
I have an SQL server instance and have two databases (this is not avoidable due to the client) I want to be able to use one connection string to access both and then in the queries use: databasename.dbo.tablename to access the tables. What connection string will work and do I need to change...- rsmithinfo
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
