Answered here

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=87226

I don't think anybody could have guessed what you meant from your original post.

Anyway, the problem is not in SQL.

Your front end progrm should add the surrounding quotes.

All partial payments don't have to have previous payments as thier parents.

All of their parents can be the original invoice.

You still should be able to get what you need.

INSERT INTO Local_ProgramMaster (Faculty, ProgramTitle, ProgramDate)

SELECT Faculty, ProgramTitle, ProgramDate

FROM ProgramMaster

WHERE (Condition here)

INSERT INTO ProgramScheduleDetail

SELECT

(

SELECT Z.ProgramMasterId

FROM Local_ProgramMaster

WHERE Z.Faculty = (SELECT Y.Faculty FROM ProgramMaster Y WHERE Y.ProgramMasterId = A.ProgramMasterId)

AND Z.ProgramTitle =...

You can get ProgramMasterId from Faculty + ProgramTitle.

I don't think you need to use cursor.

Does Faculty + ProgramTitle make a record unique?

and CalculateDistance?

I suspect your trigonometric functions in the above is causing the domain error.

You have to make sure that parameters are within the ranges allowed in functions.

Please post how CalculateDistanceByZip is coded.

By saying inner ROUND......., I was refering to [3], [15], [16] of the following:

SET @distance = ROUND((ACOS(ROUND(....., 3))) * 6378.135, 3)

SET @distance = ROUND((ACOS(ROUND(....., 15))) * 6378.135, 3)

SET @distance =...

With

SET @distance =

ROUND((ACOS(ROUND((SIN(@fromLatitude / 57.2958) * SIN(@toLatitude / 57.2958))

+ (COS(@fromLatitude / 57.2958) * COS(@toLatitude / 57.2958) * COS(@toLongitude/57.2958 - @fromLongitude / 57.2958)), [15]))) * 6378.135, 3)

you get 0, but with

SET...

I think your previous calculation was more accurate.

You can try increasing the digits of the inner ROUND function.

It is precision/rounding problem.

You can try

SET @distance =

ROUND((ACOS(ROUND((SIN(@fromLatitude / 57.2958) * SIN(@toLatitude / 57.2958))

+ (COS(@fromLatitude / 57.2958) * COS(@toLatitude / 57.2958) * COS(@toLongitude/57.2958 - @fromLongitude / 57.2958)), 3))) * 6378.135,...

What result do you expect from your query?

SELECT ACOS(1.0000000000000002) will raise a domain error.

Please post your code.