Could be that you had the wrong value in @p2, so the flow did not get inside the if statement.

Adi

I completely agree with free_mascot's answer, but just wanted to add few points. Fragmentation does some damage but most of it is for queries that have range scan...

Ectualy you don't need to name the columns in the select statement, so you can still use 2 replace statements and it will work. You can check the code...

I don't think that you need to work with a user defined function. Take a look at the code bellow. Is that what you need? Notice that...

Do you mean something like the query bellow?

select [Funding] [Fundings],

[Original] AS [Originals],

[Variance] = SUM([Previous_Year]-[Current_Year]),

[SumValue] = SUM([CurrentYear]/4),

[ActualValue] = SUM([Variance] * 0.75),

[FinanceYear],

[New Value] = SUM([Previous_Year]+[Current_Year])

from Finance

GROUP BY [Original],...

Personally I've never done that, but since version 2008 there is an option to work with autonomous transactions with linked servers. You can read more about it here –...

I can give you the start:-). The query bellow (I didn't write it, but I can't give the credit because I don't remember where I got it) shows...

I look at it from a different angle. If you need the ability to recover from a catastrophic error by recovering a database to a specific point of time,...

If you didn't have any trace during the time that it ran, I don't think that there is a way to get the session's ID nor any other detail about...

You can try and use the set context_info statement (but I have to admit that I'm not sure that this is what you are looking for). This statement gets...

I don't know Oracle so I might be wrong here, but if you are using windows authentication so each user is using his real login, you can use the functions...

You can't. According to microsoft ( http://technet.microsoft.com/en-us/library/ms143393.aspx%5B/URL%5D) if you upgrade enterprise edition, you can ugragde it only to enterprise or Business Intelligence editions.

Adi

I assume that you meant that the table should have many records with null value in this column, but the rest of the values should be unique. If I'm...

You didn't define how to join the 2 views. By the way I'm not sure that you should define a join. If all you want is to...

You can get the maximum (or minimum) ID per phone number from your table and then delete any record that its ID is not in those IDs.

Adi