Alan.B (12/10/2014)

---

I'm curious (general question to everyone)...

Wouldn't this be faster?

-- the function

CREATE FUNCTION dbo.DIGITSONLYAB(@pstring varchar(8000))

RETURNS TABLE WITH SCHEMABINDING AS

RETURN SELECT ISALLDIGITS = CASE PATINDEX('%[^0-9]%',@pstring) WHEN 0 THEN 1...

You are absolutely right, CONCAT works without any conversion. So,...

You can, but in your case it will fail before getting there...

Cool links, thank you!

Guys,...

nto very clear what exactly you want to CAST or CONVERT, but lets assume it;'s a ROW_NUMBER...

CONCAT(PER.[PERSON-REF]

,CAST(ROW_NUMBER()...

select StudentID

,ClassId

,StartTime

,EndTime

...

pkjsh13 (10/7/2014)

---

Thanks Eugene, I think that explains it perfectly.

@Eirikur yes a join would have been more efficient but I was trying to understand this particular behavior and not focus on...

XML is not a code...

Looks like course work to me...

So, would you post whatever you alreday tried so far, and we will help you to learn other than give you straight answer which will...

That is very easy to explain, try:

select max(sal) as sal from b where id = 99999

over

select sal as sal from b where id = 99999

See the difference?

The first...

Untill you clearly and accurately specify what is your input sample and what is expected output based on that exact input sample, it is really hard to understand what you...

you can try:

DECLARE @sql NVARCHAR(MAX) = ''

CREATE TABLE #tResults (TableName VARCHAR(50))

SELECT @sql = @sql + 'INSERT #tResults SELECT ''' + st.name...

Herpington_McDerpington (10/7/2014)

---

Apologies for the lack of clarity folks.

In the simplest of terms I am trying to retrieve a list of tables, but only tables that meet a condition.

DB1 has 13,000...

serg-52 (10/7/2014)

---

Eugene Elutin (10/7/2014)

UPDATE t1 SET CustomerLink = 0

FROM @Tmp t1

JOIN @Tmp t2

ON ...

The problem with cross reference is that it leads to indefinite recurisvenes...

So, solution would be to resolve corss reference before going to recursive query.

I have added one more test...