If you fall into the...

Server side cursors are less memory demanding for the client, but need an extra round trip to the server avery time you need to fetch a row. If you have...

HowardW (9/23/2011)

---

Hi Gianluca,

Have a question about this code:

IF @localTran = 1 AND XACT_STATE() = 1

ROLLBACK TRAN

Once you're in the catch block, wouldn't you want to roll back the...

This should help:

SELECT sc.name AS schema_name,

dbp.name AS owning_database_principal_name,

srp.name AS owning_server_principal_name

FROM sys.schemas AS sc

INNER JOIN sys.database_principals AS dbp

ON sc.principal_id = dbp.principal_id

INNER JOIN sys.server_principals AS srp

ON srp.sid = dbp.sid

You can use my stored procedure code template[/url] if you like it.

It should do what you ask for.

Regards

Gianluca

You're not giving enough information to get sensible advice.

First of all, give yourself a chance to get an answer and format the code you post. You can make it more...

I think it's a duplicate post to this one: http://www.sqlservercentral.com/Forums/FindPost1179871.aspx

Or are you asking a different question?

I don't think I understand your question.

If the stored procedure accepts a float parameter, you will pass float values.

If you try to pass anything else, it will be converted explicitly...

Given that both queries return exactly one row, you have two options:

1) Use variables:

DECLARE @PreviousNAV decimal(21,6)

DECLARE @TodaysNAV decimal(21,6)

SELECT @PreviousNAV = ISNULL(@PreviousNAV,0) PreviousNAV

FROM Fireball..NAV

WHERE Date = @StartDate and PortfolioId = @PortfolioId

SELECT...

montyismobile (9/22/2011)

---

Hi Gianluca Sartori,

Thank you very much for your asistance with this, and so quickly too.

I must thank you for an elegant looking solution. I am looking forward to...

montyismobile (9/22/2011)

---

Silly question. Is there an easy way for me to copy this code as it is formatted? When I copy and paste from the windo it all...

OK, I think this should solve your issue:

PLEASE read the code and try to understand it. If you don't understand it, DON'T use it, come back here and ask for...

I'm sure there's a detailed installation guide shipped with SAP. Have you checked that?

As far as the db_creator role, in SSMS, expand security/logins, right click the user and select "properties"....

I'm sorry, I see that my reply is confusing.

I wanted to say that I have tried stopping/starting the...

I agree that this table should probably be re-designed.

However, you can achieve what you're after by using a trigger INSTEAD OF INSERT, that could turn INSERTs into UPSERTs using the...