oh im sorry i think i misunderstood the point. When you said this "the second highest bid that is not the same user " the same user means the person who is actually log in the system?

Ok cool to know.

try this

SELECT TOP 1 idCustomerBid, idProduct, bidAmount, bidDate
FROM bidHistory
WHERE (idProduct = 272) AND (idCustomerBid <> 2) AND (idCustomerBid NOT IN
...

well that is true @table does not have a structure to handle the insert. I guess you are using temporary tables which you can reference like this

create table #TABLE(
employeeid varchar(10),...

hi carobee try this

DECLARE @SqlQuery NVARCHAR(4000);
set @SqlQuery='You query here'
INSERT into @table
exec(@SqlQuery)


regards

Why dont you include the parameters in the select statement something like

string st = "select user, pass from loggin where user = '"+txtbox1.text+"' and pass = '"+txtbox2.text+"'";
//Then pass...

Good excellent thanks.

Hi, i once have that problem and i use this function and it work for me.

http://geekswithblogs.net/AngelEyes/archive/2007/04/12/111504.aspx

Hi,
SELECT A.AID, B.BID, A.ANAME, B.BDESC FROM A INNER JOIN B ON A.AID = B.AID
Hope that help regards.

try this

select ( select f.cycle as col1
from final as f
for xml raw, elements, type).query('for $col1 in (row/col1) return concat($col1, " ")')

I did not test this.

Regards.