yaniv.zisano (3/30/2012)

---

SSCoach its matter because i want the

user to select age from from range of number (select box - min) to range of number (select box - max)

and also...

If you aren't concerned about doing a point in time recovery, then use the simple recovery model. The only backups available are full and differential. The t-log will...

GilaMonster (3/30/2012)

---

When the data file is damaged or missing, the backup log must have the NO_Truncate option, or it will...

Yes, it is. BACKUP LOG <database_name> WITH NORECOVERY.

From Books Online:

NORECOVERY

Backs up the tail of the log and leaves the database in the RESTORING state. NORECOVERY is useful when...

Only things I can think of off the top of my head.

One, do you have a backup prior to the load you want to delete?

Two, can you use the input...

Phil Parkin (3/30/2012)

---

Jeff Moden (3/30/2012)

---

If you can make a small mod to your Calendar table... I usually create a Calendar table with 2 date columns to easily solve such an...

Well, can't really help you then. A table does not ensure order of the data. The only way to ensure order when selecting data from a table is...

And then when you select from the table be sure to use an ORDER BY clause specifying that...

yaniv.zisano (3/29/2012)

---

thanks for replay.

Is there any way to do it in a way that it display

me the data even if

The first value is less than or equal to the...

I haven't been in this position yet, but I would have to hazard a guess and say no. It wouldn't make sense to restrict reports to only dbo.

yaniv.zisano (3/29/2012)

---

hi, i want know how to get the ages between 25-28 (from ages 18 until 45)

when i do age between(25,28) its displays me data but

when i do age between...

Stephanie Giovannini (3/29/2012)

---

sturner (3/28/2012)

---

In my experience VB/Basic programmers have shown the worst software design techniques, implementations and documentation. The opposite seems to be true for those trained in OO,...

dweil (3/29/2012)

---

Thanks for the query but it gets sticky when the employee has multiple services over the same weekend. For example a service both on Saturday and Sunday would mean...

sqlvogel (3/29/2012)

---

Sean Lange (3/29/2012)

---

It is actually the very capture of this point in time data that makes it denormalized. The point I think we all made is that this is...

If you surround the urls with the IFCode shortcut [ url ] and [ /url ] without the spaces inside the brackets, the urls...