I still prefer the CLR method personally 🙂

I quickly knocked up a simple date-validation C# CLR that should suffice. I realise you have your solution, just an offering for...

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...