sdh96 (12/1/2014)

---

I am emailing data using this:

DECLARE @xml NVARCHAR(MAX)

DECLARE @body NVARCHAR(MAX)

USE R4W_001

SET @xml = CAST(( SELECT ITEM_ID AS 'td','',"td/@align" = 'right', replace(convert(varchar,convert(Money, AVAILABLE),1),'.00','') AS 'td','',

...

Eirikur Eiriksson (11/24/2014)

---

Quick note (for completeness), the inner query returns an XML, the value() method is invoked on that XML

😎

(inner query returning XML).value() <--the value method on the XML data...

Thanks for the link. That is a lot of information.:-)

-- Found my answer in the link: "The period is used to designate that the element value to return is...

scott.foss (11/20/2014)

---

I am new to sql server so I appreciate all help i can get in this matter.

what I want in a successful report by linking three databases:

DB1.id, DB1.data2,...

nomen (11/19/2014)

---

In SSMS, I used the ALTER TABLE statement to add a field to a table. No errors are generated and I can verify that the field has been...

sharonsql2013 (11/18/2014)

---

I am trying a case statement but get the error : "Conversion failed when converting the varchar value 'No Data Available' to data type int."

Case statement is

Case when...

If there is a large number...

Fool

You are using @MemberIds like a variable not a table.

I would suggest turning your parameter into a table inside the sp. That way multiples will work.

bpowers (11/11/2014)

---

What would be the best approach to just return the characters after the last special character (-) in a string?

Example:

ReportServer-SalesOrders

ReportServer-OKLA-SalesOrders

I only want to return "SalesOrders". Any help will be...

China

Ed Wagner (11/6/2014)

---

SQLRNNR (11/6/2014)

---

Make My Day,...

In the Tools\Options\Text Editor\Transact-SQL\Tabs see what the tab size is.

Look in your text editor and see what it thinks a tab is.

It most likely is a tab size problem.