date query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with the following data:

[Upgrade date] [Ticket Number] [Agent Opened Date]
2/12/2006 235556 5/18/2006

I need to trend the tickets opened weekly for a 30 day period prior to the
upgrade date. I am currently showing only [Ticket Number] Where [Agent
Opened Date] >=[Upgrade date]
Can not figure out how to then trend the output.

Thank you!
 
Is this what you are looking for?

SELECT Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2) AS Expr1, Count(naulerich.[Ticket Number]) AS [CountOfTicket
Number]
FROM naulerich
GROUP BY Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2);
 
Thank you Karl, but I am lost...can I send the current sql for your review?
I am not sure how to incorporate the statement below.

Thanks! :)

KARL DEWEY said:
Is this what you are looking for?

SELECT Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2) AS Expr1, Count(naulerich.[Ticket Number]) AS [CountOfTicket
Number]
FROM naulerich
GROUP BY Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2);


naulerich said:
I have a table with the following data:

[Upgrade date] [Ticket Number] [Agent Opened Date]
2/12/2006 235556 5/18/2006

I need to trend the tickets opened weekly for a 30 day period prior to the
upgrade date. I am currently showing only [Ticket Number] Where [Agent
Opened Date] >=[Upgrade date]
Can not figure out how to then trend the output.

Thank you!
Click to expand...
Click to expand...
 
Post it.

naulerich said:
Thank you Karl, but I am lost...can I send the current sql for your review?
I am not sure how to incorporate the statement below.

Thanks! :)

KARL DEWEY said:
Is this what you are looking for?

SELECT Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2) AS Expr1, Count(naulerich.[Ticket Number]) AS [CountOfTicket
Number]
FROM naulerich
GROUP BY Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2);


naulerich said:
I have a table with the following data:

[Upgrade date] [Ticket Number] [Agent Opened Date]
2/12/2006 235556 5/18/2006

I need to trend the tickets opened weekly for a 30 day period prior to the
upgrade date. I am currently showing only [Ticket Number] Where [Agent
Opened Date] >=[Upgrade date]
Can not figure out how to then trend the output.

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
SELECT Quality_Affected_Cust.[CR Reported Date],
Quality_Affected_Cust.[Affected Version], Quality_Affected_Cust.[CR #],
Quality_Affected_Cust.[CR Type], Quality_Affected_Cust.[Customer Name],
Quality_Affected_Cust.[Global Id], Quality_Affected_Cust.[CR Summary],
Quality_Affected_Cust.[CR Priority], Quality_Affected_Cust.[WO Targeted
Versions], Quality_Affected_Cust.[DI Status], Quality_Affected_Cust.[CR
Status], Quality_Affected_Cust.[CR Queue], Quality_Affected_Cust.[CR
Substatus], Quality_Affected_Cust.[Description/How to Reproduce],
Quality_Affected_Cust.[Primary Module], Quality_Affected_Cust.[Primary
Function], Quality_Affected_Cust.[Product Line],
Quality_Affected_Cust.Product, [xBeta Project Table].[Product / Project],
[xBeta Project Table].[Pilot Status], [xBeta Project Table].[Upgrade Date]
FROM Quality_Affected_Cust INNER JOIN [xBeta Project Table] ON
Quality_Affected_Cust.[Global Id] = [xBeta Project Table].[Global ID]
GROUP BY Quality_Affected_Cust.[CR Reported Date],
Quality_Affected_Cust.[Affected Version], Quality_Affected_Cust.[CR #],
Quality_Affected_Cust.[CR Type], Quality_Affected_Cust.[Customer Name],
Quality_Affected_Cust.[Global Id], Quality_Affected_Cust.[CR Summary],
Quality_Affected_Cust.[CR Priority], Quality_Affected_Cust.[WO Targeted
Versions], Quality_Affected_Cust.[DI Status], Quality_Affected_Cust.[CR
Status], Quality_Affected_Cust.[CR Queue], Quality_Affected_Cust.[CR
Substatus], Quality_Affected_Cust.[Description/How to Reproduce],
Quality_Affected_Cust.[Primary Module], Quality_Affected_Cust.[Primary
Function], Quality_Affected_Cust.[Product Line],
Quality_Affected_Cust.Product, [xBeta Project Table].[Product / Project],
[xBeta Project Table].[Pilot Status], [xBeta Project Table].[Upgrade Date],
Quality_Affected_Cust.[CR Reported Date]
HAVING (((Quality_Affected_Cust.[CR Reported Date])>=[Upgrade Date]) AND
((Quality_Affected_Cust.Product)<>"Demo Media"));

KARL DEWEY said:
Post it.

naulerich said:
Thank you Karl, but I am lost...can I send the current sql for your review?
I am not sure how to incorporate the statement below.

Thanks! :)

KARL DEWEY said:
Is this what you are looking for?

SELECT Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2) AS Expr1, Count(naulerich.[Ticket Number]) AS [CountOfTicket
Number]
FROM naulerich
GROUP BY Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2);


