As a programmer from wayback - 1982 to be precise - I have seen everything come around go away and come back again, with a lick of paint; a new...

Thanks for your help John, I've decided to leave Table Valued Functions until they change somewhat as the limitations for what we want to achieve are too restrictive!

I'll stick to...

Hi John

Thanks for replying. Sadly it doesn't work, I am trying to link the...

Sadly I'd have to burn precious money and lots of it to get off this island, but I'm thinking of you all enviously - my swag collection is nearly depleted...

As a developer I want a stable platform to work off.

Most MS customers don't necessarily understand what goes in to a service pack or update - especially those that...

Modified the original SP sp_Fkeys added two new fields, For_Replication and Constraint_Active. Hope this helps someone.

set nocount on

DECLARE @pktable_name ...

Thanks for the post.

I think however that I've found the answer in sysconstraints status field. The Higher bits have the useful nuggets that MS was not telling us about.

So...

OK having re read I realise I've answered the wrong question...

I have a table with several transactions and i want to count # of transactions at each hour

StartTime, EndTime, Transaction_UserID,...

Hi Mike,

Theres a snippet of code in the scripts section that counts lines of code if there is a primary key.

SELECT so.name, CurrentCount = coalesce(si.rows,'N/A')

...

OK If I read this right you are after the highest date from one of two columns column in a linked table.

max(c.scj_eend) END_DATE

from ins_stu a , srs_scj c, srs_cbo b

where...

With age and income all the small gadgets and useful gizmos have been bought (and ebayed as you realise that you really don't have a use for a juicer/breadmaker/can opener/electric...

I've done both. Generally I try to stop posting inflammatory emails until I've tried to understand the intended meaning but sometimes even carefully crafted emails can be misconstrued with the...

Thanks for the replies. It makes sense - I was hoping there was an all encompassing solution that would allow this within SQL, but this will work going forwards. 

Would you suggest dropping all existing foreign key constraints in order to maintain referential integrity for this situation? I had tried using a mixed approach but as entities and contacts...

All the best...is it a big (round numbered) celebration?

10 years for us this year...