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!
Search results for query: *
- Users: Bubbles2610
- Order by date
-
selecting data from more than two tables
SELECT * FROM tbl1 WHERE EXISTS (SELECT 1 FROM tbl2 WHERE tbl2.id2 = tbl1.id) OR EXISTS (SELECT 1 FROM tbl3 WHERE tbl3.id2 = tbl1.id AND EXISTS (SELECT 1 FROM tbl4...- Bubbles2610
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Date selecting with date from 1. jan 1900
I'm curious now. I created a table and populated it with the sample data you provided. When I run your query I don't get any results returned because the dates generated by the dateadd function are from august & september 2004. This is what I did >>>>>>>>>>>>>>>>>>>> create table...- Bubbles2610
- Post #7
- Forum: Microsoft SQL Server: Programming
-
Date selecting with date from 1. jan 1900
I don't understand exactly what you are trying to do with this SQL statement but I have noticed one thing. The reference to createdate in the WHERE clause is incorrect. It should be referencing the actual column name in your view or table and not the column alias i.e. create_date instead of...- Bubbles2610
- Post #3
- Forum: Microsoft SQL Server: Programming
