SQL Bahubali's please help

[4Vikram]

19 minutes ago, jbourne said:

Ankul Akkada 29.5 yrs industry 

saala ?

[The Warrior]

Endo mayya interstellar and inception kalisi chusunattunfi

[Srimantudu]

1 hour ago, 4Vikram said:

saala ?

30.5 kada..ee year add cheyaledani feeling aa

[mettastar]

Insert into bbc select col1, col2, rownum() over(order by col1) as id, 'Somehardcode' x from ABC; 

Nuvvu ey db no cheppaledu but above should work in most of the dbs.

[mettastar]

Ignore my reply motham chadavaledu

[4Vikram]

1 minute ago, mettastar said:

Insert into bbc select col1, col2, rownum() over(order by col1) as id, 'Somehardcode' x from ABC; 

Nuvvu ey db no cheppaledu but above should work in most of the dbs.

    DECLARE @TEMP table (ID int IDENTITY (1,1), [DEVICE_TAG_NUMBER] NVARCHAR(50), [SCADA_DESCRIPTION] NVARCHAR(MAX))

    INSERT INTO @TEMP 
    ( 
        [DEVICE_TAG_NUMBER]
        ,[SCADA_DESCRIPTION]
    )

    select TOP 1 [DEVICE_TAG_NUMBER]
            ,[SCADA_DESCRIPTION]
    from [dbo].[STG_GPL_122_TEST_DATE_Temp]

    DECLARE @ID BIGINT
    DECLARE @EQUIPMENT_NAME VARCHAR(200)
    DECLARE @SAP_FUNC_LOC_CD VARCHAR(100)
    DECLARE @RECORD_CREATED_BY VARCHAR(100)
    DECLARE @RECORD_CREATED_DATE DATETIME2 (7)
    DECLARE @DEVICE_TAG_NUMBER VARCHAR(50)
    DECLARE    @SCADA_DESCRIPTION VARCHAR(MAX)

    SET @EQUIPMENT_NAME = '122-UploadedEquipment'
    SET @SAP_FUNC_LOC_CD = '122-UploadedSAPFunc'
    SET @RECORD_CREATED_BY = 'minums1'
    SET @RECORD_CREATED_DATE = GETDATE()

    while exists (select * from @TEMP)
    begin

       select top 1 @ID = ID,
                    @DEVICE_TAG_NUMBER = DEVICE_TAG_NUMBER,
                    @SCADA_DESCRIPTION = SCADA_DESCRIPTION
       from @TEMP
       order by ID asc

       -- Do something with your TableID
       
       EXEC [dbo].[usp_APP_ADD_EQUIPMENT_AND_MAP_SITE_CAT]  

       PRINT @ID

       delete @TEMP
       where ID = @ID

    end

    --drop table @TEMP;

[4Vikram]

Just now, mettastar said:

Ignore my reply motham chadavaledu

ignored and post mine.. now the twist in my query is i have to cal one sp for which i dont know the parameters and I am waiting for feedback from my manager,. as they have to go  through a particular category and i dont know which category it should so waiting..

[Bhai]

17 minutes ago, 4Vikram said:

ignored and post mine.. now the twist in my query is i have to cal one sp for which i dont know the parameters and I am waiting for feedback from my manager,. as they have to go  through a particular category and i dont know which category it should so waiting..

k

[Bhai]

55 minutes ago, mekapichal_mnthmkora said: