select *
from tb_blog_press with(nolock)
where 1=1
and datepart(m,dte_blog_date_added) = #datepart('m',urldecode(url.the_date))#
and datepart(yyyy,dte_blog_date_added) = #datepart('yyyy',urldecode(url.the_date))#
and bln_blog_type = 3
order by dte_blog_date_added desc
select distinct month(dte_blog_date_added) as mymonth,year(dte_blog_date_added) as myyear
from tb_blog_press with(nolock)
where 1=1
and bln_blog_type = 3
order by year(dte_blog_date_added) desc
select distinct myyear
from getarchives
order by myyear desc
#header#
Job Postings for #dateformat(url.the_date,'MMMM YYYY')#
#getblogcontent.str_blog_entry_title#
#dateformat(dte_blog_date_added,'MMMM dd, yyyy')#
#getblogcontent.str_blog_entry#
No job postings have been posted for this month. Check the archives to view older blog postings.
For all job inquiries, please email jobs@shoesilove.net.