P, What you want isn't actually a Pivot. Pivot will rotate the values from rows to columns but only if you have a predefined set of KNOWN values in the...

That's what the OR part accomplishes.

All students not at M regardless of their career_level.

SELECT site,campus_id, pin

FROM dbo.tblStudents

WHERE

-- get all students at site M that are not undergrads

(site = 'M' and...

*laughs* Well Jeff, I prefer to have my code ran and done quickly so I can go drink another...

Move your search criteria into a "table" left join from it to your tbl_orders as below ...

SELECT cols.col_number, col_status

FROM

    (SELECT '123' AS col_number

      UNION

    ...

I haven't tested this, but it should work and NO Cursor! Except for the TOP 8 part. If you do in fact need the top 8 reply and someone or...

This may or may not help, have you looked into SQL Compare and SQL Data Compare.

http://www.red-gate.com/products/SQL_Compare/index.htm

http://www.red-gate.com/products/SQL_Data_Compare/index.htm

Look here ...

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=835

Lisa,

That is exactly what I am seeing and can't find a solution. The weird thing is that the message can go to four different people, and three of them can...

Have you tried without the ".\\" ?

Just using ...

SqlCeConnection con = new SqlCeConnection("Data Source =TestDB.sdf; Password =testdb;");

Yes and NO! There are all sorts of unique identifiers in the RS database and I really don't think you can just copy them over.

David,

Are you saying that you have subscriptions set up in RS 2000 Enterprise using MS's interface, and you are attempting to re-create them in RS 2005 Standard without the interface...

David,

I am unclear on what you are asking. What columns are returned from [Reports Ledger]

And the procedure should work the same in 2005 as it does in 2000.

Jason

What do you get when you run ...

SELECT TOP 100 

    dbo.[Web-Registration-Golf].Delegation AS Facility

    ,dbo.certifs.Owner

FROM        

    dbo.[Web-Registration-Golf]

        LEFT JOIN dbo.certifs

            ON...

After looking closer, are you sure that counting on the StateID is appropriate? Wouldn't you use certifs.Misc or .Kind

just a thought...