You will get better responses to your questions if you provide more information. Personally, from your original post, there really isn't enough to really help you. What would...

kaplan71 (3/19/2014)

---

Hello --

I ran sqlbuddy123's script, and the output, going back to February 22, is shown below:

The only thing I learned from backup history is that it...

Unfortunately without seeing the actual code it is hard to tell you if you are doing things correctly or not.

Let me paraphrase what is going on:

Saturday, full backup runs successfully.

Sunday, differential backup runs successfully.

Monday, differential backup fails saying you need to run a full backup.

First, what recovery model is...

ScottPletcher (3/14/2014)

---

Lynn Pettis (3/14/2014)

---

vamsikrishnacheruku (3/10/2014)

---

hai i want to get the first date and weekday of every month in a year .

1/jan/2014, monday

1/feb/2014,thrusday

...

simflex-897410 (3/14/2014)

---

Hi Lynn,

Thank you so much for your responses.

I must say though that I am very confused with your questions.

You asked if table1 is related to table2 by userid?

I did...

select username,

password,

isnull(access_level,0) access_level

from table2 e left join table1 m on e.userid = m.username...

simflex-897410 (3/14/2014)

---

Jeff or anyone, can you please advise me on how to post my data?

These names are actual names of popular people and I can't post their information here.

Our site...

vamsikrishnacheruku (3/10/2014)

---

hai i want to get the first date and weekday of every month in a year .

1/jan/2014, monday

1/feb/2014,thrusday

...

Luis Cazares (3/14/2014)

---

Pritz (3/14/2014)

---

Update dbo.voters

Set rec_num = DENSE_RANK() OVER( ORDER BY part_no)

from dbo.voters

Got the error for the script above.

can you re-post the corrected one? I cannot see...

Funny, I...

First, for what code. Posting "got this error" really doesn't tell anyone anything.

Second, recheck the...

Fixed my code posted earlier.

Luis Cazares (3/14/2014)

---

Noting that you're on 2005 (as you noted in the other thread), you could use the DENSE_RANK function.

Update dbo.voters

Set rec_num = DENSE_RANK() OVER( ORDER BY part_no)

from...

Agreed. That way we can use the newer features that are not available in SQL Server 2000. Makes things easier.

By the way, to the OP, please don't post...