masri999
3/29/2007 3:21:00 AM
On Mar 28, 10:52 pm, "Hitesh" <hitesh...@gmail.com> wrote:
> On Mar 28, 1:39 pm, "M A Srinivas" <masri...@gmail.com> wrote:
>
>
>
>
>
> > On Mar 28, 10:23 pm, "Hitesh" <hitesh...@gmail.com> wrote:
>
> > > Hi,
>
> > > I have a store procedure that I run using BCP to generate a report.
> > > I cannot do osql/isql because of certain formating issue. I want to
> > > sort the result ORDER BY DateTimeStamp ASC
>
> > > here is the syntax.. If I do that then header col goes at the
> > > bottom..
>
> > > SELECT CONVERT (varchar (20), 'Account '),
> > > CONVERT (varchar(7), 'Sym')
> > > CONVERT (varchar(25), 'DateTimeStamp') AS
> > > 'DateTimeStamp'
> > > UNION ALL
> > > SELECT CONVERT (varchar(20), e.Account),
> > > CONVERT (varchar (7), e.Sym),
> > > CONVERT (varchar(25), e.DateTimeStamp, 21) AS
> > > DateTimeStamp
> > > FROM TbleReport e
> > > ORDER BY DateTimeStamp
>
> > > any hints on where I keep header col on top still able to sort
> > > DateTimeStamp
> > > ASC
>
> > > hj
>
> > Some thing on these lines
>
> > SELECT CONVERT (varchar (20), 'Account '),
>
> > > CONVERT (varchar(7), 'Sym')
> > > CONVERT (varchar(25), 'DateTimeStamp') AS
> > > 'DateTimeStamp'
> > > UNION ALL
> > > SELECT CONVERT (varchar(20), e.Account),
> > > CONVERT (varchar (7), e.Sym),
> > > CONVERT (varchar(25), e.DateTimeStamp, 21) AS
> > > DateTimeStamp
> > > FROM TbleReport e
> > > ORDER BY CASE WHEN DateTimeStamp = 'DateTimeStamp' THEN '00000000' else DateTimeStamp END- Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -
>
> > - Show quoted text -
>
> sorry.. what is on that line?- Hide quoted text -
>
> - Show quoted text -
I think post got trucated (?) or network issue
declare @tbla table ( a int , b datetime)
insert into @tbla values(1,'01/01/2006')
select T.* from
(
select a, cast('header' as varchar(10)) as b from @tbla
union all
select a, convert(varchar(10),b,101) as b from @tbla
) T
order by case when T.b='header' then '0' else T.b end