Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

View creation error

Status
Not open for further replies.
CRilliterate

CRilliterate

Technical User
Dec 7, 2005
467
US
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
 
Sort by date Sort by votes
MS SQL Server or MySQL? If the former then you're in the wrong forum! If the latter, then can you show us the full query?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

David Higgs
  • Locked
  • Question
ERROR lower_case_table_names
Replies
0
Views
179
David Higgs
David Higgs
madcelt
  • Locked
  • Question
Select query not showing error but not showing result either
Replies
2
Views
145
madcelt
madcelt
Abeer60
  • Locked
  • Question
LAG error
Replies
1
Views
160
feherke
feherke
Arun Mahajan
  • Locked
  • Question
How to catch SQL Exception Error number in MySQL 5.6
Replies
0
Views
114
Arun Mahajan
Arun Mahajan
penguinspeaks
  • Locked
  • Question
Undeclared variable error 1
Replies
4
Views
378
Olaf Doschke
Olaf Doschke

Part and Inventory Search

Sponsor

Back
Top