Database

saneng wrote:

7/1612 = 0.004342431761.............

6/1397 = 0.0042949176807.................

above examples shows the division of 2 smallints giving a floating pt. result. but in our case I m getting the result column as 0.0 only for all values.

y is this happening, y isn't it considering the whole result or atleast it should give 3 to 4 values after decimal.

CREATE PROCEDURE SplitInsert 
@cNameCountry varchar(500)
AS

declare @nLocNameStart int
declare @nLocComma int
declare @nLocDelim int
declare @cName varchar(100)
declare @cCountry varchar(100)

select @nLocNameStart = 1

while (@nLocNameStart<len(@cNameCountry))
begin
	select @nLocDelim = CHARINDEX('$&',@cNameCountry,@nLocNameStart + 1 )
	select @nLocComma = CHARINDEX(',',@cNameCountry,@nLocNameStart + 1 ) + 1

	if (@nLocDelim=0)
	  	select @nLocDelim = len(@cNameCountry) + 1
	
	select @cName = ltrim(SUBSTRING(@cNameCountry,@nLocNameStart,@nLocComma-@nLocNameStart-1))
	select @cCountry = ltrim(SUBSTRING(@cNameCountry,@nLocComma,@nLocDelim-@nLocComma))

	insert into tblNameCountry (Name,Country) values (@cName,@cCountry)

	select @nLocNameStart = @nLocDelim + 2
end
GO

AnhTin wrote:

thanks u verry much but @cNameCountry varchar(500)
when u assgin cNameCountry is varchar or nvarchar have only character (4000) but when
larger 4000 only type TEXT or NTEXT but will have error "The text, ntext, and image data types are invalid for local variables."

AnhTin wrote:

And Your Example have while (@nLocNameStartbegin is error Syntax can u see again