ansaurus

Question

Answer 1

+3 A:

I would write it

declare @avg float
select @avg=avg(rating) from videorating where videoid = 4

Michael Todd 2010-02-02 05:20:30

+1: Beat me to it

OMG Ponies 2010-02-02 05:21:28

(Which is bloody amazing...you're like the king of SQL. And fast.)

Michael Todd 2010-02-02 05:23:25

thank you Mr.Michael Todd

Surya sasidhar 2010-02-02 05:25:34

Not a problem. Glad I could help.

Michael Todd 2010-02-02 05:25:52

@Michael Todd: Quassnoi's faster - even his wife says so ;) :D

OMG Ponies 2010-02-02 05:36:46

Answer 2

A:

Yes. You can

bkm 2010-02-02 05:22:50

thank you Mr. bkm thank you for response

Surya sasidhar 2010-02-02 05:25:58

**No**. You can't. http://msdn.microsoft.com/en-us/library/ms189499.aspx

Michael Petrotta 2010-02-02 05:29:28

Why doesn't this select statement, setting a variable, work?