ST Alpha - "it's like this.. " (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 155

In response to "Simple queries aren’t bad…more complex things get tricky quick -- nm" by Will Hunting

it's like this..

Posted by colin (aka colinski) Aug 2 '22, 19:18

this is the code for new tickets per week for a specific customer. this then populates the rest of the report section that lets me build tables, etc. it seems fairly simple in that it just pulls in the right columns then i work with how it looks outside of the code.

select
faultid as [Ticket ID]
, convert(date,dateadd(week, datediff(week, 0, dateoccured), 0)) as [Week Commencing]
, username as [User]
, symptom as [Summary]
, aareadesc as [Customer]
from
faults
join area on aarea=areaint
where
dateoccured > @startdate
and dateoccured < @enddate
and requesttypenew in (select rtid from requesttype where rtisproject=0 and rtisopportunity=0)

Responses:

I do believe I was able to read that. -- nm - Mop Aug 2, 19:26
just trying to get a feel for learning. i had about 12 reports i wanted, company quoted me $800 to write them :( -- nm - colin Aug 2, 19:21 1
- They thought it would take less than an hour per report? Hmm. -- nm - Beryllium Aug 2, 19:25

Post a message top

it's like this..

Replies are disabled on threads older than 7 days.