The Weird and The Wonderful

Chris Kowalske wrote:

Seriously though, could you imagine trying to come up with 25,000 column headers?

jhwurmbach wrote:

Only Database-specialists would even think of something like that...

JazzJackRabbit wrote:

I truly feel sorry for any guy who has to deal with clients who can think up such idiocracy.

Dave Kreskowiak wrote:

The level of which is astounding, isn't it?? According to management, the customer is ALWAYS right! Yeah? BS!

Balboos wrote:

I've heard that some are contracting out the management, too.

JazzJackRabbit wrote:

truly feel sorry for any guy who has to deal with clients who can think up such idiocracy.

---

eggsovereasy wrote:

ALTER procedure [dbo].[ily_products_search_keyword]
(@sWhere varchar(2000) )
as
set nocount on
declare @sql varchar(8000)
select @sql = 'SELECT products.product_id,products.product_name,products.file_url, '
select @sql = @sql + 'products.print_url, products.product_desc '
select @sql = @sql + ' FROM products '
select @sql = @sql + ' WHERE products.active = 1 '
select @sql = @sql + @sWhere
select @sql = @sql + ' ORDER BY products.product_name '
exec(@sql)

exec [dbo].[ily_products_search_keyword] ' delete from products select * from products'

eggsovereasy wrote:

You need a ";--" at the end because of the order by

MarcR. wrote:

He is from c and c++ world...