The only way to process the result set from a dynamic select statement that I know of, is to create a temp table, and then execute

insert into #temptable select (your...

Come on, I hadn't a clue until Nicolas' last post I am not an expert - yesterday I couldn't find out how to...

No, it wasn't obvious to me

Now that I have been around here for a while I understand why loops should be avoided -...

Could it be that tempdb has a different collation than the db in which you execute your code?

I have no idea, but maybe someone else...

Basically the same problem has been discussed in this thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=205972

Do you want authors with zips between 93000 and 94500 to appear last in your select? Then try something like

SELECT au_id,au_fname,zip FROM authors

order by

case when zip <= 93000 then 0 when...

My guess:

The first select returns a datetime. '2005-08-02 00:00:00.000' is simply the way the query analyzer displays this date. The second select, however, makes an implicit conversion (before you apply...

Use "edit post" and noone will ever notice

You have a datetime and apply a string function to it - that's probably why. I am sure there is a simpler solution, but I am not sure what you...

Sure, try something like

select 1 as seq

union all

select 0

order by seq

If this doesn't help, please post more details.

Oh, Remi is back from vacation

Now that I have spent some time figuring it out , I might...

I doesn't compile, @Valor is undefined

I think I will also need some sample data in order to reconstruct the error

I haven't got a clue what is wrong - but a good start is to be able to reconstruct the error

So much for...

There seems to be four input parameters... Could you post a definition that I can copy and paste into my qa ( a "create function" statement), please