Monthly Archives: September 2017

Clone programming steps

— list products that might need to be programmed. SELECT name,revision, product_id FROM qs_products where name like ‘277000-200-%’ — list current programming steps select p.name,p.revision,steps.* from [dbo].[ACA_swprg_programming_steps] steps INNER JOIN qs_products p ON p.product_id = steps.mes_product_id — after updating the … Continue reading

Posted in SQL Server | Leave a comment

Populate NULL component_ids from related tables

Needed to populate a new column in one table from a semi-related existing table, based on a value in another related table. I do this once in a blue moon and needed a refresher. Thanks, Pinal Dave, for your post … Continue reading

Posted in SQL Server | Leave a comment

List of line endings

programmingScriptText += “\r\n”; //Windows style CRLF line ending. //programmingScriptText += “\n\r”; // Nobody does this. //programmingScriptText += “\r”; // Max style (CR) line ending. //programmingScriptText += “\n”; //UNIX style (LF) line ending.

Posted in C#, Programming | Leave a comment