Hi,

Thanks for this. It hasn't actually solved the fluctuation in performance across the servers which is very confusing, but this works efficiently and is handled exactly the same on...

Tally table create script taken from Jeffs tally table article....Thanks Jeff!

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Dbo].[Tally]') AND type in (N'U'))

DROP TABLE [Dbo].[Tally]

GO

/****** Object: Table...

Thanks very much for this. I will work through this to see if it does what i need. I have a feeling that this will only deal with one to...

This will be potentially a nightly run that will update the customer details. This table will then have the various passes ran against it to identify changes in the relationships...

Hi Chris,

Thanks for taking the time to respond.

I am indeed trying to dedupe a customer list so that i can have a master customer that is linked to...

Impressive jeff, thanks for this.

I knew you would be able to do this with a CTE, but i have not quite managed to get my head around them yet....

Excellent. no problem 😀

I have added a flag and put a default on it of "0" which means you only need to put a value into it if you want it to be...

You will need to change the bits marked "--->>" so that it uses your table, and your column names. This will return the records as specified.

Let me know if it...

HI,

If you can let me know what you dont understand about the code that i posted then i am happy to try and explain it.

Thanks

.....ignore the bits in the comments that say "comma". they are meant to say "space". I have stolen this code from somewhere else and missed a few bits.

This will...

Hi,

I am sure that there are better / quicker and shorter ways of doing this, and ways that use only set based programming however i am not sure what...

Try this...

DECLARE @Sign_In datetime

DECLARE @Sign_Out datetime

DECLARE @WorkedHours DECIMAL(18,2)

DECLARE @hours varchar(30)

DECLARE @minutes varchar(2)

DECLARE @seconds varchar(30)

set @Sign_In = '2009-04-03 08:35:00.000'

set @Sign_Out = '2009-04-03 20:18:00.000'

set @seconds = abs(datediff(second, @Sign_In, @Sign_Out))

set @hours =...

I have just noticed that i have left the table in there that i was running this against. You will need to change the table back to the one that...

HI,

I am not entirely sure what you want unless you can provide some test data and a script to create the table however if you are just looking to...