Team - I have a table with 2 fields
Table Name: RunQuery
ReportID - nvarchar(max)
Formula - nvarchar(max)
123 | Select '123' as Customer, '111' as Org' from Table1
123 | Select '133' as Customer, '121' as Org' from Table1
What I need to do is..,
Lets say Count(Formula) from table "RunQuery" = 70
I need to insert into TableOutput(ReportID, Customer, Org) for every value in Formula cell as its a sql query.
Loop is what i need i guess.., Any sample query would be very helpful.