I got 7 and 8,8 on .. 2008(RTM) developers and enterprise edition ... I'm stumped too... can somebody please explain the reason behind this output ?

Initially, I thought of fetching the color names depending using substring() but thought it might take longer to write proper SUBSTRING() hence thought doing following way.. it might be easy...

Does this mean that you want count() of color in the second column and color name in the first? Also please provide create and insert statement for the sample data.

I wasn't satisfied with the code written below .. but it works :crazy:

SELECT T1.* FROM #TEMP T1 INNER JOIN (

SELECT DriverID,Fname,Lname FROM #TEMP WHERE Disposition = 'Guilty'

GROUP BY DriverID,Fname,Lname HAVING...

@Phil Parkin - Thank you !! for the SQL code tip.

Well I second you on performance

I guess because of QotD. I tried my hands on many of them recently.

Can you please give some additional details like file structure etc ? If possible please sample post the i/p file data and the output that you are expecting ...

I did not use join but was able to fetch the required output with following query...

CREATE TABLE #TEMP

(

DriverID INT, Fname VARCHAR(100),Lname VARCHAR(100),DOB VARCHAR(100), Disposition VARCHAR(100)

)

INSERT INTO #TEMP

SELECT 1, 'John','Doe', '19651025',...

Just a thought ...

why not use FQN (fully qualified name) to access function created in different database ?

How about creating SSIS template ? and using it while creating all the packages

I tried this for a table with VARCHAR and DECIMAL datatype. and came up with following ... not sure whether it will work for all the datatypes out there or...

I could be completely wrong here but are you sure you do not want result set in one column ? And want it to spread across multiple columns ? If...

Would it be ok for you to use recursive CTE ? ..something like

create table #Something

(

CityRank int,

Country varchar(10),

City varchar(200)

)

insert #Something

select 1, 'india', 'hyderabad, bangalore, delhi, shimla' union all

select 2, 'usa',...