I like the FizzBuzz puzzle.

I use it to identify if an applicant

- prefers using a set or loop based method where both methods are possible

- knows enough T-SQL to...

I surrender.

Please copy the code I posted and run it as it is. Without any modification. Neither renaming columns nor anything else.

What result do you get?

I've seen the expected output before.

But what rules do apply?

Are the values of indexnumber identical to adbid or how are those values calculated? What does the value in...

I can't really offer any other solution since the one I posted works just fine for me (= returning the expected result).

One reason...

I'm wondering why this needs to be a T-SQL task.

In a decent normalized database structure there shouldn't be a column with a comma separated list and esepcially not the need...

I can't spot the difference of the two queries. Both seem to be identical.

And why do you return columns in the subquery that aren't used in the outer query at...

Please describe how the input data need to be separated to return the result set you're looking for. Even though we could figure most of it by reverse-engineer your undocumented...

May I kindly ask you again to include the Sortorder column in the output of your select statement?

I know you can't post your real data. But when troubleshooting it really...

What is the Sortorder column based on? Can you add it to your output to see what values are in that column?

Just guessing here but the order might be exactly...

Is the issue resolved or do you still get unordered results?

I can't see any ORDER BY in your query...

bcp "select 'Col1', 'Col2', 'Col3','Date' union all select top 15 cast(Col1 as varchar(25)) as Col1,Col2,Col3,cast(DATE as varchar(25))as DATE from TABLENAME where SortOrder<>0...

Can you post the bcp statement you're using?

You might want to have a look at Erlands blog for several options.

Do you have an ORDER BY in the SELECT statement used in the BCP command?

As long as there's no specific ORDER BY in a statemewnt, the order of returned rows...