Something like this perhaps...

-- your data

DECLARE @Report1 TABLE (contract varchar(20), A int, E int, N int, P int);

INSERT @Report1

SELECT 'Income', 5000, 6000, 8000, 4000 UNION

SELECT 'Costs', 4000, 7000,...

If you can use CLRs you could look at mdq.regexmatches. See this thread.

opc.three (8/19/2013)

---

Here is a non-cursor option, just for the sake of having an alternative to using a cursor:

DECLARE @sql NVARCHAR(MAX) = N'';

SELECT @sql += 'EXEC LoadFile ' + QUOTENAME(FILENAME, '''')...

Thanks Luis!

-- (1) Source Data

DECLARE @nbrs TABLE (n int primary key);

INSERT @nbrs VALUES (10),(20),(30),(40),(50);

-- (2) Solution

WITH

s1 AS (SELECT ROW_NUMBER() OVER (ORDER BY n) AS rn,n FROM @nbrs),

s2 AS (SELECT rn-1...

First, I second both responses to your question. I actually have a couple versions of SQL server installed on my machine: 2008R2 Developer Edition & SQL Server 2012 Express. Developer...

I have run into the exact same type of thing...

This is the cause of my receding hairline. :hehe:

the source data is coming from a database in the UK and the values sometimes contain non alpha-numeric characters. i'm probably wrong, but i'm wondering if some of these characters...

Shot in the dark here but, are you using a case sensitive collation?

learning_sql (8/13/2013)

---

Ha, it literally said "Reporting Services does not support CROSS APPLY".

However I have just been playing around and when just typing the query it worked every time, I have...

Nice. That is cleaner and easier to read.

+1

First, welcome to SSC!

If I understand your question correctly you have some VB code that accepts parameters, builds a query based on those parameters then sends that query (ad...

We will be planning to migrate sql 2005 and sql 2008R2 on new windows 2008R2 server, we have one Replicated DB which ones we are subscribing and we don't have...

Instead of the case statement you can also do this:

SELECT ISNULL(thing1.name,(ISNULL(thing2.name,thing3.name))) AS name

First, check out the Stairway to SQL Server Replication[/url] by Sebastian Meine.

I am going to set up replication in an OTLP environment. I would like to know what as...