Recent content by psychoflea

Thanks Markros, thats spot on what I was looking for! :) Just out of interest this was my final code Select Max(ProductNo) as ProductNo, Min(Date) as StartDate, Max(Date) as EndDate, Max(Price) as Price from ( SELECT TOP (100) PERCENT ROW_NUMBER() OVER(PARTITION BY [ProductNo],Price ORDER...

Hi, i'm trying to find the start date & end date for a range of like data for example Turn this: ProductNo Date Price 12345 10/7/10 £1.50 12345 11/7/10 £1.50 12345 12/7/10 £1.50 12345 13/7/10 £2.30 12345 14/7/10 £2.30 12345 15/7/10 £1.50 12345...

Thanks for your responses. I thought that might be the answer that I was going to get. The email side of it is already coded in the application (Access Front Linked to SQL DB), but its causing complications when it tries to interact with Outlook (which is upsetting the users) so i'm getting...

Hi It there a way that I can send an email when multiple records are inserted to a table? Basically multiple record are inserted into a table and rather than bombard the users with emails for each record I was wondering if I could send a batch of inserts in a single email. All the record...

Hi I have only just started using Crystal Reports XI after using version 10 for the last 3 years. I'm having problems when creating a Date parameter of getting it to set the default value to the currentdate. (In version 10 if you left the default value blank it would automatically default to...

Hi all Bit of a basic question, but I have multiple trigger that I want to create to different table in one statement. Example CREATE TRIGGER rateaud ON [dbo].[exrate] FOR INSERT,UPDATE AS Begin ........ End CREATE TRIGGER forcastaudit ON [dbo].[forecast] FOR UPDATE AS begin ......... End...

I'm writing a Javascript slotmachine and was have become a bit stuck. I have 3 reels that display 4 images, I want to compare the images and if they match add a value to total amount won, but I am unsure how to do this correctly function spinem() { turns1=10+Math.floor((Math.random() * 10))...

Yes your right, it was very sloppy of me. Sorry. Thank you for all your help, I have done what you suggested and used 1 class to create the 4 objects Thanks again

I'm working on a traffic light system where users can input a time delay between light changes. The system is for 4 sets of lights each using its own thread process. I can start the threads but can't seem to get them to stop. the code is a bit rough at the mo Any ideas would be very...

Hi Is there such a way that you can use an IF Statement within an UPDATE Statement. Such as: UPDATE Table 1 IF col1>= 500 SET col1 = col1*2.5 ELSE SET col1 = col1*1.5 Thanks

Thanks Prosper I've changed the program a little bit more using your code for the ActionListener. The problem i'm haveing now is trying to figure out how to get the running total for the score working If anyone has any thoughts source code: import java.applet.Applet; import java.awt.*...

Thanks for reading (more of a personal question than a professional one) I have just starting to use java and wanted to start writing a simple "Who wants to be a millionaire" java game. Using the few texbooks that I have i've managed to write a small part of the program, but I can't...