:

I have a table with the following data:

[Upgrade date] [Ticket Number] [Agent Opened Date]
2/12/2006 235556 5/18/2006

I need to trend the tickets opened weekly for a 30 day period prior to the
upgrade date. I am currently showing only [Ticket Number] Where [Agent
Opened Date] >=[Upgrade date]
Can not figure out how to then trend the output.

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
[CR #]=[Ticket Number] in the example first posted.

naulerich said:
SELECT Quality_Affected_Cust.[CR Reported Date],
Quality_Affected_Cust.[Affected Version], Quality_Affected_Cust.[CR #],
Quality_Affected_Cust.[CR Type], Quality_Affected_Cust.[Customer Name],
Quality_Affected_Cust.[Global Id], Quality_Affected_Cust.[CR Summary],
Quality_Affected_Cust.[CR Priority], Quality_Affected_Cust.[WO Targeted
Versions], Quality_Affected_Cust.[DI Status], Quality_Affected_Cust.[CR
Status], Quality_Affected_Cust.[CR Queue], Quality_Affected_Cust.[CR
Substatus], Quality_Affected_Cust.[Description/How to Reproduce],
Quality_Affected_Cust.[Primary Module], Quality_Affected_Cust.[Primary
Function], Quality_Affected_Cust.[Product Line],
Quality_Affected_Cust.Product, [xBeta Project Table].[Product / Project],
[xBeta Project Table].[Pilot Status], [xBeta Project Table].[Upgrade Date]
FROM Quality_Affected_Cust INNER JOIN [xBeta Project Table] ON
Quality_Affected_Cust.[Global Id] = [xBeta Project Table].[Global ID]
GROUP BY Quality_Affected_Cust.[CR Reported Date],
Quality_Affected_Cust.[Affected Version], Quality_Affected_Cust.[CR #],
Quality_Affected_Cust.[CR Type], Quality_Affected_Cust.[Customer Name],
Quality_Affected_Cust.[Global Id], Quality_Affected_Cust.[CR Summary],
Quality_Affected_Cust.[CR Priority], Quality_Affected_Cust.[WO Targeted
Versions], Quality_Affected_Cust.[DI Status], Quality_Affected_Cust.[CR
Status], Quality_Affected_Cust.[CR Queue], Quality_Affected_Cust.[CR
Substatus], Quality_Affected_Cust.[Description/How to Reproduce],
Quality_Affected_Cust.[Primary Module], Quality_Affected_Cust.[Primary
Function], Quality_Affected_Cust.[Product Line],
Quality_Affected_Cust.Product, [xBeta Project Table].[Product / Project],
[xBeta Project Table].[Pilot Status], [xBeta Project Table].[Upgrade Date],
Quality_Affected_Cust.[CR Reported Date]
HAVING (((Quality_Affected_Cust.[CR Reported Date])>=[Upgrade Date]) AND
((Quality_Affected_Cust.Product)<>"Demo Media"));

KARL DEWEY said:
Post it.

naulerich said:
Thank you Karl, but I am lost...can I send the current sql for your review?
I am not sure how to incorporate the statement below.

Thanks! :)

:

Is this what you are looking for?

SELECT Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2) AS Expr1, Count(naulerich.[Ticket Number]) AS [CountOfTicket
Number]
FROM naulerich
GROUP BY Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2);


