hope this one helps u

SELECT name,

substring(name,CHARINDEX(' ', name)+ 1 ,len(name)) as Secondnamepart,

substring(name,CHARINDEX(' ', name)+ 1 ,charindex(' ',substring(name,CHARINDEX(' ', name)+ 1,len(name))))

+' '+ substring(name,1,1)+ '.' As NameTag

FROM test

hi,

Your first query

Select curr.StoreId as StoreId,

Curr.Sales as CurrSales,

LastYear.Sales as LastYearSales,

...