Thank your For Your replies
The order in which you specify the variables in the insert statement is incorrect. You have
[Latitude],
[Longitude],
[Type],
[CreatedBy],
[CreatedDate],
[ModifiedBy],
[ModifiedDate]
)
@Latitude,
@Longitude,
@CreatedBy,
GETDATE(),
@ModifiedBy,
GETDATE()
)
It should be
[Latitude],
[Longitude],
[CreatedBy],
[CreatedDate],
[ModifiedBy],
[ModifiedDate]
)
@Latitude,
@Longitude,
@CreatedBy,
GETDATE(),
@ModifiedBy,
GETDATE()
)
The [type]
is in the wrong place.