We’ll need better definitions.

What can you tell us about the source table? Can you provide DDL and DML?

“Send to Report Builder” – do you mean populate another table...

michael.petrone (9/1/2014)

---

1. Start of with a blank temp table.

2. Select

3. Check Temp Table - SSN not in temp table send to Report Builder 3.0 ELSE insert into temp table.

4....

;WITH SampleData AS (

SELECT MyString = 'ABC DEF 210 ' UNION ALL

SELECT 'ggh / sah ggh 590' UNION ALL

SELECT 'ggh / sah gghXPT' UNION ALL

SELECT 'ggh...

Guitar_player (9/1/2014)

---

Hi ,

I have column which are having data as Alphabets and also Numbers like to say

ID Column1

1 ABCD 123

2...

joseph.robinson83 (8/29/2014)

---

Wow, thanks Chris! I can't believe I forgot to N' the string. That single oversight fixed the entire routine.

Good information to know on the CHAR/Unicode/ASCII differences. I've never had...

Solved:

DECLARE @Pattern NVARCHAR(MAX)

DECLARE @sSQL NVARCHAR(MAX)

DECLARE @1 nvarchar(max)

DECLARE @2 nvarchar(max)

DECLARE @loop int

SET @Pattern = '%['

SET @Pattern = @Pattern + NCHAR(0) + NCHAR(1) + NCHAR(2) + NCHAR(3) + NCHAR(4) +...

Have you tried using an SC collation? There's info here. Your ? might be the first of a surrogate pair.

jonatan.carlberg (8/29/2014)

---

Hi again!

Thank you all for welcoming me to the forum. As you probably see, I've posted a clarification on my previous post.

Thanks for all input so far.

From what...

-- create sample data

DROP TABLE #ChartOfAccount

CREATE TABLE #ChartOfAccount (Account INT, [Description] VARCHAR(30), Parent INT)

INSERT INTO #ChartOfAccount (Account, [Description], Parent)

SELECT 1, 'ASSETS', 0 UNION ALL

SELECT 101, 'CURRENT ASSETS', 1 UNION ALL

SELECT...

LHendren (8/28/2014)

---

Thanks to both of you. All three solutions work for my query.

Taking this a step further, what if I do not want to see the jNMBR and sNMBR...

-- Prepare some sample data to code against

DROP TABLE #Sample

CREATE TABLE #Sample (

ID INT,

[Customer name] VARCHAR(20),

[Customer address] VARCHAR(20),

[Something] INT,

[Product number] INT,

[Product name] VARCHAR(20),

Quantity VARCHAR(20),

Price...

Two other commonly-used methods:

SELECT jNMBR, sNMBR

FROM #myTable

WHERE cDate IS NOT NULL

GROUP BY jNMBR, sNMBR

SELECT jNMBR, sNMBR

FROM (

SELECT jNMBR, sNMBR, rn = ROW_NUMBER() OVER(PARTITION BY jNMBR, sNMBR ORDER BY (SELECT...

Lynn Pettis (8/28/2014)

---

ChrisM@Work (8/28/2014)

---

Welsh Corgi (8/28/2014)

---

ChrisM@Work (8/28/2014)

---

Welsh Corgi (8/28/2014)

---

The example that I provided is not actually what I need. I want the Insert columns to be all from the Oracle...

Welsh Corgi (8/28/2014)

---

ChrisM@Work (8/28/2014)

---

Welsh Corgi (8/28/2014)

---

The example that I provided is not actually what I need. I want the Insert columns to be all from the Oracle Table.

Any ideas would...

Lots of options for this:

;WITH PrimaryDiagList AS (SELECT * FROM (VALUES

('402.01'),('402.11'),('402.91'),('404.01'),('404.03'),('404.11'),('404.13'),('404.91'),('404.93'),('428.0'),('428.10'),('428.20'),

('428.21'),('428.22'),('428.23'),('428.30'),('428.31'),('428.32'),('428.33'),('428.40'),('428.41'),('428.42'),('428.43'),('428.90')

) d (diagnosis))

SELECT t.*

FROM dbo.TEST t

INNER JOIN PrimaryDiagList p

ON p.diagnosis = t.diagnosis

WHERE t.DiagnosisSeqID = '1'

AND EXISTS (

SELECT...