ta.bu.shi.da.yu (12/30/2008)

---

If you store more than 8KB of varchars (for instance a varchar(6000) and a varchar(5000) on one table) then you won't get that error. Instead, SQL Server will store...

Jay,

It's a bit of a misnomer... all single quotes must be turned into 2 single quotes... not actual "double quotes". And, start posting the actual query you used and...

Heh... 2nd formula turned out way shorter than the original... I get lucky like that.

NULL's format is a whole lot...

Cool... I'll take a look. Thanks, Anzio.

Jay Sapani (12/30/2008)

---

SSChampion The Update Quries Are

1. Update MyTemp Set DbfFileName = '2005.Dbf' ,TrExchng = 51

2. Update MyTemp Set MyKey = Str(TrExchng,2) + TrValNo + TrPtyCod + TrCurDt + TrPrdCod

These...

Heh... thanks, JayDeep. Falls into the ol' "Must look eye" category.

Jeffrey meant that if you give room for a mistake to happen, it will happen. You shouldn't make VARCHAR any bigger than necessary or you stand a chance or...

NULL has the right idea... just missing one second per week in the code. Using NULL's same idea, this is missing no seconds during the week...

SELECT *

...

Um... any business conducted during that one second missing out of each week? 😉

What the heck... no table design needed... just store it all in one big ol' nasty EAV and call it a day... just think how easy indexing will be. :P;):hehe:

Let's have an instant replay on ol' helmut head spiking THAT ball... yep, there it is! A perfect 6 points, spiking the ball, and the ref didn't even call...

By the way... all that hooie about the view having to have explicit column names?... it's just that... hooie... a myth... a BOL error... That's IF the base tables...

It's gotta "touch" the index to find out what the partition is... and that's all it does... it doesn't actually seek any rows in table 1 but it get's listed...

Yep... I agree with all of that as being the biggest mistake. The easiest way to start thinking in the set based pardigm is to stop thinking about what...

Any bets on that? 😉