hi,

How do you know that "6U7000000 443 IRA FBO Loelei C Dehart DecD W00001" is 1 row and not any other combination?

Try to add row_number to the query, the row...

Hi,

I don't sure that this will be faster but try this:

with RecursionCTE (item,Pre,parents)

as

(

select item,

...

I don't know the question, but 42 is the ultimate answer 🙂

Hi,

What PP-564103 meant when he said "those two columns should be in select clause!" is that the NEW columns should be in the select like this:

select ee_occup_levels, m, f

from (select...

Hi,

You can also use the cross tabs as in jefff grate articlae

http://www.sqlservercentral.com/articles/T-SQL/63681/

see also part 2

http://www.sqlservercentral.com/articles/Crosstab/65048/

Hi,

Did you try useing union?

SELECT '[option value="' + CONVERT(varchar(10),EVENT_TYPE_ID) + '"]' + TYPE_NAME + '[/option]' AS [CURRENT_SELECT]

FROM REF_EVENT_TYPE

WHERE EVENT_TYPE_ID = 1

union all

SELECT '[option value="' + CONVERT(varchar(10),EVENT_TYPE_ID) + '"]' + TYPE_NAME...

Hi,

Sorry for the late response, at my case the Allow InProcess was enabled on creation.

Hi,

Just cast\convert all the cols to same data type

DECLARE @t TABLE (col1 VARCHAR (10), col2 int, col3 CHAR (10))

INSERT INTO @t VALUES ('Value 1', 2, 'Value 3')

SELECT...

Looks like jedi is draw faster then cowboy 😉

oops, of course, my fault, just made the split my self and was confused :blush:

Hi,

take a look at this articles http://www.sqlservercentral.com/articles/XML/66932/

and

http://www.sqlservercentral.com/articles/T-SQL/62867/

🙁

Hi Martin,

As i posted here Problem with linked server,

I have problem with the linked server, it work fine but from time to time I get this error

"Cannot create an instance...

Jeffrey Williams (5/24/2009)

SELECT Customer.Name AS SortName,

vcltAttrib4_364.ainTVal AS Client_Relationship_Partner,

vFEAttrib4.attInstName AS Partner,

...

select a.*

from a left outer join on A.ref_no= b.ref_no

where b.ref_no is null