Create #Temp SQL Table

Permanently deleted user

23 août 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

  28 août 2017 19:20

  Maybe give the SQL Non-Query activity a try.

   

  -Kevin

  0
• 

  Permanently deleted user

  29 août 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

Vous devez vous connecter pour laisser un commentaire.