Jeff Moden (6/16/2008)

---

rbarryyoung (6/16/2008)

---

Jeff Moden (6/15/2008)

---

rbarryyoung (6/15/2008)

---

On the other hand, if your sheets need to be resized based on the number of rows returned, then automated "Get External Data" refreshes...

thanks, slava.

Ugh. How many times a week can we get the "String concatenation" question? We need some FAQ or permanent link that we can just send people to.

My understanding is that this is only do-able if it is the PRIMARY filegroup, and you restore it as the PRIMARY filegroup, that will have some obvious problems in your...

If "time" is an int also.

slava davidchuk (6/16/2008)

---

is there any other way to grant function exec permission for this specific user on the server level?

so it can be done once, and not for every...

I must be missing something, what is wrong with this?:

SELECT SUM(Case When R1.price between 0 and 50 Then 1 Else 0 End) as [£0 to £50]

...

santosh_devaki (6/16/2008)

---

Server: Msg 8117, Level 16, State 1, Procedure , Line 25

Operand data type numeric is invalid for modulo...

Thanks!

Thanks.

Tech_Newbie (6/16/2008)

---

Why? For the purpose of the application I am trying to build:

Those metrics for counting and selection of people are in compliance to regulations on how the process of...

Jeff Moden (6/15/2008)

---

rbarryyoung (6/15/2008)

---

On the other hand, if your sheets need to be resized based on the number of rows returned, then automated "Get External Data" refreshes can be pretty...

Great!

Zeev Kazhdan (6/13/2008)

---

Sorry, was too excited... here is the message:

Msg 6830, Level 16, State 1, Line 3

FOR XML AUTO could not find the table owning the following column 'Synopsis' to...

Actually, I would like "non-persistent scalar expression aliasing" also, in the same way that WITH (CTE's) is Table/Set expression aliasing.