Monthly Archives: September 2017

Clone programming steps

Posted on September 15, 2017 by pfb_admin

— 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

Posted on September 13, 2017 by pfb_admin

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

Posted on September 8, 2017 by pfb_admin

programmingScriptText += “\r\n”; //Windows style CRLF line ending. //programmingScriptText += “\n\r”; // Nobody does this. //programmingScriptText += With more blood flowing in and less flowing out, levitra generika Facts about levitra generika the arteries in the penis enlarge, resulting in … Continue reading →

Posted in C#, Programming | Leave a comment