ok thanks plz guide me as i have added new sp in database sp_getdata

now in model added function import..

then in return a collection of :: Entity of table right? or...

you mean to say... no need to convert syntax??

directly add these sql statement into stored procedure and use that sp??

Thank you so much

select dbo.GetConfigurationValue_GUID('Fireball', 'Fireball Persistence Source')

this returns:

5C72E9D7-90CB-462C-8D6F-F8AF4163A416

SELECT

Class.EntityType

FROM

dbo.MultiSourceTableClassMap TableClass

INNER JOIN

Fireball_MetaData.dbo.Class ON

Class.ClassId = TableClass.ClassId

WHERE

TableClass.TableName = 'Fireball.dbo.Bond'

this query giving me output : 2026ADB1-83FA-484A-AC95-2136AD94E638

I have taken @SourceId = 0 .

I'm not sure from where it is coming this parameter.

varbinary value yes... but i'm getting null value i dont know why 🙁

I got it ... thank you 😉

I tried yours 🙁 fail same error 🙁

where exactly change is needed ?

hmm alright but my use of WITH(NOLOCK) in delete block is correct or not?

OPPS 😛

@gila yes sir...

i knew that if i don't use NOLOCK i will definitely get a deadlock so for successful

execution i need to use NOLOCK

its a huge long store procedure depending upon conditions

i insert data , update data and delete data from tables..

what i have posted is just a sample code of SP.

but i'm...

many reports are accessing this stored procedure at the same time so TO AVOID DEADLOCK I'M USING THI 🙂

i.m just using this stored procedure for reporting purpose..

please let me know my usage is at right or not?