Database

IF n_count > 1
   	THEN
		v_juriscode   := 'LODESTAR';		
	ELSE
          IF n_count = 1
          THEN
            SELECT pm.dejuriscode
                INTO v_juriscode   
                FROM pwrline.lsmdphysicalmeter pm
                WHERE pm.decommdevid = V_COMMDEVID;
          END IF;
	END IF;

	IF v_juriscode IS NOT NULL THEN  
	UPDATE DEBADGERPROGLOG SET JURISCODE=v_juriscode 
                WHERE UIDBADGERPROGLOG = V_UID;
        END IF;

lionelcyril wrote:

When the condition c_count = 0 is encountered I have not set the value for juriscode (ie i hv not mentioned that condition).

I have noticed that when no value is set to the v_juriscode variable the table row is not updated, I wanted to know why this happens.

HOST_NAME()

APP_NAME()

yousefshokati wrote:

I do not know even this is about normalization or not?

yousefshokati wrote:

Give me the solution

Bastard Programmer from Hell

yousefshokati wrote:

Hi And tanks for your answer

yousefshokati wrote:

You say that When we design our database , we should design in a way that we do not have any closed path ?

Am I right?

yousefshokati wrote:

We have MembersTable Which represents the members of teams and we have TeamsTable That represents the Team Entity Now We have to relations between these 2 . The First relation is "Plays For" which means that "Member Plays for team A for example " and the second is "Captain Of" which stands for "Members x is captain of team A" . Now if we update one of these FK s that are in tables for creating the relationships then we will get an error , won't be?

Bastard Programmer from Hell

CREATE PROCEDURE [dbo].[GetStudents] AS
SELECT
s.StudentId, s.FirstName,s.SurName,
( ((s.ObtMarks) / (s.TotalMarks)) * 100) AS PercentageValue

FROM Students s

GROUP BY
s.StudentId, s.FirstName,s.SurName

SELECT
s.StudentId, s.FirstName,s.SurName,
( 'Percentage - ' + ((s.ObtMarks) / (s.TotalMarks)) * 100) as 'Percentage'

SET NOCOUNT ON
-- Declaration
DECLARE @Employee TABLE(ID INT , EmpName  VARCHAR(40))
DECLARE @I INT, @Count INT, @Temp VARCHAR(50)

SET @I = 1
-- Data
INSERT INTO @Employee(ID,EmpName)
SELECT 123,'Prabu'
UNION ALL SELECT 234, 'Raja'
UNION ALL SELECT 236, 'Kartik'
UNION ALL SELECT 1234, 'Venkat'

-- TSQL Script
SELECT @Count=COUNT(*) FROM @Employee
PRINT '~~~~~~~~~~~~~~~~~'
PRINT 'Employee Details'
PRINT '~~~~~~~~~~~~~~~~~'
WHILE @I <= @Count
BEGIN
	WITH Emp AS 
	(
		SELECT row_number() OVER ( ORDER BY ID ) 'RowNum', ID, EmpName
		FROM  @Employee
	)
	SELECT  @Temp =CAST(ID AS VARCHAR) +' - '+EmpName 
	FROM Emp
	WHERE RowNum =@I
	PRINT @Temp
	SET	@I=@I+1
END
PRINT '~~~~~~~~~~~~~~~~~'
SET NOCOUNT OFF