Database

Luc Pattyn wrote:

can you get the identity without an SP

CREATE TABLE [IDTest](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[TextData] [varchar](50) NULL)

DECLARE @SQL VARCHAR(1000)

SET @SQL = 'INSERT IDTest (TextData)VALUES(''Test1'');SELECT @@IDENTITY as ID'

EXEC (@SQL)

DROP TABLE IDTest

DECLARE @MainQuery as NVARCHAR(MAX)
DECLARE @GROUPBY as NVARCHAR(MAX)
SET @MainQuery = 'SELECT ItemCode, ItemName FROM OITM '
IF 1 = 1
 SET @GROUPBY = 'GROUP BY ItemCode, ItemName'
ELSE
 SET @GROUPBY = 'GROUP BY ItemCode, ItemName'

SET @MainQuery = @MainQuery + @GROUPBY

EXEC(@MainQuery)

Johan Hakkesteegt wrote:

IF 1 = 1
 SET @GROUPBY = 'GROUP BY ItemCode, ItemName'
ELSE
 SET @GROUPBY = 'GROUP BY ItemCode, ItemName'

IF @num = 2
  SET @GROUPBY = 'GROUP BY (b.bl_no, b.laden_date,b.container_code,b.shipper_name,b.consignee_name,c.status,b.qty)'
ELSE
  SET @GROUPBY = 'GROUP BY (b.bl_no, b.laden_date,b.container_code,b.shipper_name,b.consignee_name)'

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