I sure wish you had mentioned this before. What kind of credit do I get for doing your...

PaulB (5/28/2009)

---

:w00t: flashback!

Brilliant...

Oh Ms. Gail, the exhaulted holder of the double-edged ninja throwing sword, I have a question about the "catch-all" in where statements. Please see my post here.

Thanks,

😛

1 bottle of vodka

2 bottles of rum

3 bottles of tequila

Check out these articles:

http://www.sqlservercentral.com/articles/Reporting+Services/62731/

http://www.sqlservercentral.com/articles/XML/63633/

Even though the first article shows one way, I would now do it by using the Join command to make a comma-delimited string, then using the method...

And thank you for coming back and posting what worked. This way, others with a similiar problem can see what worked.

First, I want to thank you for posting the DDL and DML to setup the tables.

How does this code work for you?

--StudentGrade

if object_id('tempdb..#StudentGrade') is not null drop table #StudentGrade;

CREATE TABLE...

Okay..... try this:

insert into TableA

select * from TableB

Florian Reischl (5/24/2009)

---

Heh... After about half an hour testing I figured it out. The answer is as simple that I didn't think about.

@Allister: Thanks for the test data!

I took Allister's...

Allister Reid (5/24/2009)

---

Hi Wayne,

Does your table have to be a variable, I had a go with a bigger data set and got really bad results on it, it got...

All of these get just the month / year in different ways, and with different formatting:

declare @Date datetime = GetDate()

select MONTH(@date), YEAR(@date)

select DATEPART(month, @Date), DATEPART(year, @Date)

select CONVERT(char(6), @Date, 112)

select CONVERT(char(7),...

josephptran2002 (5/18/2009)

---

Hi There,

Thanks, I did it and run the same codes that you suggested me to do

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'Ole Automation Procedures', 1;

GO

RECONFIGURE;

GO

it still gives me the same...