Create #Temp SQL Table

Permanently deleted user

August 23, 2017 14:36

While using the SQLQuery activity, is it not possible to use the following sql syntax to create a #temp sql table?

 

create table #Temp_Table

 

(

 

Station varchar(50),

 

Chemical varchar (200),

 

Results int,

 

Unit varchar(15),

 

Sample_Date datetime

 

)

 

insert into #Temp_Table

 

This workflow activity does not like the # syntax

 

Walter

 

 

0

• 

  Kevin Penner

  August 28, 2017 19:20

  Maybe give the SQL Non-Query activity a try.

   

  -Kevin

  0
• 

  Permanently deleted user

  August 29, 2017 04:51

  Hi Walter,

   

  You can create a table inside workflow designer instead of using SQL Query activity. That means create a variable as DataTable and initialize it. Then insert rows into it using "Add DataTable Row" activity or "Invoke Method" activity.

   

  Hope this helps you, please let me know shoud you require any clarifications.

   

  Regards,

   

  Mohammad Ashraf

  0

Please sign in to leave a comment.