Do you need more help or you're ok with the code I sent??

Let's hear it .

BTW, from what I read it seems you are using the worst approach possible... but I don't know for sure.

Well if don't want real help, here's the solution you requested :

IF Object_id('ListTableColumns') > 0

DROP FUNCTION ListTableColumns

GO

CREATE FUNCTION dbo.ListTableColumns (@TableID as int)

RETURNS varchar(8000)

AS

BEGIN

Declare @Items as varchar(8000)

SET @Items = ''

SELECT

@Items...

That'd be a nice syntaxe : @SomeVar = oppsWTFIsItNull(@SomeVar, 0)

.

500K, how long does it take to run that???

I agree with the integrity... but I wouldn't want to try to insert all those records in a batch!!!

What????!! Can you tell us which problem you are trying to solve with this technic??

Actually, it's see his opinion again... but it'd be nice to see his answers on those points.

Can you elaborate on that one??

100k at once?????

Can't this be done OFF hours. How is the app generating 100K images at once?

Can you show us some sample data along with the expected results... There's not enough information to give an accurate answer.

Here's a guess but I doubt it's gonna do what...

Don't use functions on a column, check this out :

Select * from dbo.MyTable where DateCol between @StartDate and @EndDate

Just calculte those variables using the dateadd functions (or from the...

Do you guys think this thread will hit 100 messages?? I think it would be a first .

You just need to replace the having count(*) = X to order by count(*) desc and select the top X suppliers, then let the application decide which one to pick...

As he says .