I presented at Data relay and was on a panel interview at SQL in the summit . A guy from Apress approached me out of the blue. (you know the...

Unexpected gifts from nowhere... I now have a second "Ice Breaker/Litmus Test" question for interviews. No need to pile on folks.  I'm just a little gob-smacked that someone...

Jeff -it  needed to be said, but we are f1 AND web search rolled into one......

have you been hanging out with Joe again ? or are you not taking your...

My guess is that you are going to hit some collation issues along the way - unless everything is done in Binary collation.

the Chinese one in particular might hurt you

it may be because of the implicit date conversion.

try the following - but change the convert(date to be the same datatype as the corresponding start/end_date field

ALTER...

ok - I took both suggestions on board

ALTER TABLE tblPOS_Digital_Output__RunFor7Days___DataProduced ADD groupset AS (
CONCAT(master_id, company_code, FileLocation_FileBeginsWith, despatch_group
     , convert(char(8), isnull(despatch_group_start_date, '19000101'), 112)
 ...

3 words that nearly...

one of the things i'm constantly told,... keep it to 2 pages

This is something I'm going to...

Lynn

I was thinking that if you show them that if you contribute to the community then you get the Rockstar job. lord alone, look at Grant, he gets...

Lynn

I was thinking that if you show them that if you contribute to the community then you get the Rockstar job. lord alone, look at Grant, he gets flown around...

it would be nice to get a thankyou occasionally though. 🙂  I think off the top of my head I see about 10 users who do most of the "heavy...

Position a Column in an Index.

are you talking about choosing the order of columns in an index?

Just to be a contrarian, I'm...

Grant is correct, if you put your database into 3rd normal form you will have to join. In my honest opinion getting 3nf is the most important part of getting...