Hello, can anyone say how to join two tables without having no common fields in the both tables.
I tried below given links but there is a error, initially it executes successfully but later on it shows too many lines :
Msg 217, Level 16, State 1, Procedure Pro_Combine_Dept_Location, Line 25
Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32)
and the links are
1. Click here
both links executes success starting but after that it shows compiled with errors.
I need the output like that please help me.