1st Question, is tMSSqlRow the best way to use SQL Statements with varibles? I've googled around for a few tutorials and they all use tMSSqlRow.
2nd Question, How do I print the output of tMSSqlRow? I usually use tMSSqlInput -> tLogRow When I use tMSSqlRow -> tLogRow I just get 1 row of 0|||| I tried using tParseRecordSet but I get an error, Cannot cast from Long to Result set. I don't quite understand "Prev.Comp.Column List"
This component does not provide the selected records itself. You have to map the resultset in the advanced settings to a schema column of Object type and use this column in the component tParseRecordSet. This components opens the resultset and starts a flow with the actual result data. The mapping it is schema columns to the columns of the result set fields have to be done with the names of the result set columns. It is be far to tricky to process queries this way.
You can use variables everywhere - tMMSSQLRow, tMSSQLInput, tMap and etc - proper component depends from Your tasks
2nd - are You Sync columns in tLogRow component?
Use tLogRow (or any other prints) for print output flow in Studio - is bad idea for big data-sets, use it carefully for debug purpose only and disable (delete) from live). It could freeze Studio (in worst case crash it). If You have more than few output rows - redirect them in file (tFileOutputDelimited for example)
