Database

String inputValue;
String sqlText;
SqlConnection connection;
SqlCommand command;
SqlDataReader dataReader;

inputValue="123ABC";
sqlText="SELECT dbo.show("  + inputValue +")";
connection=new SqlConnection(" ...whatever your connection stuff is ");

try
{
   connection.Open();
   command=new SqlCommand(sqlText,connection);
   SqlDataReader dataReader = command.ExecuteReader(); 
  
   if(dataReader != null)
   {
      while(dataReader.Read())
      {
         --get values from dataReader
      }
   }
}
catch
{

}

if exists (select * from MyDatabase.dbo.sysobjects where id = object_id(N'[MyDatabase].[dbo].[WL_HEADU]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [MyDatabase].[dbo].[WL_HEADU]
GO

drop table [MyDatabase].[dbo].[WL_HEADU]
GO

select * from MyDatabase.dbo.sysobjects where id = object_id(N'[MyDatabase].[dbo].[WL_HEADU]') and OBJECTPROPERTY(id, N'IsUserTable') = 1

USE [MyDatabase]
GO

Jun Du wrote:

create a table on the master databse:

select empcode, basicSalary, ISNULL(Bonus,0) as Bonus, ISNULL(Transport,0) as Transport
from 
(SELECT s.empcode, s.basicSalary,  a.description, a.amount
	FROM salary s 
	LEFT JOIN additions a 
	ON s.empcode=a.empcode ) AS SalaryWithAdditions
PIVOT(
	SUM(amount)
	FOR description IN ([Bonus],[Transport])
) AS PivotTable

empcode	basicSalary	Bonus	Transport
160	3000	        180	25
170	4000	        0	0

begin 

declare @max_date datetime

set @max_date = (select max(creation_date) from fsformula)

print @max_date

end

SELECT TOP 1 @dtLatestDate=dtDateTime, @fltLatestPrice =fltPrice FROM Customers ORDER BY dtDateTime DESC
SELECT TOP 1 @dtEarliestDate =dtDateTime, @fltEarliestPrice=fltPrice FROM Customers ORDER BY dtDateTime ASC

WHERE RF.REPAIR_ORD = RH.REPAIR_ORD and Rp.REPAIR_ORD = cg.REPAIR_ORD

SELECT .....

FROM 
  RF INNER JOIN RH
  ON RF.REPAIR_ORD=RH.REPAIR_ORD
  
  INNER JOIN RP
  ON RH.REPAIR_ORD=RP.REPAIR_ORD

  INNER JOIN CG
  ON RP.REPAIR_ORD=CG.REPAIRD_ORD

WHERE ....