Creative Jar are pleased to present our Silverlight Labs - http://silverlight.creative-jar.com, this area of the CJ site feature and showcase our Silverlight development over the coming months... so watch this space!

Dont forget to see us at VBUG tonight - http://www.vbug.co.uk/Events/August-2008/VBUG-Bracknell-Creating-Silverlight-apps-using-Blend-and-VS08.aspx

WOW - MOSS meets Silverlight and one hell of a blog system, check out http://blogs.msdn.com/imm/

The future is here!

So the builders have been into the studio and taken out the wall in the Technical room, now Directors Billy and Al are taking out the remaining bricks where the wall used to be. Keep up the good work lads!

Hi All,

Some great tips and tricks for SQL for ya'll.

DISTINCT & GROUP BY

http://www.sqlteam.com/article/how-to-use-group-by-with-distinct-aggregates-and-derived-tables

INNER JOIN - REMOVING DUPLICATES

(Within the INNER JOIN you can get the TOP 1 of a unique field and then use this to only return 1 from the koop up table, in this case Field1 and Field 2 can contain different values and therefore a DISTINCT will NOT work)

SELECT
TABLENAME.requiredField,
LOOKUPTABLENAME.Field1,
LOOKUPTABLENAME.Field2,
FROM TABLENAME
INNER JOIN LOOKUPTABLENAME ON LOOKUPTABLENAME.uniqueField = (SELECT TOP 1 uniqueField FROM LOOKUPTABLENAME WHERE LOOKUPTABLENAME .requiredField= TABLENAME.requiredField)
ORDER BY TABLENAME.requiredField

DUPLICATES

Also deleting duplicates ROWS from a table (need to :

DELETE FROM T1
FROM TABLENAME T1, TABLENAME T2
WHERE T1.dupField = T2.dupField
AND T1.uniqueField > T2.uniqueField

Hope they come in handy!