Hugo Kornelis (4/30/2013)

---

Sean Lange (4/30/2013)

---

I don't think I follow you here Tom. The condition checks is @ToCreate = 1. It does not equal 1 because it is NULL. Therefore the...

It is very unclear what you are trying to do but your update statements are full of logic errors. Let's look at them one at a time.

UPDATE [dbo].[TEST2]

SET Event_Role...

L' Eomot Inversé (4/30/2013)

---

Nice fun question, clear explanation, back to basics of variable declarations.

Of course MS have got the documentation wrong yet again - this is another one of those....

From your very vague post I am not even sure what the question is. Is it divide by 0? Is it the syntax error? Is it something else? We can't...

Duplicate post. Direct all replies here. http://www.sqlservercentral.com/Forums/Topic1447754-17-1.aspx

danawexler (4/29/2013)

---

thank you both Lynn and Sean - I appreciate your patience.

below is a more detail - i wanted to try to keep it simple but apparently i over-simplified the...

/vent on

No offense to your friend but has he been living under a rock for the last 10 -20 years? Using ad hoc queries directly in an application is awful....

Lynn is absolutely correct that in order to give any solid advice we need a lot more details to work with. However, maybe I can give you a nudge that...

apat (4/29/2013)

---

We recently migrated our database from SQL 2005 to SQL 2008 R2. Application is performing pretty fast and as expected. However when any queries are called from linked servers...

Jason-1080732 (4/29/2013)

---

I have a web site running with asp_net personalization for some web parts on the page. I am wondering if it is possible to take the pagesettings from...

baseehkhan (4/29/2013)

---

Hi all,

When i try to add the '+@pDatabase+'.dbo. with the tablename in line 98,99,100 AM getting error like Msg 103,Msg 102,Msg 105...

In my case tempdb had plenty of room and there was no logon trigger. I suspect that for...

Actually I have run into this in the past. We had a DB setup with restricted growth on the...

Eddie Wuerch (4/27/2013)

---

This is pretty much what the NTILE() windowed function is for - equally dividing a results set into x number of pieces. Unlike throwing calculations at the min...

carsten.crystaldive (4/27/2013)

---

... I played around with it now (sober), but I can't get it to work ... the problem seems to be somewhat to be the Calculation and with that...