Tag Archives: syntax

Using SQL to Mege Three Incomplete Data Sets

You can join data sets. LEFT JOIN, RIGHT JOIN, even OUTER APPLY. There’s nothing to learn here. Last week, I had what seemed to be a simple join of three data sets. My permutation was a lot more complicated than … Continue reading

Posted in MS SQL, Transact SQL | Tagged , , , , , , , | Leave a comment

Waitfor it

Suppose you are charged with system QA for a complicated system that expects dozens or hundreds of simultaneous users. The system has a user front end through either a browswer of through deployed software, and it sends transactions back and … Continue reading

Posted in MS SQL, Software QA/Testing, Transact SQL | Tagged , , , , , , , | Leave a comment

PHP Shortcut to Set Two Values at Once

I’ve been coding in php for seven years, and doing it professionally for four. Until today, I never knew you could use a syntax like this to set the value of more than one variable.

[/crayon] I’m not sure why … Continue reading

Posted in php, Web Apps | Tagged , | Leave a comment