Viewing 15 posts - 136 through 150 (of 541 total)
Thanks guys. Amit your example worked a treat.
Many Thanks,
Phil.
July 28, 2010 at 6:57 am
Hi Luke, some good points. I think scheduling is the best option. His machine hangs off a 8 port GB switch (shared) that patches into a single floor port that...
June 24, 2010 at 8:54 am
Gianluca that works fine.
Many thanks for your help.
Kind Regards,
Phil.
June 21, 2010 at 4:36 am
Hi. I have attached code2 (stored procedure) which produces the following errors:
Msg 102, Level 15, State 1, Procedure MyProc, Line 2
Incorrect syntax near '('.
Msg 137, Level 15, State 2, Procedure...
June 21, 2010 at 4:12 am
Hi, I did kinda try that. I have played with a few variations.
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[MyProc]
AS
BEGIN
SET NOCOUNT ON;
DECLARE @DueDate smalldatetime
DECLARE @From smalldatetime
DECLARE...
June 21, 2010 at 3:35 am
OK I have changed
IIF((SUM(Fields!DemandMinutes.Value) - SUM(Fields!TimeBooked.Value) / (Fields!ActivityCentreCapacity.Value) *100) <0
to
IIF((SUM(Fields!DemandMinutes.Value) - SUM(Fields!TimeBooked.Value)<0
Thanks,
Phil.
June 17, 2010 at 5:30 am
Hi Wayne. I have come up with:
=ROUND(IIF(SUM(Fields!DemandMinutes.Value) - SUM(Fields!TimeBooked.Value) >= Fields!ActivityCentreCapacity.Value,100,IIF((SUM(Fields!DemandMinutes.Value) - SUM(Fields!TimeBooked.Value) / (Fields!ActivityCentreCapacity.Value) *100) <0,0,SUM(Fields!DemandMinutes.Value - Fields!TimeBooked.Value) / (Fields!ActivityCentreCapacity.Value)*100)),2)
Logic:
The activity centre value is fixed for each activity...
June 17, 2010 at 4:20 am
Thanks Scott. Regards the VB yes this part has been done in visual studio (main code T-SQL in the dataset) so fair point.
Thanks,
Phil.
June 15, 2010 at 11:02 am
Great work guys, I really appreciate your time and efforts.
Many Thanks,
Phil.
June 12, 2010 at 6:41 am
Hi. I can understand why it doesn't make sense. The query is destined for a report to mirror information returned for production scheduling information. Production scheduling works on the wip...
June 11, 2010 at 3:49 am
OK, I have come up with:
DECLARE @DueDate smalldatetime
SET @DueDate = GETDATE();
SELECT ..............
CASE
WHEN DueDate < GETDATE() THEN @DueDate
ELSE DueDate
END AS DueDate,
If there is a better way please let me know.
Thanks,
Phil.
June 10, 2010 at 7:19 am
Problem solved (Luke made a comment in a PM that made me think). An Index Rebuild ran at the same time as the report. I moved the report schedule and...
June 10, 2010 at 12:54 am
Thanks for posting.
Kind Regards,
Phil.
June 10, 2010 at 12:51 am
If I remove CAST all is OK.
Thanks,
Phil.
June 9, 2010 at 2:14 pm
Viewing 15 posts - 136 through 150 (of 541 total)