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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Query with cursor and loops (calculating # of days)
I'm having some difficulty with a query and hoping someone out there can provide me with assistance. What I am attempting to do is create one row, per id, and calculate the number of days (excluding gaps) table_data: id start_dt end_dt 1 1/23/2004 2/22/2004 1 2/17/2004...- chmdguy2
- Thread
- Replies: 16
- Forum: Microsoft SQL Server: Programming
-
left join structure
I've been having a problem with the structure of a simple 'no-match' query. For example, I have two tables... Table 1 and Table 2. I want to pull all the records from table 1 that are not in table two. Table 1 Table 2 Id Id Here's what I've written, but I'm a bit stuck...- chmdguy2
- Thread
- Replies: 14
- Forum: Microsoft SQL Server: Programming
