Untested, but something like this would...

omlac (9/30/2011)

---

I have two tables like below, and

1. i would like to select all records and where customers have more than 1 Address return the Address with the Address Type...

DECLARE @XML XML

SET @XML = N'<ReturnMessage id="3655041356">

<AdC ocean="PACCGL">4815044</AdC>

<MessageStatus code="100" time="2011-09-26 01:43:20">status ok</MessageStatus>

<MessageData>700A20000018C0375494400000</MessageData>

<Flags les="0" app="0" />

</ReturnMessage>'

SELECT SUBSTRING(Original, 1, 1) + '-' + SUBSTRING(Original, 2, 2) + '-' + SUBSTRING(Original, 4, 2)...

I have no junk drawer. . . no, seriously.

I do have "junk scripts" on a file server though, loads of them that may or may not be useful 🙂

zwheeler (9/28/2011)

---

Hi

I am using the round function in my select statement and it works for the following

Round(avg(h.mtr_fass_score)) as mtr_fass, <------THIS WORKS

Round(avg(case when p.mtr_unit_count...

This may seem silly, but does this: -

SELECT 1

FROM master..syslogins

WHERE NAME = 'pos_reporting'

Return anything on the server where the ELSE statement is failing?

*groan*

--Some test data first

DECLARE @TABLE AS TABLE (tableText VARCHAR(1000))

INSERT INTO @TABLE

SELECT 'Some Product Name Here 3.7mmD X 8mmL (SBM)

Product Code: 103708

<span style="color:red;">Availability: 9/26/2011</span>'

UNION ALL SELECT 'Some Product Name Here 3.7mmD...

preetid2 (9/27/2011)

---

This is exactly what the end result should looks like!!

except i need to produce it dynamically. i looked at the articles, and i think Part2 (Cross tabs and pivot2-...

preetid2 (9/27/2011)

---

yes, i need to group by Measurement_Site_desc, and display Measurement_Date in columns for upto 5 dates.

the desired result should be something like this...

desired results...

Measurement_Site_desc ...

Chrissy321 (9/27/2011)

---

Correct, sorry about that. Revised

--5

INSERT INTO #Transactions (ItemID,StartDate,EndDate) VALUES (5,'1/1/2001',NULL)

INSERT INTO #Transactions (ItemID,StartDate,EndDate) VALUES (5,'1/1/2001','12/1/2002')

INSERT INTO #Transactions (ItemID,StartDate,EndDate) VALUES (5,'1/1/2003',NULL)

INSERT INTO #Transactions (ItemID,StartDate,EndDate) VALUES (5,'1/1/2003','9/1/2003')

INSERT INTO #Transactions (ItemID,StartDate,EndDate) VALUES...

preetid2 (9/27/2011)

---

sorry, i'm newbie and this is my first time posting my question.

anyway, i updated my original post, that has the flow of creating the sample table, test data, and...

Sorry Chrissy, it seems your thread was overlooked yesterday.

Chrissy321 (9/27/2011)

---

I guess I could go on the assumption that if the item appears on the list a number of times that...

abhishek_dwivedi03 (9/27/2011)

---

For one of my instance , management tools are not properly installed .Hence, management tools are not working propely .

The requirement is to create transactional backup job every 15...

Hello and welcome to SSC!

It seems that your DDL script seems to have become detached from your post, or perhaps you were unaware of the benefits of providing one.

When...