nicholas.zhao (6/27/2014)

---

I installed SQL Server 2008 standard edition with service pack 1 on windows server 2008 std. But when I login to the Analysis Services by studio management, following error...

Isn't recipients a semi-colon deliminated list? Try: -

EXEC msdb.dbo.sp_send_dbmail

@profile_name...

subbubally (6/9/2014)

---

Hi,

Thanks for your reply. I wanted to have the FieldName ( value from the TEST table) as element name. I dont want this,

<FieldName FieldName="TierName" Visibity="0"...

You've not included what you've tried. How about this: -

SELECT FieldName AS 'FieldName/@FieldName',

isVisible AS 'FieldName/@Visibity',

...

From a real quick look, bearing in mind that I'm not a VB developer: -

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.Net

Imports System.IO

Imports System.Text

<System.AddIn.AddIn("ScriptMain", Version:="1.0", Publisher:="", Description:="")> _

<System.CLSCompliantAttribute(False)> _

Partial Public Class ScriptMain

...

I'd normally say "I'm a Computer Programmer, primarily working with databases and set-based mathematics". That normally kills the conversation dead so I don't have to come up with anything more...

Bear in mind that I don't think this is a good idea, but this should do what you want: -

DECLARE @id INT =1;

SELECT *

FROM @message m

WHERE EXISTS (SELECT ...

hoseam (4/10/2014)

---

Hi

I have this code below.

create table dbo.Test(Base_fee [numeric](9, 6) NULL)

insert into dbo.Test(Base_fee) values (444444444.666666)

when I run it I get Arithmetic overflow error. my data type is (9, 6) So...

Bob Cullen-434885 (2/24/2014)

---

OK. I got it wrong, and now I know why I got it wrong. What I cannot understand is why it behaves like that in the first place!...

So I understood the intent of the question and got it correct, but bear in mind that on a case-sensitive collation you'd get the "Invalid column name 'CategoryId'." error.

Could you use Powershell? It'll make this task a lot easier.

In fact, here's a script that someone made earlier --> http://www.sqlservercentral.com/scripts/SQL+Powershell+Script/101648/%5B/url%5D.

sharonsql2013 (2/13/2014)

---

I am using CAST to convert into decimal and find the percentage, but it rounds the value to the nearest int.

I want to see the exact(2) decimal value...

Here...

Steve Jones - SSC Editor (1/31/2014)

---

If you know how the API is broken, what about an article here? Write this up, don't mention the company, or use their API, but...

Nadrek (1/30/2014)

---

May I recommend a CHECK constraint on the column(s) that prevent any data except letters and maybe spaces, perhaps numbers if you have to? If you have to...

Jeff Moden (1/29/2014)

---

Understood. That's the bummer about these things. No responsibility on the part of our own companies nor the 3rd parties and we get left holding the...