GilaMonster (8/11/2015)

---

SQLRNNR (8/11/2015)

---

I wrote, rewrote and...

nadersam (8/11/2015)

---

It will return success also, there are 3 different characters they don't have to follow each other.

I was able to write the attached function but it doesn't work if...

Grant Fritchey (8/11/2015)

---

GilaMonster (8/11/2015)

---

It's a side effect of the dissertation, my supervisor and I distilled the 160 page dissertation down into 10 pages...

What should the results be for a string like "XaYdZol"

Here, the matching characters are all there, and in order, but they...

In that case, I suggest getting the book in...

Use a differential...

Without information of exactly what you're attempting, I'm guessing that you're selecting data from one table to insert into a second table (the archive table). Based upon the message "Text...

Welsh Corgi (8/7/2015)

---

I'm getting an operand type clash. Text is incompatible with int when attempting to archive table.

I tried finding a solution but I have not found one.

The table has...

How are you setting @StartRow? It looks like it's not being set properly then.

serg-52 (8/7/2015)

---

COUNT(*) OVER (PARTITION BY docnome

...

For the sample data that you just provided, and including the "Very Low" status, this query:

DECLARE @IssueData TABLE

(

IssueID INT,

IssueTypeID INT,

Value INT

)

INSERT INTO @IssueData VALUES (1, 1, 19), (1,3,1), (1,4,2), (2,2,...

ilovedata (8/6/2015)

---

I am sorry Wayne, I gave you the wrong output values.

SELECT 1 AS IssueID, 'Very Low' AS IssueStatus

UNION ALL

SELECT 1, 'Low'

UNION ALL

SELECT 1, 'Medium'

UNION ALL

SELECT 1, 'High'

UNION ALL

SELECT 1,...

luissantos (8/6/2015)

---

Hello comunity

I need to build a query that can return only documents where the field "u_DIM4" for the same document have more than one different value:

my script are this...

How does this work?

WITH cte AS

(

SELECT d.IssueID,

s.IssueTypeID,

s.IssueTitle,

...

Let me work on this a bit and see what I can come up with.