:

I have a table with the following data:

[Upgrade date] [Ticket Number] [Agent Opened Date]
2/12/2006 235556 5/18/2006

I need to trend the tickets opened weekly for a 30 day period prior to the
upgrade date. I am currently showing only [Ticket Number] Where [Agent
Opened Date] >=[Upgrade date]
Can not figure out how to then trend the output.

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
Now I am lost as the SQL you post has only one field that matches your
orignal post.

I thought you did not understand the SQL I gave to you as a solution to your
orignal post.

naulerich said:
[CR #]=[Ticket Number] in the example first posted.

naulerich said:
SELECT Quality_Affected_Cust.[CR Reported Date],
Quality_Affected_Cust.[Affected Version], Quality_Affected_Cust.[CR #],
Quality_Affected_Cust.[CR Type], Quality_Affected_Cust.[Customer Name],
Quality_Affected_Cust.[Global Id], Quality_Affected_Cust.[CR Summary],
Quality_Affected_Cust.[CR Priority], Quality_Affected_Cust.[WO Targeted
Versions], Quality_Affected_Cust.[DI Status], Quality_Affected_Cust.[CR
Status], Quality_Affected_Cust.[CR Queue], Quality_Affected_Cust.[CR
Substatus], Quality_Affected_Cust.[Description/How to Reproduce],
Quality_Affected_Cust.[Primary Module], Quality_Affected_Cust.[Primary
Function], Quality_Affected_Cust.[Product Line],
Quality_Affected_Cust.Product, [xBeta Project Table].[Product / Project],
[xBeta Project Table].[Pilot Status], [xBeta Project Table].[Upgrade Date]
FROM Quality_Affected_Cust INNER JOIN [xBeta Project Table] ON
Quality_Affected_Cust.[Global Id] = [xBeta Project Table].[Global ID]
GROUP BY Quality_Affected_Cust.[CR Reported Date],
Quality_Affected_Cust.[Affected Version], Quality_Affected_Cust.[CR #],
Quality_Affected_Cust.[CR Type], Quality_Affected_Cust.[Customer Name],
Quality_Affected_Cust.[Global Id], Quality_Affected_Cust.[CR Summary],
Quality_Affected_Cust.[CR Priority], Quality_Affected_Cust.[WO Targeted
Versions], Quality_Affected_Cust.[DI Status], Quality_Affected_Cust.[CR
Status], Quality_Affected_Cust.[CR Queue], Quality_Affected_Cust.[CR
Substatus], Quality_Affected_Cust.[Description/How to Reproduce],
Quality_Affected_Cust.[Primary Module], Quality_Affected_Cust.[Primary
Function], Quality_Affected_Cust.[Product Line],
Quality_Affected_Cust.Product, [xBeta Project Table].[Product / Project],
[xBeta Project Table].[Pilot Status], [xBeta Project Table].[Upgrade Date],
Quality_Affected_Cust.[CR Reported Date]
HAVING (((Quality_Affected_Cust.[CR Reported Date])>=[Upgrade Date]) AND
((Quality_Affected_Cust.Product)<>"Demo Media"));

KARL DEWEY said:
Post it.

:

Thank you Karl, but I am lost...can I send the current sql for your review?
I am not sure how to incorporate the statement below.

Thanks! :)

:

Is this what you are looking for?

SELECT Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2) AS Expr1, Count(naulerich.[Ticket Number]) AS [CountOfTicket
Number]
FROM naulerich
GROUP BY Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2);


