It happens to all of us...

Yep, you should have said that. :w00t:

But as far as I know, the answer is "no" you can't do it with EXISTS.

Patrick Ige (4/8/2008)

---

I want to use select into to create a table StockCode_Planstest and insert data from the cross

join but keep getting error on the first line

Any ideas..

SELECT stockcode_id,plan_id,mc_id...

WRACK (4/8/2008)

---

Hi,

Where can I add those functions and stored procedures so they appear everywhere?

In my research I have found that every database is created using the "MODEL" database as a...

I would suggest that you study up on JOINS..... 😀

SELECT

A.CustomerID

,A.SurName AS 'CurrentSurName'

,NULL AS 'ArchiveSurName'

FROM

Customer.Customer AS A

...

This won't handle the RED records, but it will get you close. 😀

SELECT FIELD_NAME, TABLE_NAME

FROM yourTable

WHERE FIELD_NAME IN (SELECT FIELD_NAME

...

Depending on your exact needs, just create linked tables in access. (Right Click - Link ??) in the table tab. Then the data isn't actually moved or copied, but rather...

yucky

Ihave no experience using it, but wouldn't WITH ENCRYPTION be helpfull?

1. Swap your tables around the LEFT JOIN clause.

2. Use the OVER .. PARTITION BY like I mentioned earlier...

Create some sample data

DECLARE @project TABLE (project_id CHAR(5), component_id CHAR(5), cost_element_id CHAR(5),...

It's hard to test without sample data, but I think what you want can be done with windowed functions ...

Specifically, the SUM(...) OVER (PARTITION BY ...)

SELECT

a.project_id...

1. No, there is no way to do that. OK, Cess shows a way to do it below. But that's a TON of work when you can just not...

No, I'll bet he's dynamically creating the .RDL (Reporting Services Definition) files on the fly. 😀

Create views that expose the data/columns that you want them to "see" and procedures to manipulate it. Then only give permissions to the "customers" on the views and procedures.

Yes, you could do it that way. 😀