Viewing 15 posts - 91 through 105 (of 540 total)
Hi. Phil's code is the way to go 🙂
Phil (the other one)
February 27, 2014 at 1:22 am
Hi to all. It's been a while since I did this! 🙂
I now use T-SQL scripts in 3 steps. The reason for restoring daily is our planning team like to...
September 20, 2013 at 4:16 am
Running the following on the Citrix server appears to have resolved the connection issue:
DSMAINT CONFIG /user:yourdomain\yourusername /pwd:yourpassword
I am unsure why as the password had not been changed.
Hope this might help...
April 24, 2013 at 1:18 am
Thanks for the responses. I will implement as suggesteed.
Phil
April 12, 2013 at 6:09 am
OK, it looks like I was over thinking it.
[Code]
UPDATE Documents
SET DocumentFileName = REPLACE(DocumentFileName,'TIF','pdf')
WHERE DocumentFileName LIKE '%.TIF' AND DocumentLinked = '1'
[/Code]
Can anyone see any potential issued with above code?
Kind Regards,
Phil.
April 12, 2013 at 5:05 am
Thanks Steven. I will have a play. Great stuff.
Many Thanks,
Phil.
November 18, 2012 at 7:49 am
Hi Steven. I read 'Jeff's' post after Eugene's replied (I did a search of the forum). To be honest I have no idea how to implement. I never took to...
November 15, 2012 at 9:04 am
Thanks for posting Eugene. The approach I have become used to implementing seems to work. I did search the forum many moons ago regards the approach you recommend but my...
November 13, 2012 at 7:54 am
Hi. I have managed to get it working. The query has been written for a report.
Let me explain. I was never able to workout how to pass values as...
November 13, 2012 at 7:21 am
OK coffee has helped. I can see the average value returned 150 is calculated by using unique numbers in the array.
Kind Regards,
Phil.
July 14, 2012 at 1:34 am
Hi. I have run code (see attached output). Using MO024297 (process test) as and example the average time is returned by the query is 150 (i have highlighted in red)....
July 14, 2012 at 12:05 am
Hi Matt (and to all those that have taken time to view). Great response. The end user (who you can loosly term as a customer 🙂 ) referred to a...
July 13, 2012 at 11:37 pm
Hi. So current output as per your post. I would like to look as follows:
Product..........Manufactured Qty...........Process..................Total Time......Avg Time Booked (hours)
1-FAU440A..............4........................ASSEMBLY...............62.................3.64
......................................................INSPECTION.............3.75..............0.93
......................................................STORES/DISPATCH....15.5..............5.16
......................................................TEST......................30.5..............2.77
1-FAU440B..............4........................ASSEMBLY..............3.25...............0.81
......................................................INSPECTION............1.25...............0.31
......................................................TEST.....................38..................2.71
Strictly speaking that's not all of it as I have not...
July 13, 2012 at 8:10 am
Hi. Thanks to those that have viewed. I have had a go at the required query.
WITH CompletedMO AS
(
SELECT
ManufacturingOrders.ManufacturingOrderId,
Products.ProductId,
LabourRates.LabourRateId AS ProcessName,
LabourTransactions.Quantity / 60 AS HoursBooked
FROM
LabourTransactions
INNER JOIN ManufacturingOrders ON LabourTransactions.ManufacturingOrder = ManufacturingOrders.ManufacturingOrder...
July 13, 2012 at 5:26 am
Pleased to hear you have resolved.
Phil.
May 18, 2012 at 9:31 am
Viewing 15 posts - 91 through 105 (of 540 total)