As Lutz pointed it out, the problem is with the full stop not being present for some rows 🙂

{Edit: Sorry for the typo, it was Lutz not Lowell :-P}

Something like this?

DECLARE @Table TABLE

( Server VARCHAR(250), name VARCHAR(20) )

INSERT INTO @Table

VALUES ('w112','n1')

, ('w110','n2')

, ('radon1', 'n3')

, ('radon1b.abc.com', 'n4')

, ('radon1c.abc.com','n5')

, ('radon1d.abc.com','n6')

SELECT REVERSE( PARSENAME ( REVERSE( Server + '.')...

OK, here is another solution, which is primarily for sets with more than 3 columns. For 2 columns, the other solution will scale up well ( imho )

; WITH UnPivotData...

Try this:

DECLARE @TodaysDate DATETIME

SELECT @TodaysDate = DATEADD ( MM , DATEDIFF( MM , 0, GETDATE() ) ,6)

; WITH Calendar_Months ( N ) AS

(

...

3rd month from May is July and from April it is June?

So if today = 7-Apr-2011 (4/7/11) then the next entry should be 7-June-2011 ( 6/7/2011) ?? your examples show...

Something like this?

; WITH CTE AS

(

SELECT RN = ROW_NUMBER() OVER ( PARTITION BY Country , ( CHECKSUM( column1 + column2 ) + CHECKSUM( column2 + column1 ...

A slight variation from Wayne's Code:

; WITH Tens (N) AS

(

SELECT 1

UNION ALL SELECT 1

UNION ALL SELECT 1

UNION ALL SELECT 1

UNION ALL SELECT 1

UNION...

Friday afternoon, and going HOME ?? :w00t::-D

Dhruva25 (5/6/2011)

---

1.From the RM30101 (RM Transaction History Table) select the 6 most recent invoices (DOCNUMBR) based off of the date that they have been paid off (DINVPDOF) for each customer...

Surrendering, Master :w00t: 😛

😛

Fixed the code 🙂

Like this:

SELECT openorder

FROM @Table

WHERE

openorder =

( CASE WHEN @openorder > 1 THEN 1 ...

The elements in yous ColumnA is not following a pattern. This makes it impossible to write a parser for this. Will the number of elements in COlumnA vary (i see...

I know of a method that could actually get what you want, but i need bit help from your side to do that.. I need the table structure (as CREATE...