Exception in SQL server 'Incorrect syntax near '.'. '?

Question

Create Proc Proc_Name
as begin
  SELECT 1111 AS sno,'--ALL--' AS RS.branch
  UNION 
  SELECT Rs.Sno,(RS.branch+'-'+RT.[Type] ) AS branch 
  FROM K_RT_MasterRetailStores Rs 
  INNER JOIN K_RT_RetailType RT ON RT.sno=RS.[Type] 
  ORDER BY Rs.Branch 
end

I am getting Incorrect syntax error near '.'. in SQL server. I am not able to find out my mistake. Please guide me.

Msg 102, Level 15, State 1, Procedure K_RT_GetRetailBranch, Line 16 Incorrect syntax near '.'. Its not working getting same exeception — santhosha
– santhosha, Commented Dec 21, 2013 at 9:27

Mitch Wheat · Accepted Answer · 2013-12-21 10:37:03Z

2

Create Proc Proc_Name
as
begin 
    select *
    from
    (select 1111 as sno,'--ALL--' as branch
    union 
    select Rs.Sno, RS.branch + '-' + RT.[Type]
    from K_RT_MasterRetailStores Rs 
    inner join K_RT_RetailType RT on RT.sno = RS.[Type])
    order by Branch 
end

edited Dec 21, 2013 at 10:37

answered Dec 21, 2013 at 9:24

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user330315 Over a year ago

I don't think order by Rs.Branch will work. The order by sorts the complete union result, not just one part of the union. And the result of the union does not have a column named RS.Branch only one that is called Branch

juergen d · Accepted Answer · 2013-12-21 09:24:49Z

2

Remove the table name from the alias

select 1111 as sno, '--ALL--' as  branch
                                 ^--------------here

answered Dec 21, 2013 at 9:24

juergen d

205k40 gold badges304 silver badges377 bronze badges

Collectives™ on Stack Overflow

Exception in SQL server 'Incorrect syntax near '.'. '?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related