Facing the issue generating the data from MSSQL

Question

I have uploaded a bulk record from front end in c# ok Then am loading the record in temp table using table type ok I have used if exisits condition from based on the if exisit condition if the record is valid it will update the master else it will insert into the table unmatched records. So i need unmatched records of the table and this table am trying to export in excel in c# . When i execute the procedure its working but export to excel no record found. If possible plz provide solution for the same. Export to excel method is working but from sql server the records are getting generate.

Nilesh Shah · Answer

Let me clarify my understanding: you want to either insert or update records in SQL server then you want to export newly inserted records in Excel. If that's what you want then I suggest following approach: - pass records to an SP - in the SP write logic to either insert or update the records - you will need to create an extra column of Guid in table create a new Guid (only 1 Guid same for all records) and while inserting records pass this Guid in the new column - return this Guid from SP to C# code (or whatever code which is calling SP) - now the code needs to fetch all records which has that Guid - write code to fetch records with that Guid and export to excel

Nilesh Shah · Answer

can't help you if you dont post code

Maahi · Answer

No i want invalid records in excel.. i think multiple select stamtent due to its not able to get the select * from tablename