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

josephptran2002 (5/18/2009)

---

I tried to copy your codes and run it, somehow it works...but it gives me a small error. Do you know why?

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)"...

DBA (5/18/2009)

---

Select distributorid, distributorname, distributorstatus,distributorcargo

from Dist_Main M inner join Dist_Details D on

M.DistPK = D.DistFK

where distribuborcargo = @cargo

and distributorstatus in ('9', '7','5','1')

my issue is creating a variable...