Hardy21 (6/30/2014)

---

kapil_kk (6/30/2014)

---

Hi all,

I have a scenario in which I need to capture count of rows returned by execution of stored procedure.

I new we can do it declaring OUTPUT parameter...

only SELECT

is that are SQL functions?

you can try using table valued parameter for this...

Please check you table structure if any identity property applied on id column

For that you need to use ON DELETE CASCADE

what if I...

ok...

do we have any alternative other than trigger....

yes I have unique contraint , nonclusted index exists on tables might be they are causing this issue....

But I dont have any idea that can we disable uniquest constraint or...

after omiting varbinary column from SELECT list, you will stil get the clustered index scan only.....

you need to use SUM aggregate function with group by on CustNum column....

HI Daniel,

I think you are not clear what Gail is asking.

what he is saying that for other than 'Team1' do you have non numeric data in the table....if that exists...

Hi all,

can anyone please tell me how can I get hte value from

<contentRecords locale="en_US">

as value en_US

heya, I am able to find the problem...

Just change the query to this and it will work:

select X.value('contentId[1]','varchar(1000)') as ContentId,

X.value('content[1]', 'varchar(2000)') as Content

FROM XMLwithOpenXML A

CROSS APPLY A.XMLdata.nodes('/Internationalization/contentRecords/contentRecord') as N(X)

You can use CTE if you dont want to use subquery...