CREATE PROCEDURE usp_ors 
                     @sqlquery VARCHAR(MAX)
AS BEGIN

SET NOCOUNT...

• This reply was modified 4 years, 4 months ago by  sathwik.em91.

I should have replied yesterday,but was busy.So I tried a while loop it works for querying data but the data insertion to temp table part fails.I am still working on...

table1 exists on 5 different servers and want to combine the result into 1 temp table.

Yes it is inserting results into the temp table.I need a dynamic way of handling all the individual select statements one by one,execute them and insert into temp table.

My bad I should be more clear on this part.

Table name is connectiondetails

Sno  and Sqlcommand are the columns

SNo sqlcommand
1   SELECT * FROM OPENROWSET('MSDASQL','Driver={MySQL ODBC 5.3...

• This reply was modified 4 years, 4 months ago by  sathwik.em91.

@jeff Sorry for the typo.Corrected it.

Phil,

It is set to Main.

Thanks

se

Here is the sample code.

DECLARE @var VARCHAR(100) ='CCLOGISTICS'

SELECT @var

,  CASE WHEN CHARINDEX(' ',@var)>0 THEN SUBSTRING(REPLACE(@var,' ',''),1,5) ELSE SUBSTRING(@var,1,5) END AS substringoutput

Let me know for further questions.

Sorry for earlier post
Do you need to group by ea.Asset Value??If not please remove it and run your code.

Thanks
SE

September 26, 2018 at 3:54 pm