Viewing 9 posts - 1 through 9 (of 9 total)
Thank you Lutz and Joe for your contributions. It is good to know that what I had been thinking about doing is pretty much the same as your suggestions....
January 19, 2011 at 9:49 am
Hey Joe,
Thanks for your reply. There are about 100 groups or so that I need to track. But I only need to track the number of people moving...
January 13, 2011 at 4:22 pm
LutzM (1/13/2011)
In your initial post you stated
My matrix needs to have the count of people that changed groups duing the month.
Referencing my previous post, how do you get...
January 13, 2011 at 4:17 pm
LutzM (1/13/2011)
2. Any number of persons can join the various groups even if they don't currently belong to one
How would your expected output look like if all the changes for...
January 13, 2011 at 3:46 pm
Thank you for the follow up. The "set of data" I refer to come from several sources which I need to consolidate into the structure that I will query...
January 13, 2011 at 2:41 pm
If you want to keep the first record, keep the query as it is; if you want to use the last one in the set of dupes, use MAX(). ...
January 13, 2011 at 11:56 am
I agree Steve. However, there are times when the GUID is needed before the record is created, so NewSequentialId() wouldn't work. Also, it only works on SQL2005 or...
June 15, 2010 at 3:01 pm
Either a GUID or an identity field will do for a primary key. Through the years, I have found that it is really a matter of choice. To...
June 14, 2010 at 2:44 pm
We had a situation similar to this. Our queries had NOLOCK hints and we were still experiencing deadlocks. We resolved it by placing indexes on the foreign keys....
January 8, 2010 at 2:18 pm
Viewing 9 posts - 1 through 9 (of 9 total)