Create temp table and insert into in store procedure

-
DECLARE @singleDuplicateData TABLE (
ID NVARCHAR(50),
StyleID NVARCHAR(50),
CLID NVARCHAR(50),
FileName NVARCHAR(550),
FilePath NVARCHAR(550)
)
INSERT INTO @singleDuplicateData
        (
          StyleID ,
          CLID ,
          FileName,
 FilePath
        )

select top 1 StyleID,CLID,FileName,FilePath  from #temptblFiles  t  WHERE t.CLID=@CL AND t.StyleID=@Style

Comments

Post a Comment

Popular posts from this blog

How to use DbFunctions.TruncateTime

-
var activeSchedulers = (from scheduler in DbContext.Scheduler                                                     where scheduler.isActive == "A"                                                     && DbFunctions.TruncateTime(scheduler.Date) == DbFunctions.TruncateTime(DateTime.Now)                                                     select scheduler).ToList();
Read more

Provision AWS EC2 Instance and RDS with Terraform, and Deploy Spring Boot App to EC2 Instance via GitHub Action Pipeline

-
Image
  These days, Terraform is a popular tool for managing infrastructure as code. Manually creating AWS EC2 instances and deploying Spring Boot applications to them can be challenging. In this tutorial, I will demonstrate how to use Terraform to provision an AWS EC2 instance and an AWS RDS MySQL database, and then deploy a Spring Boot project to that EC2 instance using a GitHub Action pipeline. Prerequisites: To follow this tutorial, you need to have the following prerequisites: An AWS account Terraform installed on your local machine. GitHub Account A Spring Boot Project Putty What We will do : Create AWS EC2 & RDS(MYSQL) Instance using Terraform Deploy Spring Boot Project in that EC2 Instance Using GitHub Action Create AWS EC2 & RDS(MYSQL) Instance using Terraform: Step 1: Create and Configure an AWS Free Tier Account AWS offers a free tier account with a 12-month free offer that allows you to use most of its resources for educational purposes. To get started on AWS, you fi...
Read more

Microsoft Access Connectivity from C#

-
<configuration>   <appSettings>     <add key="ConnectionString" value="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=BCI.accdb;" />     <add key="ClientSettingsProvider.ServiceUri" value="" />   </appSettings> </configuration> http://aksadur.blogspot.com/2013/01/microsoft-access-connectivity-from-c.html
Read more