I would think you would want more like this:

select

case when PATINDEX('%air_fir%',column) > 0 then 'air_fir'

when PATINDEX('%LCAIR%',column) >...

ColdCoffee (4/3/2012)

---

Can you define "StartDate" and "EndDate"?

Is startdate the Sunday/Monday of the week that your input date falls on and the EndDate would be exactly 7 days from that sunday/monday?

As...

Answered that above, but yes. Stage is just a...

bplvid (4/3/2012)

---

I"m back here.When I execute my SP I get it inserted but it throws me msg saying

"Subquery returned more than 1 value. This is not permitted when the...

Post the code for [dbo].[rpt_sp_get_date_range].

Absolutely no idea. I have nothing with which to test against, so I can't tell you. Plus, if the dates are stored as DATETIME datatype, it doesn't matter...

Define your disaster. We have told you,...

Nothing in writing that I can point you to on this. Staging to me is a landing point. You get your data from the source system as quickly...

Here is a possible where clause that may meet your requirements.

WHERE

EXPIRE_DATE >= dateadd(dd, datediff(dd, 0, getdate()), 0) and

EXPIRE_DATE < dateadd(dd, datediff(dd, 0,...

lukebaker (4/3/2012)

---

So any date from now up until 60 days. 1 to 60 days from now so from today (04/03/2012) to (06/02/2012) and display all data inbetween those 2 dates...

Also, since you are new here, you will get much better answers to your questions if you post the DDL (CREATE TABLE statements) for the table(s), provide sample data (a...

GilaMonster (4/3/2012)

---

As Lynn said:

If you lost the mdf/ndf file(s) but still had access to the ldf (t-log) file, you could complete a tail log backup and recover the data up...

Not sure what you mean from now to below?

Nope, not you either.

DBA_SQL (4/3/2012)

---

I would like to know how can we get the point in time recovery data information.

For ex: 12:00 AM - FULL BKUP

...