Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~2K People Reached
Favorite Forums
Favorite Tags
mssql x 18
Member Avatar for LAMDB

Hi all, I need to run a query that performs a count(*) on a table. This gives me the subtotals for each group. Now I need to sumarize the subtotals with sum the results given by the previous count. What would be the best way to do this? Thanks.

Member Avatar for nahjipeel
0
1K
Member Avatar for LAMDB

Hi all, There is a (I assume) simple query i cannot figure out (in a best practice way). Let's say I have three tables: [LIST] Users[/LIST] [LIST] AOI (Areas of Interest) [/LIST] [List]Users_AOI (Simply containing userId and AOIId for all interests for each user)[/List] So far so good. Now I …

Member Avatar for cgyrob
0
163
Member Avatar for LAMDB

Hi All, I have to do a rather simple query, but a previous design error that did not make one of the fields required (it allows nulls when it shouldn't have) makes it a bit harder. I have a table projects and a table clients [B]Projects_Tbl[/B] ProjId ProjName ClientId [B]Clients_Tbl[/B] …

Member Avatar for LAMDB
0
144
Member Avatar for LAMDB

Hi there, I have a master detail set of tables with a one-to-many relationship. Let's call the tables Projects (master) and Markets (details). I need to allow users to query the database and be able to select projects by markets. In other words, users should be able to "say": "List …

Member Avatar for tesuji
0
277