bob I do not think that

select PictureName

From Pictures

group by PictureName

order by newid()

Will work See sushilla's last post. 

if object_ID('Tempdb..Pic') >0

 drop table Pic

Create table Pic

(

 PictureId int identity(1,1),

 PictureName varchar(50)

)

insert into Pic Values('Dog1'

insert...

Bob how do you know that camel 1 and camel 2 are dups. Is it possible to have a camel 1 and a camel 2 that are not dups.

Mike

Remi if You had a body like her's you would look well a little strange. Ask one of the guys at work to...

Jay check books on line under the image data type. This should get you started. If you are still having problems post your DDLs, inset statements and the maximum size...

I have to admit much to my dismay I have been pursing an honest dollar, a new contract in a different time zone is driving me nuts and costing...

You guys are mirror images of each other?

Have you checked the value of @signupID to see what is being passed to the sp?

Mike

Nabeel would you please post your DDL for your tables and the code for the Sp. Thanks

Mike

Ray have you tried computing the date outside of the query

select * from openquery(sbase_live-link,'select * from jobs where date_booked > '5/5/2005' order by date_booked desc ')

Mike

Helloooooooo Steve you live on a farm well maybe a ranch but that is real close to a farm.

Hey its only money. I never wanted to be rich, I just want a little more than I can spend.

Mike

 there is no other way to rearrange the column selection except by explicitly selecting them in the order you want!

Sushilla sure there is ...

Frederick Herzberg proposed a 2 part motivation theory back in the 1960's. He contended that pay was not a motivator. But that it could be a de-motivator. If a person...

Don't forget, most of these guys aren't the founders, or the owners. They're hired managers.

I think that this point can not be overstated. There was an article on HP...

Silence I forgot she was driving. but the walk did me good