while loop in sql query

-
select distinct rowid=IDENTITY(Int, 1,1),  buyorder.Chln into #temp from BuyOrder  inner join rChallan  on BuyOrder.Chln=rChallan.OrderNo
where BuyOrder.Qty=BuyOrder.sQty/2 and BuyOrder.sQty=rChallan.Qty

declare @challanID as varchar(50)
declare @num as int
set @num=1

while(@num<=(select MAX(rowid) from #temp))
begin

set @challanID=(select Chln  from #temp  where rowid=@num )
print @challanID

set @num=@num+1

end

drop table #temp

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