Search results for query: *

I have some code that Iam struggling with. It works fine until I add a column from different table called (d.commenttext). Originally this code below brought back thousands of rows. Yet, when I connected the (d.commenttext) field from the (vp_tmshtcommments d) table it only brings back a...

I have a code in reporting services SELECT*, UNPLANNED = (ACTUALHOURSWEEKTODATE + SCHEDULEDHOURSREMAINING) - SCHEDULEDHOURS, ANTICPATED = (ACTUALHOURSWEEKTODATE + SCHEDULEDHOURSREMAINING) FROM( SELECT DISTINCT A.HOMELABORLEVELNAME2, A.HOMELABORLEVELNAME3...

I have a report in reporting services. I have a field called... =Fields!SCHEDULEDHOURSWEEKTODATE.Value How do I return a 0.00 for that value field if nothing returns after I run the report? There are some occassions when data wont' exist. I tryed something like =IIF...

ROUND(convert(decimal(10,1), datediff(minute, shiftstartdate, shiftenddate) / 65.0), 1) This code right here brings back a 7.8 The value without the round is 7.85 So, if I change the code to convert(decimal(10,2) it brings back 7.90 How do I return a value of just 7.9. shiftstartdate and...

Got a question about grabbing a date in a fiscal period. Below is just a sample code that grabs data from this table back to 2008-10-31. As you can see each Year Period has a number for the month 01 through 12, then a 01, 02, 03, 04 ect for the week of the period. select [YPWEnd], [YPWPd]...

I have two different reports within one report in SSRS. Originally I want to hide both, then based on a paramater, or textbox, or checkbox give the user the ability to view one or the other. Is there a simple way of dong this? I see you can make the tables non-visible, but what would i put in...

Let's say I have the code below in Reporting Services as a seperate Dataset select distinct homelaborlevelname2 from vp_person where homelaborlevelname2 >= 'D' and homelaborlevelname2 <= 'E' order by homelaborlevelname2 This would bring back 'D1' 'D10' 'D11' 'D12' 'D2' 'D3' 'D4' 'D5' 'D6'...

DECLARE @WEDate smalldatetime, @Dist varchar(6) SET @WEDate = '01/24/2009' SET @Dist = 'D12' SELECT *, TotalTime = SundayTime + MondayTime + TuesdayTime + WednesdayTime + ThursdayTime + FridayTime + SaturdayTime This is the top of my query only. The sundaytime, mondaytime.. ect values are in...

DECLARE @WEDate smalldatetime, @Dist varchar(6) SET @WEDate = '12/06/2008' SET @Dist = 'D12' SELECT HomeLaborLevelName2, PERSONNUM, PersonFullName, HomeLaborLevelName3, HomeLaborLevelName5, HomeLaborLevelDsc5 as Jobtitle, MAX(CASE WHEN DOW = 'Sunday' THEN Schedule ELSE '' END) AS...

select distinct a.Homelaborlevelname5, a.HomeLaborLevelDsc5 from vp_person a where a.Homelaborlevelname5 = '1000'or a.Homelaborlevelname5 = '1001' or a.Homelaborlevelname5 = '1001' or a.Homelaborlevelname5 = '1010' or Let's say I have this code. Yet, I have like 20 more values...

DECLARE @ITbl TABLE ( laborlevelname3 VARCHAR(50), laborlevelname4 VARCHAR(50), personfullname VARCHAR(64), personnum VARCHAR(15), Age INT, applydate DATETIME, personid INT, TotalSecondsDay...

Field =Fields!TOTALTIME.Value In reporting services comes back as total seconds for a day. If I divide it like this. =Fields!TOTALTIME.Value / 60 / 60 I would get results like 7.50, and 7.88. How do I convert the field to show hour and minutes like on a clock? So everytime it hits 60 minutes...

Need help with SQL programming in microsoft sql server managment studio.

I am working on an existing report that is trying to calculate break times for all minor employees and finding all minors that worked more then 6 hours without a 30 minute break. Based on the tables I have and not having the ability to create new ones in the environment, I have one field that...