Incorrect syntax near 10

[CRilliterate]

Hi, I am having a problem creating a view from someone elses script


Select A_S_P * 10 as [RT QTY]
*
*
*
Group By A_S_P * 10

It gives me Incorrect syntax near 10

Anything you can see right away that I am missing?

________________________________________
I am using Windows XP, Crystal Reports 9.0 with SQL Server

 

[vongrunt]

What is behind * * * ?

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[SQLDenis]

works for me

create table #test (id int)
insert into #test values (1)
insert into #test values (1)
insert into #test values (2)
insert into #test values (2)
insert into #test values (3)

select id * 10 from #test
group by id * 10

select id * 10 from #test
group by id

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[bborissov]

I am not sure that you can add Field*10 in GROUP BY clause, try:

Select A_S_P * 10 as [RT QTY]
*
*
*
Group By [RT QTY], other fields.

Borislav Borissov

 

[bborissov]

Stupid suggestion. Sorry for that.
I must go to sleep now

Borislav Borissov