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...

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 this point.

troy.hodge (5/29/2009)

---

Thanks for the replies so far. It will help when I raise this issue again with the vendor.

Lynn, could you help me understand better? Where...

Have you done what I suggested above? From your post it is difficult to determine.

Question I have,...

Alvin Ramard (6/4/2009)

---

GilaMonster (6/4/2009)

---

Do you understand what he's done?...

SSMS has its import/export wizard you can use for this as well.

Start here you can.

Here we go again with truncating and shrinking logs, especially when people don't understand what it is they are doing.

ryan213 (6/3/2009)

---

I just need to run a query that will pull data from the past month. So basically:

SELECT * FROM Output

WHERE Date BETWEEN '01/01/2009' AND '01/30/2009'

But wanting to automate...

Chris Morris (6/4/2009)

---

Lynn Pettis (5/28/2009)

---

Okay! Any one in Germany near Frankfurt? Maybe has a teen age (around 18 year old) son or daughter (preferably)?

And yes I am serious....