set nocount on

if object_id('job_postings') is not null

drop table job_postings

go

create table job_postings(

jobid int,

JOBTITLE varchar(30),

JOBPOSTEDDATE datetime)

go

insert into job_postings (jobid, JOBTITLE, JOBPOSTEDDATE) values(11,'Unit Tester','06.02.2004 20:53:19.433')

insert into job_postings (jobid, JOBTITLE, JOBPOSTEDDATE) values(13,'devoleper','07.02.2004 14:31:27.173')

insert...

Ok, what about bcp the data out and create a *.bat file that bcp the data back in?

If you only what to find a way to take some table data home, why don't you export those tables to flat files or some other format and import this...

Please avoid double postings.

Let's continue here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=101113

Copy and paste with a baby on the arms is more difficult than I thought.

Forgot to copy the last lines. After doing the insert into, you may alter your table...

don't use select into, but rather  create your table first and then insert into like this

if object_id('ident') is not null

drop table ident

if object_id('ident1') is not null

drop table ident1

create table ident(id...

Ahem, maybe I've missed again something but wouldn't this do the job

SELECT JOBID, JOBTITLE, JOBPOSTEDDATE

  FROM JOB_POSTINGS  ORDER BY JOBPOSTEDDATE desc

If you are after some sequence this might be helpful

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/q186/1/33.asp&NoWebContent=1

Learn each day something new

Your query works here fine, too, Mark.

Simple answer: No

Maybe something from this site will help you with your query:

http://www.sommarskog.se

Especially the articles on dynamic searches and dynamic sql might be...

In quite a few stored procedures I use the same business logic to calculate prices. So each time the customer requires another refinement I have to modify every stored procedure...

While partitioned views are certainly an option, do I understand you correct, that reviewing table design is not an option?

What about having a closer look at the index(es) on that...

When you look at / Divide in BOL you will find

If an integer dividend is divided by an integer divisor, the result is an integer that has any fractional...

First of all, sorry for being that late on my reply. I was voluntarily completely offline last week.

Glad to see I caused some...

Well, interview question or not. My answer would be

Do this at the client! The server is for data retrieval, not presentational stuff.