Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.
DECLARE @Project VARCHAR(30), @Phase VARCHAR(7), @Task VARCHAR(7), @custThroughDate DATETIME, Set @Project = '01080901' Set @Phase = '0301' Set @Task = '00' Set @custThroughDate = '5/29/2009' Select Project as Project, Phase as Phase, Task as Task, vwAA_BRRecTypeBillStatus.RecType, vwAA_BRRecTypeBillStatus.DetailGrouping, TransDate, CASE WHEN RecType IN ('Labor','Unposted') AND Transdate >= DATEADD(dd, - DATEPART(dw, CONVERT(varchar, @custThroughDate, 101)), CONVERT(varchar, @custThroughDate, 101)) AND Transdate <= @custThroughDate THEN RegHrs + OvtHrs + SpecialOvtHrs ELSE '' END AS CurrentWeekHrs FROM vwAA_BRRecTypeBillStatus where Project = @Project AND Phase = @Phase AND Task = @Task
|Not able to create a new table in sql server management studio. Error :The system cannot find the file specified.||9||52|
|How to return the value of the integer variables used in the stored procedure||3||34|
|how to check the index used by a MS SQL queries or SP||7||12|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!