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!

The CJ mascot appears to have gone walkabout this week! Oh well, let’s hope he makes an appearance next week.... 

 

Rob, Greg and Joe try out their skills at the Skate park... the MD thinks he can skate and some dodgy graffiti!  

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!

Nice MAGS!

http://dennis.cerosmedia.com/1U47b05537b4ad1806.cde

An interesting article about adding styles in .Net and JavaScript, although the code is in VB.Net you get the idea!

http://aspalliance.com/1546_Implementing_style_sheet_code_dynamically.1