Hi ,

how do you mean doesn't work ?

Can you post the full query ?

Use GUID for a key only if you need the key to be globally unique.

The main disadvantage is the size (in terms of bytes) of a guid. ...

Only heard it once , but it was from a trainer on a vb .net course from one of the largest training companies in the uk.

Dont use stored procedures....

hi ,

no solution is particularly clean but this should do you

select table2.id,

coalesce(max(Case when table2.Value = 'V1' then 'Yes' end),'No'),

...

is your maximum column V5 or V9999

Other than building it in dynamic sql then no...

Hi Peso , i pretty much agree with you psuedo-code but your statement of..

Gets things a little circular 🙂

Maybe when i...

Hi Peso ,

I think you are being a little unfair..

checksumming the newid value is pretty safe due to the size (in terms of bytes) or the uniqueidentifier type. ...

Hi ,

Frustrating as it is,you really need to give better details as to exactly what is slow.

Try this link[/url] and then this link[/url], and see if that...

Sound like row concatenation

Try this link[/url]

Sadly its not just limited to SQL. When i started my professional life , software was a science. Now it seem like if you can program a VCR...

Thanks for the insight guys, its not easy this article writing is it 🙂

getdate() will return a consistant value within a statement. it doesent matter how long it take for the statement to execute.

edit : See here for more info http://sqlblog.com/blogs/andrew_kelly/archive/2008/03/01/when-a-function-is-indeed-a-constant.aspx

Hi Ian,

I would of taken in the 'other way' and had a view to union smaller tables( for compatability only until time permitted to do all the joins correctly). ...

Hi Ian,

I pretty much agree with your logic , im not sure what your question is though ?