Database

SELECT Distinct b.bl_no,b.laden_date , b.container_code , b.shipper_name ,b.consignee_name,sum(b.qty) As FLQty 

Inner JOIN T2 on T1.F1=T2.F1 and T1.F2=T2.F2 and T1.F3=T2.F3

SELECT Field1, SUM(Field2) AS 'Total'
FROM Table1
WHERE Field1 > 0
GROUP BY Field1

UNION ALL

SELECT Field3, SUM(Field4) AS 'Total'
FROM Table2
WHERE Field5 < 1000
GROUP BY Field3

UNION ALL

SELECT Field1, SUM(Field6) AS 'Total'
FROM Table3
WHERE Field8 = 20
GROUP BY Field1

sudheesh kumar s wrote:

SQL Server does not exist or access denied.

josephong wrote:

select temp,result_time from mts300_results where nodeid=5 order by result_time like '%:00:%' desc limit 10;

select top 10 temp,result_time 
from mts300_results 
where nodeid=5 
and result_time like '%:00:%' 
order by result_time desc

case when  
(TABLE_A.Field_1 + TABLE_A.Field_2) = (TABLE_B.Field_1 + TABLE_B.Field_2) 
      then 'Match'
 else 'Unmatch' end

Select
C1,
C2,
C3,
C4,
case when  (C1 + C2) = (C3 + C4) then 'Match'
 else 'Unmatch' end as Result
From 
(

	Select 
	Row,
	Max(C1) as C1,
	Max(C2) as C2,
	Max(C3) as C3 ,
	Max(C4) as C4
	From 
	(
				Select 
				ROW_NUMBER() 
						OVER (ORDER BY TABLE_A.Field_1) AS Row,
				TABLE_A.Field_1  as C1
				,TABLE_A.Field_2  as C2
				,'0' as C3
				,'0' as C4
				From 
				TABLE_A

				Union ALL

				Select 
				ROW_NUMBER() 
						OVER (ORDER BY TABLE_B.Field_1) AS Row,
				'0'  as C1
				,'0' as C2
				,TABLE_B.Field_1  as C3
				,TABLE_B.Field_2  as C4
				From 
				TABLE_B
	  )
	  as OuterTable
	  group by Row
	  
) as FinalTable

select t1.field1,t1.field2,
	t2.field1,t2.field2,
	CASE
		WHEN t2.field1 IS NOT NULL THEN 'Match' 
		ELSE 'Unmatch' 
	END
FROM Table1 t1
LEFT JOIN table2 t2		
ON t1.field1=t2.field1 AND t1.field2=t2.field2

select t1.field1,t1.field2,
	t2.field1,t2.field2,
	CASE
		WHEN t1.field1=t2.field1 AND t1.field2=t2.field2 THEN 'Match' 
                ELSE 'Unmatch' 
        END
FROM Table1 t1
CROSS JOIN table2 t2	

protected void Button1_Click(object sender, EventArgs e)
    {
            SqlConnection con = new SqlConnection();
            con.ConnectionString =  ConfigurationManager.ConnectionStrings["AdNetConnectionString"].ToString();

            Session["CampaignName"]= TexBox1.Text.ToString();
            string sql;
            sql = "insert into AdCampaign (CampaignName)values( ' " + Session["CampaignName"] + " ');
            SqlCommand cmd = new SqlCommand(sql, con);
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
    }