:

I have a table with the following data:

[Upgrade date] [Ticket Number] [Agent Opened Date]
2/12/2006 235556 5/18/2006

I need to trend the tickets opened weekly for a 30 day period prior to the
upgrade date. I am currently showing only [Ticket Number] Where [Agent
Opened Date] >=[Upgrade date]
Can not figure out how to then trend the output.

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
Sorry for the confusion here is what I am trying to do:

[Upgrade date] [CR #] [CR Reported Data]
2/12/2006 235556 5/18/2006

Trend the [CR #] weekly for a period of time 30 days prior to the [Upgrade
Date]

Thank you! :)

KARL DEWEY said:
Now I am lost as the SQL you post has only one field that matches your
orignal post.

I thought you did not understand the SQL I gave to you as a solution to your
orignal post.

naulerich said:
[CR #]=[Ticket Number] in the example first posted.

naulerich said:
SELECT Quality_Affected_Cust.[CR Reported Date],
Quality_Affected_Cust.[Affected Version], Quality_Affected_Cust.[CR #],
Quality_Affected_Cust.[CR Type], Quality_Affected_Cust.[Customer Name],
Quality_Affected_Cust.[Global Id], Quality_Affected_Cust.[CR Summary],
Quality_Affected_Cust.[CR Priority], Quality_Affected_Cust.[WO Targeted
Versions], Quality_Affected_Cust.[DI Status], Quality_Affected_Cust.[CR
Status], Quality_Affected_Cust.[CR Queue], Quality_Affected_Cust.[CR
Substatus], Quality_Affected_Cust.[Description/How to Reproduce],
Quality_Affected_Cust.[Primary Module], Quality_Affected_Cust.[Primary
Function], Quality_Affected_Cust.[Product Line],
Quality_Affected_Cust.Product, [xBeta Project Table].[Product / Project],
[xBeta Project Table].[Pilot Status], [xBeta Project Table].[Upgrade Date]
FROM Quality_Affected_Cust INNER JOIN [xBeta Project Table] ON
Quality_Affected_Cust.[Global Id] = [xBeta Project Table].[Global ID]
GROUP BY Quality_Affected_Cust.[CR Reported Date],
Quality_Affected_Cust.[Affected Version], Quality_Affected_Cust.[CR #],
Quality_Affected_Cust.[CR Type], Quality_Affected_Cust.[Customer Name],
Quality_Affected_Cust.[Global Id], Quality_Affected_Cust.[CR Summary],
Quality_Affected_Cust.[CR Priority], Quality_Affected_Cust.[WO Targeted
Versions], Quality_Affected_Cust.[DI Status], Quality_Affected_Cust.[CR
Status], Quality_Affected_Cust.[CR Queue], Quality_Affected_Cust.[CR
Substatus], Quality_Affected_Cust.[Description/How to Reproduce],
Quality_Affected_Cust.[Primary Module], Quality_Affected_Cust.[Primary
Function], Quality_Affected_Cust.[Product Line],
Quality_Affected_Cust.Product, [xBeta Project Table].[Product / Project],
[xBeta Project Table].[Pilot Status], [xBeta Project Table].[Upgrade Date],
Quality_Affected_Cust.[CR Reported Date]
HAVING (((Quality_Affected_Cust.[CR Reported Date])>=[Upgrade Date]) AND
((Quality_Affected_Cust.Product)<>"Demo Media"));

:

Post it.

:

Thank you Karl, but I am lost...can I send the current sql for your review?
I am not sure how to incorporate the statement below.

Thanks! :)

:

Is this what you are looking for?

SELECT Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2) AS Expr1, Count(naulerich.[Ticket Number]) AS [CountOfTicket
Number]
FROM naulerich
GROUP BY Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2);


:

I have a table with the following data:

[Upgrade date] [Ticket Number] [Agent Opened Date]
2/12/2006 235556 5/18/2006

