Hugo Kornelis (9/19/2012)

---

IgorMi (9/19/2012)

---

Hugo Kornelis (9/19/2012)

---

Nice question. I almost got it wrong, because I had first overlooked the TOP clause.

However, the official correct answer is still a bit questionable. The...

ChrisM@Work (9/19/2012)

---

Sean Lange (9/7/2012)

---

ChrisM@Work (9/7/2012)

---

Have a look in BOL under...

vahid.arr (9/19/2012)

---

Well Thanks to all this are the things that i have doubt about it.specialy number 4:

1- i have table with 40 fields that it have 10 image Type field...

crux1187 (9/18/2012)

---

Okey before I try it out I have a question regarding your answer. When you set the Delete Rule constraint to Set Default, the default value in the column...

That is not a large topic, it is more like I have lost a grain of sand somewhere in the Milky Way, how do I find it? There are hundreds...

Eliza (9/18/2012)

---

Jeff Moden (9/17/2012)

---

Eliza (9/17/2012)

---

Hi all,

Can I ask please if I have a row and one column has a csv list in it. Is there a way please to...

Lynn Pettis (9/18/2012)

---

SQLRNNR (9/18/2012)

---

Lynn Pettis (9/18/2012)

---

Flat file, 150,000 columns, SQL Server only allows 1,024 columns per table. The flat file needs to be imported into Excel spreadsheets.

I'm not in...

That's pretty much what I am thinking.

You are welcome. Hope that works for you. More importantly, do you understand what it is doing?

Nice back to basics question. I am astounded that at the time of my posting there are 111 (14%) that answered this wrong. I can understand those that answered 3...

Something like this should get you started.

select

WeekEndDate,

floor(((DATEDIFF(dd, dateadd(mm, datediff(mm, 0, WeekEndDate), 0), WeekEndDate) + 1) / 7.0) * SUM(PlanItemsSold)) as PlanItemsSold,

floor(((DATEDIFF(dd, dateadd(mm, datediff(mm, 0, WeekEndDate), 0), WeekEndDate) + 1)...

crux1187 (9/17/2012)

---

I apologize for the wrong format anyway I did my best to make my question clear. Pls refer to the items below:

-- START

USE student

-- Create table for food category

CREATE...

ScottPletcher (9/17/2012)

---

Do yahoo and other email provides allow expired and reclaimed email addresses to be re-cycled?

If any of them did recycle one, and I got the same email address as...

Pretty sure you want a cross tab query for this. If at all possible this would be far more efficient in the front end. Take a look at the links...

Create backup.

Restore backup.