Viewing 15 posts - 91 through 105 (of 541 total)
Hi. Phil's code is the way to go 🙂
Phil (the other one)
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
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...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
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...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
April 24, 2013 at 1:18 am
Thanks for the responses. I will implement as suggesteed.
Phil
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
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.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
April 12, 2013 at 5:05 am
Thanks Steven. I will have a play. Great stuff.
Many Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
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...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
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...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
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...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
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.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
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)....
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
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...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
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...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
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...
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
July 13, 2012 at 5:26 am
Pleased to hear you have resolved.
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper
May 18, 2012 at 9:31 am
Viewing 15 posts - 91 through 105 (of 541 total)