Depending on how many of these values you may have in a row, I'd consider using the bit data type.

Alvin Ramard (6/4/2009)

---

You can get points quickly if you ask questions here...

J-F Bergeron (6/4/2009)

---

Hey Lynn, I've been trying to do...

Lynn Pettis (6/4/2009)

---

Gaby Abed (6/4/2009)

---

Was that Mr....

Gaby Abed (6/4/2009)

---

Was that Mr. Echo from...

For some reason, I can't post the code directly. Please see the attached file for something I hope helps.

Hello.. Hello .. Hello .. Seems we got an echo in this thread.

By the way, BOL (Books Online) is a great resource for just this type of question.

Oh, please tell me exactly what I need to do. I have NO IDEA how to look things up in BOL.

Try putting the name of your field where the sample data was put in the post above.

You are going to have use dynamic sql to accomplish this particular task. I'd suggest doing some research first looking at BOL (Books Online). After that, if you...

Or, if you still don't mind the warning above, this would work as well:

Declare @stocks TABLE([Date] SMALLDATETIME, [Name] CHAR(1), Buy INT, Sell INT)

INSERT INTO @stocks (

[Date],

...

Jack Corbett (6/4/2009)

---

Something like this works:

Declare @stocks TABLE([dAte] SMALLDATETIME, [nAme] CHAR(1), Buy INT, sell INT)

INSERT INTO @stocks (

dAte,

[nAme],

Buy,

sell

)

SELECT

'1-1-2008', 'A', 1, 4

UNION ALL

SELECT

...

David Webb (6/4/2009)

---

Is there a chance that the full backup procedure does an explicit truncate on the log at some point after the backup is taken? It would invalidate...

Alvin Ramard (6/4/2009)

---

Lynn Pettis (6/4/2009)

---

Any one else have an idea regarding this one?

Apparently the full backups work but can't run a transaction log backup. I'm at a loss at...