guerillaunit (1/23/2012)

---

Hey knowitall, your version did the trick. The code I posted was the SQL view of a query I had in Access. I do have a question...

SQLKicksButt (1/23/2012)

---

Jared, you are correct that there could be different implications for adding a new appliance versus just updating. I would say adding a new appliance is a rare thing...

My thoughts on this approach are mixed. Not being as experienced as Jason, I wonder what the implications are of updating an appliance or entering a new one. ...

I think you have a good start, but I would not have 1 table for the properties. This can cause you big problems later on. I would set...

I believe that openrowset is read only. You can try using opendatasource. http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/2277719c-2484-4020-9b79-a0acb6f296e6/

Does this query accomplish what you were trying to do?

SELECT DISTINCT toc.[Account Number],

toc.[Customer Name],

toc.[Top Parent Customer Account] AS [Top Level],

toc1.[Customer Name] AS [Top Level Cust Name],

toc.[Top...

Ok, I'm looking at this more closely and really trying to figure out what you are trying to do, as it is not clear. Can you please provide the...

Your joins are a bit funny as well. Why are you joining to the same table so many times? Also, why are you not using aliases like I suggested?...

This: 'rpt.tbloraclecustomers_1' should not have a . in it and really should not have the single quotes around it. Try an alias for this AS tblOracleCustomers_1

What are your Linked Server options set to for this specific linked server object?

Have a look here. It is for 2005, but should be applicable to 2008 as well.

http://stackoverflow.com/questions/726783/reporting-services-hide-table-column-based-upon-report-parameter

L' Eomot Inversé (1/18/2012)

---

Brandie Tarvin (1/9/2012)

---

Craig, I get what you're saying, but I can't figure out how to pass the error outside of the code context to fail the job...

Assuming that server01/prod01 is your server name, ctsreports is the database, rpt is the schema, and tbloraclecustomers is the...

CREATE TABLE #TEST

(

PACKAGE INT

,CODE VARCHAR(20)

,[DESCRIPTION] VARCHAR(20)

)

INSERT INTO #TEST

SELECT 10000,'CSAC','CASING'UNION ALL

SELECT 10000,'BOXC','BOXING'UNION ALL

SELECT 10000,'CSAC','CASING' UNION ALL

SELECT 12000,'BOXC','BOXING'UNION ALL

SELECT 12000,'BOXC','BOXING'UNION ALL

SELECT 12000,'BOXC','BOXING' UNION ALL

SELECT 13000,'BASK','BASKET'UNION ALL

SELECT 13000,'CSAC','CASING'UNION ALL

SELECT 13000,'BOXC','BOXING'

;

WITH RowNumbers AS

(

SELECT PACKAGE,...

1 more guess from me... Are you trying to identify duplicates?