I need to trend the tickets opened weekly for a 30 day period prior to the
upgrade date. I am currently showing only [Ticket Number] Where [Agent
Opened Date] >=[Upgrade date]
Can not figure out how to then trend the output.

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
Karl,

Do you have enough info to help me incorrporate the statement that you
created?

Thank you! :)

KARL DEWEY said:
Now I am lost as the SQL you post has only one field that matches your
orignal post.

I thought you did not understand the SQL I gave to you as a solution to your
orignal post.

naulerich said:
[CR #]=[Ticket Number] in the example first posted.

naulerich said:
SELECT Quality_Affected_Cust.[CR Reported Date],
Quality_Affected_Cust.[Affected Version], Quality_Affected_Cust.[CR #],
Quality_Affected_Cust.[CR Type], Quality_Affected_Cust.[Customer Name],
Quality_Affected_Cust.[Global Id], Quality_Affected_Cust.[CR Summary],
Quality_Affected_Cust.[CR Priority], Quality_Affected_Cust.[WO Targeted
Versions], Quality_Affected_Cust.[DI Status], Quality_Affected_Cust.[CR
Status], Quality_Affected_Cust.[CR Queue], Quality_Affected_Cust.[CR
Substatus], Quality_Affected_Cust.[Description/How to Reproduce],
Quality_Affected_Cust.[Primary Module], Quality_Affected_Cust.[Primary
Function], Quality_Affected_Cust.[Product Line],
Quality_Affected_Cust.Product, [xBeta Project Table].[Product / Project],
[xBeta Project Table].[Pilot Status], [xBeta Project Table].[Upgrade Date]
FROM Quality_Affected_Cust INNER JOIN [xBeta Project Table] ON
Quality_Affected_Cust.[Global Id] = [xBeta Project Table].[Global ID]
GROUP BY Quality_Affected_Cust.[CR Reported Date],
Quality_Affected_Cust.[Affected Version], Quality_Affected_Cust.[CR #],
Quality_Affected_Cust.[CR Type], Quality_Affected_Cust.[Customer Name],
Quality_Affected_Cust.[Global Id], Quality_Affected_Cust.[CR Summary],
Quality_Affected_Cust.[CR Priority], Quality_Affected_Cust.[WO Targeted
Versions], Quality_Affected_Cust.[DI Status], Quality_Affected_Cust.[CR
Status], Quality_Affected_Cust.[CR Queue], Quality_Affected_Cust.[CR
Substatus], Quality_Affected_Cust.[Description/How to Reproduce],
Quality_Affected_Cust.[Primary Module], Quality_Affected_Cust.[Primary
Function], Quality_Affected_Cust.[Product Line],
Quality_Affected_Cust.Product, [xBeta Project Table].[Product / Project],
[xBeta Project Table].[Pilot Status], [xBeta Project Table].[Upgrade Date],
Quality_Affected_Cust.[CR Reported Date]
HAVING (((Quality_Affected_Cust.[CR Reported Date])>=[Upgrade Date]) AND
((Quality_Affected_Cust.Product)<>"Demo Media"));

:

Post it.

:

Thank you Karl, but I am lost...can I send the current sql for your review?
I am not sure how to incorporate the statement below.

Thanks! :)

:

Is this what you are looking for?

SELECT Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2) AS Expr1, Count(naulerich.[Ticket Number]) AS [CountOfTicket
Number]
FROM naulerich
GROUP BY Format([Upgrade date],"yyyy") & Right("0" & Format([Upgrade
date],"ww"),2);


:

I have a table with the following data:

[Upgrade date] [Ticket Number] [Agent Opened Date]
2/12/2006 235556 5/18/2006

I need to trend the tickets opened weekly for a 30 day period prior to the
upgrade date. I am currently showing only [Ticket Number] Where [Agent
Opened Date] >=[Upgrade date]
Can not figure out how to then trend the output.

Thank you!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top