Sql Experts Urgent Help

[SUbba LIngam]

corresht man...

 

 

ee DB lo emaina trigger lantidi pettaava, sql meeda thread padagaane ala vachestav

[nenu_devudni]

devudu adi work avadu ga, what if you don't have meter for that record and it does have only tamper... it won't pickup the second priority item man.... 

  aa record ki ochina anadam lo chusukoledu  .. nu chepindi correst bhayya .. ipudu em cheyali   bye1

[SUbba LIngam]

help 

 

[loveindia]

ee DB lo emaina trigger lantidi pettaava, sql meeda thread padagaane ala vachestav

 

I am admin mod noo man...

[loveindia]

  aa record ki ochina anadam lo chusukoledu  .. nu chepindi correst bhayya .. ipudu em cheyali   bye1

 

10 minutes wait chey man, tintunna, code raasi istaaa... 

[rikki]

[nenu_devudni]

10 minutes wait chey man, tintunna, code raasi istaaa...  thanks bhayya 

:)

[CheGuevara]

Let me chexk

[CheGuevara]

Try this

Sorry edi try chey vastadi

Try this

Select * from
(

SELECT UWTSMEE_PREM_CODE,
UWTSMEE_MODEL,
UWTSMEE_ASVC_CODE,
UWTSMEE_ALERT_TIME,
UWTSMEE_ALERT_TYPE,
UWTSMEE_ALERT_MSG,
CASE WHEN UWTSMEE_ALERT_TYPE = 'METER REMOVAL' THEN 1
WHEN UWTSMEE_ALERT_TYPE = 'TAMPER ALERT' And UWTSMEE_ALERT_TYPE != 'METER REMOVAL' THEN 1
WHEN UWTSMEE_ALERT_TYPE = 'REVERSE ENERGY' and (UWTSMEE_ALERT_TYPE != 'METER REMOVAL' and UWTSMEE_ALERT_TYPE != 'TAMPER REMOVAL' )THEN 1
ELSE 0
END AS ALERT_TYPE
FROM UWTSMEE
WHERE UWTSMEE_WORK_IND IS NULL
AND UWTSMEE_PREM_CODE = '1018385')
Where alert_type = 1;

Might not be optimal one but give a try

[loveindia]

Try this

sorry edi try chey vastadi

Try this

Select * from
(

SELECT UWTSMEE_PREM_CODE,
UWTSMEE_MODEL,
UWTSMEE_ASVC_CODE,
UWTSMEE_ALERT_TIME,
UWTSMEE_ALERT_TYPE,
UWTSMEE_ALERT_MSG,
CASE WHEN UWTSMEE_ALERT_TYPE = 'METER REMOVAL' THEN 1
WHEN UWTSMEE_ALERT_TYPE = 'TAMPER ALERT' And UWTSMEE_ALERT_TYPE != 'METER REMOVAL' THEN 1
WHEN UWTSMEE_ALERT_TYPE = 'REVERSE ENERGY' and (UWTSMEE_ALERT_TYPE != 'METER REMOVAL' and UWTSMEE_ALERT_TYPE != 'TAMPER REMOVAL' )THEN 1
ELSE 0
END AS ALERT_TYPE
FROM UWTSMEE
WHERE UWTSMEE_WORK_IND IS NULL
AND UWTSMEE_PREM_CODE = '1018385')
Where alert_type = 1;

Might not be optimal one but give a try

 

annitiki one vastundi kada man ila raastey, you are not considering each individual record kada...

[loveindia]

DECLARE @Table TABLE
(minv_code INT,
alert_msg VARCHAR(10),
alert_time DATETIME
)
 
INSERT INTO @Table VALUES (873939,     'Reverse',          '7/24/2015 3:31:18'),
(873939,     'Tamper',           '7/24/2015 3:30:00')
,(873939,     'Meter',             '7/24/2015 3:31:22')
 
;WITH CTE AS
(
SELECT *
, CASE WHEN alert_msg = 'Meter' THEN 1
WHEN alert_msg = 'Tamper' THEN 2
WHEN alert_msg = 'Reverse' THEN 3 END AS id
FROM @table
)
, CTE2 AS (
 SELECT *, ROW_NUMBER() OVER (Partition by minv_code ORDER BY id) AS rnum
FROM CTE
)
SELECT minv_code, alert_msg, alert_time FROM CTE2
WHERE Rnum = 1

[loveindia]

enjoy man,

 

next time when you can help some one please do help man.... idi nuvvu cheppina daani prakaram and naaku ardam aina daani prakaram raasanu man and this is lest cost query too so it will performance good.... 

[nenu_devudni]

DECLARE @Table TABLE
(minv_code INT,
alert_msg VARCHAR(10),
alert_time DATETIME
)
 
INSERT INTO @Table VALUES (873939,     'Reverse',          '7/24/2015 3:31:18'),
(873939,     'Tamper',           '7/24/2015 3:30:00')
,(873939,     'Meter',             '7/24/2015 3:31:22')
 
;WITH CTE AS
(
SELECT *
, CASE WHEN alert_msg = 'Meter' THEN 1
WHEN alert_msg = 'Tamper' THEN 2
WHEN alert_msg = 'Reverse' THEN 3 END AS id
FROM @table
)
, CTE2 AS (
 SELECT *, ROW_NUMBER() OVER (Partition by minv_code ORDER BY id) AS rnum
FROM CTE
)
SELECT minv_code, alert_msg, alert_time FROM CTE2
WHERE Rnum = 1

insert enduku bhayya .. that data is already in the table  bye1

[loveindia]

insert enduku bhayya .. that data is already in the table  bye1

 

adi just sample data man, neeku ardam avadam kosam ala ichanu.... 

[Hitman]

insert enduku bhayya .. that data is already in the table  bye1

 

..nuvvu nijam gane devudivi bhayyo...  LoveIndia created a table and inserted data for get solution for you.. not that he is asking you to Insert.