Database

create table #X
(
    C char(1)
)

insert into #X values ('A')
insert into #X values ('B')
insert into #X values ('C')


declare @z as varchar(2000)
set @z = ''


select @z = @z + C from #X


select @z

drop table #x

vamsimohan21 wrote:

Is it possible to call a web service from Stored Procedure (Sql Server 2000)

Mika Wendelius wrote:

xp_cmdshell

Dave Kreskowiak wrote:

Not recommended because this opens a high-risk security hole

Select A,B,C.... From Table1 ORDER BY H DESC

Select F,G,ORDER BY H DESC SUM(D), A,B,C From Table1 Group by A,B,C

select substring('MSantos@yahoo.com', 1, charindex('@', 'MSantos@yahoo.com') - 1)

SELECT COUNT(*), SUM(price)
FROM Orders o1
WHERE cust_id=3
AND 50 <= (select count(*) 
           from Orders o2
           where o2.cust_id = o1.cust_id
           and o2.date < o1.date)

Tony_P wrote:

Is subquerying the only solution

SELECT COUNT(*), SUM(price)
FROM (SELECT TOP 50 Price
      FROM   Orders
      WHERE cust_id=3
      ORDER BY date DESC) tableAlias

hatan86 wrote:

OleDbDataAdapter ad;

hatan86 wrote:

OleDbException was unhandled
Syntax error in INSERT INTO statement
I've checked it and I can't find any syntax errors in it