Month and year in descending order

-

dear all,

i looking have salary month , year in desending format.

my query below

select distinct  pa_view_pay_data.d_pay_date,'salary for'+' '+substring(convert(varchar(11), pa_view_pay_data.d_pay_date, 113), 4, 8) "payment details 1"
dbo.pa_view_pay_data pa_view_pay_data
order  pa_view_pay_data.d_pay_date desc

i loking have only payment details 1 column in mu output in decending way

output :'

salary oct 2012
salary sep 2012
salary aug 2012
salary jul 2012
salary jun 2012
salary may 2012
salary apr 2012
salary mar 2012
salary feb 2012
salary jan 2012
salary dec 2011
salary nov 2011
salary oct 2011
salary sep 2011
salary aug 2011
salary jul 2011
salary jun 2011
salary may 2011
salary apr 2011
salary mar 2011
salary feb 2011
salary jan 2011
salary dec 2010
salary nov 2010
salary oct 2010
salary sep 2010
salary aug 2010
salary jul 2010
salary jun 2010
salary may 2010
salary apr 2010
salary mar 2010
salary feb 2010
salary jan 2010
salary dec 2009
salary nov 2009
salary oct 2009
salary sep 2009
salary aug 2009
salary jul 2009
salary jun 2009
salary may 2009
salary apr 2009
salary mar 2009
salary feb 2009

regards,

vipin jha

thankx & regards, vipin jha mcp

dear all,

below query giving me exact wanted

select   'salary for'+' '+a.sal_month  (
select          distinct pa_view_pay_data.d_pay_date,
                left(datename(mm,pa_view_pay_data.d_pay_date),3)+' '+right(convert(varchar,datepart(yy,pa_view_pay_data.d_pay_date)),4) "sal_month"

           dbo.pa_view_pay_data pa_view_pay_data 
)a
order convert(datetime, '1-' + a.sal_month) desc


& regards,

vipin

                   

thankx & regards, vipin jha mcp



SQL Server  >  Getting started with SQL Server



Comments

Post a Comment

Popular posts from this blog

more indexes

-
i want 2 indexes. likes can't mssql. i have example fields: school class number i want school , class in index can this: school class number 1 2 435 1 4 4535 1 5 265 2 1 8234 2 2 8493 4 3 943 4 2 493 4 6 934 but how can in sql server management studio i declare unique constraint. borrowing segio's ddl: create table dbo.orderrows ( id int identity (1, 1) not null primary key ,ordernr varchar (20) not null ,orderrow varchar (20) not null ,rowtotal decimal (11, 3) default 0 not null , constraint uq_orderrows unique (ordernr, orderrow) ); above under hood create unique index on column combination (ordernr, orderrow). tibor karaszi, sql server mvp | web | blog SQL Server  >  ...
Read more

ActiveDirectory

-
hello togehter, is possible disable bloody warning?: event id: 2887 event source: activedirectory_domainservice event type: warning event description: during previous 24 hour period clients attempted perform ldap binds either: (1) sasl (negotiate kerberos ntlm or digest) ldap bind did not request signing (integrity validation) or (2) ldap simple bind performed on cleartext (non-ssl/tls-encrypted) connection directory server not configured reject such binds.  the security of directory server can enhanced configuring server reject such binds.  for more details , information on how make configuration change server please see http://go.microsoft.com/fwlink/linkid=87923. summary information on number of these binds received within past 24 hours below. can enable additional logging log event each time client makes such bind including information on client made bind.  to please raise setting "ldap interface events" even...
Read more

Virtual Channel

-
on condition rdp decide protocoll extension necessary? use standard gdi , if there movie playing, switch dynamically window ms-rdpev video transfering? or full session send on additional ms-rdpev. , in cases host rendering , in case client rendering? thanks in advance! hi, the remote desktop protocol video redirection virtual channel extension used redirect audio/video streams terminal server terminal client . protocol specifies communication between application playing audio/video on terminal server , terminal client. regards, wilson jia this posting provided "as is" no warranties, , confers no rights. please remember click “mark answer” on post helps you, , click “unmark answer” if marked post not answer question. can beneficial other community members reading thread. ” Windows Server  >  ...
Read more