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!
-
Sum of items in one table related to items in another table; 3rd table shows relationships
Greetings, My apologies for forgetting to use the pre tag. Olaf, thank you. I figured out what I need to do. I don't need user id in this case. Thanks very much. I will share in case others need to do something like this. This counts totals of individual file downloads: SELECT p.id...- rootl
- Post #4
- Forum: Microsoft SQL Server: Programming
-
Sum of items in one table related to items in another table; 3rd table shows relationships
Greetings. I have 3 tables below. One shows 'posts' The second shows 'file_logs' It stores records of each time a file is downloaded. The third shows 'relationships' between posts and files. Usually two files are connected to 1 post. I would like to show sums of 'file ids' grouped by...- rootl
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
Search engine - need to display results on separate page
You are right - thanks I will put it into a different view. Much easier solution. Thanks :)- rootl
- Post #3
- Forum: Microsoft: ASP.NET
-
Search engine - need to display results on separate page
Greetings, I have a search engine working well which uses a Repeater control to display results. I need to be able to have the results (using repeater) show on a separate page using Response.Redirect or something similar. The search button code is below. Thanks. protected void...- rootl
- Thread
- Replies: 3
- Forum: Microsoft: ASP.NET
-
c# search need to display results on separate page
Greetings, I have a search engine working well which uses a Repeater control to display results. I need to be able to have the results (using repeater) show on a separate page using Response.Redirect or something similar. The search button code is below. Thanks. protected void...- rootl
- Thread
- Replies: 1
- Forum: C# (C sharp): Microsoft
-
MS SQL Joins, Union, combined queries from 2 tables in one view
Thank you! This is perfect!- rootl
- Post #4
- Forum: Microsoft SQL Server: Programming
-
MS SQL Joins, Union, combined queries from 2 tables in one view
Greetings, I have 2 tables: "ThreeFloors" and "FourthFloor". I have 3 queries which work well individually. One of the queries combines rows from both tables where Date and Hour columns match. Another query shows only rows from the ThreeFloors, and the third query shows only rows from the...- rootl
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
