I have a problem with my stored proc, it seems to be executing twice, even though the function is only called once from anywhere in my app.
I have two stored procedures that talk to say TABLE 1 and TABLE 2.
TABLE1 works find, no problems at all.
TABLE2 seems to execute twice and every record is duplicated
The only difference between the two tables is that my Primary Key in TABLE 2 i have set to bigint with isIdentity set to true - so bascially, its auto incrementing.
Apart from that there is no difference, so how could it execute twice?
PS. Stored procedures are CLR procedures