SQL experts ki question

[Hakuna_Matata]

Day zero insert script.

ID, Number, Name, Desc

1, 5, xyz, Good

2, 2, abc, Average 

3, 1, dsa, poor

 

Desc column : if number between 4-5..Good                 

                         if number between 2-3..Average   

                         if number between 1-1.5...poor

ila oka 50 records ki script rayali...new table create chesyakunda oke table create chesi cheyadam ela.same table NUmber column paina Case statement work avatledu.

..please help

 

 

 

[Chinna84]

Try this:

Insert into Table_A

(Select id,

Case

when (number >= 1 && number <= 1.5) then 'Poor'

when (number >= 2 && number <= 3) then 'Average '

when (number >= 4 && number <= 5) then 'Good'

End as Number,

Name

from tbl_b

Order by number desc);

[Biskot2]

if not

write a on_insert_trigger ,  

than write a case statement in trigger 

[Hakuna_Matata]

8 hours ago, Chinna84 said:

Try this:

Insert into Table_A

(Select id,

Case

when (number >= 1 && number <= 1.5) then 'Poor'

when (number >= 2 && number <= 3) then 'Average '

when (number >= 4 && number <= 5) then 'Good'

End as Number,

Name

from tbl_b

Order by number desc);

From another table kakunda edaina way unda ba..from tbl_b ante first ippudu tbl_b create cheyali

[Hakuna_Matata]

5 hours ago, Biskot2 said:

if not

write a on_insert_trigger ,  

than write a case statement in trigger 

on_insert_trigger  eppudu use cheyale ba..try chestha

[Biskot2]

25 minutes ago, Hakuna_Matata said:

on_insert_trigger  eppudu use cheyale ba..try chestha

first create tabel with DESCOLUMN allow nulls nvarchar(50) and than create a on insert trigger on your table. 

 

USE [DBNAME]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER TRIGGER [dbo].[trig_TABLENAME_INSERT_TRIGGER]
ON [dbo].[TABLENAME]
FOR INSERT
AS
BEGIN

      DECLARE   @Id                                  INT

                          ,@Number                       FLOAT

                        ,@Desccolumnname       NVARCHAR(50)

        SET @Number = (SELECT i.Number FROM inserted i)

        SET @Id = (SELECT i.ID FROM inserted i)

                SET @Desccolumnname  = CASE

                                                                  WHEN (@Number>= 1 && @Number<= 1.5) THEN     'Poor'

                                                                   WHEN (@Number>= 2 && @Number<= 3) THEN         'Average '

                                                                   WHEN  (@Number>= 4 && @Number<= 5) THEN        'Good'

                  End

         UPDATE [dbo].[TABLENAME] SET DESCOLUMN = @Desccolumnname  where ID = @Id 

END