Thanks Paul,

Do you have an example of thing that would work on the other servers and not PRODUCTION?

This way I can go to boss and try and explain this to...

Sorry Mark,

I didn't realise it need to greater than 5 as opposed to greater than or equal too :hehe:

Hi Mark,

You solution seems to be missing some of the results.

Here is a solution that seems to work, but I have a feeling that with a large data set this...

Hi Gila,

I'm South African, but not currently in SA, would I be of any help to your 🙂

Thanks

Chris

Hi there,

Is the difference between:

01/10/2008 01:00

AND

01/10/2008 01:17

Not also 5mins?

Also check this link out for tips on getting the best out of your posts:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

HI there,

Could you please show us what you want your out put to look like?

Sorry but I got last by...

HI There,

How Many rows is this gonna be updating?

Also is this table being used alot by other uses? (cause locks)

Last but not least do you have an execution plan...

What do you mean you can't find?

What happens when you set up a connection using the same user as you used in your SSMS connection window, and run "SELECT *...

Can you do a simple select from this table using your c# connection?

Also can you do a simple selecting in SSMS?

thanks

Chris

HI there,

Does you c# connection have permissions to this new table?

Also what is the select statement you wrote ?

thanks

Chris

That looks good.

Prob a good idea to also do some testing with different examples with different times that are greater, less and equal to your getdate value.

You could also use the DEFAULT reserved word in SQL this will force it to use the default value as well

HI There,

Could you show us what you have so far.

HINT:

This is going to require a where clause with the GETDATE() function in it

Thanks for that Brandi,

In BIBS when I run my Package execusion task to run one of my packages it gives this error

[Execute SQL Task] Error: Failed to acquire connection "DestinationConnectionOLEDB"....