Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > SQL SERVER (TECHNET) > SQL Query Help Please....(you gurus should know it).
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 25th July 09:13
erin
External User
 
Posts: 1
Default SQL Query Help Please....(you gurus should know it).


1. I have a table of Service Request Status Changes.
2. Each time the Service Request is updated, a new RevisionID is generated
which shows what the revision was.
3. The Service Request can be updated several times in a month.
4. I need to report on how many distinct Service Requests were updated in a
month if their last revisionID was created in that month.

Example:

SR RevID Changed Date Changed
134 1 Contact Name 11-01-2005
145 1 Target Date 11-02-2005
145 2 Contact Name 11-02-2005
145 3 Approval 11-19-1005
165 1 Target Date 11-28-2005

My report should show that there were only 3 Service Requests that were
changed in the Month and last status is: 134=Contact Name, 145=Approval,
165=Target Date. Any help would be greatly appreciated!
  Reply With Quote


  sponsored links


2 25th July 09:14
hugo kornelis
External User
 
Posts: 1
Default SQL Query Help Please....(you gurus should know it).


Hi Erin,

You posted the same question in microsoft.public.sqlserver.server, where
it is already answered.

In the future, please post questions to one group only. And if you
really feel that a question fits two groups, then post one single
message to both groups instead of posting individual copies. This helps
to prevent people from wasting time answering a question that has
already been replied to in another group.

(How you post to several groups at once depends on the software you use
to post, but most software allows you to supoply a comma-seperated list
of groups when you post)

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
  Reply With Quote


  sponsored links


Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666