Jeff Moden (6/3/2010)

---

Steve Jones - Editor (6/1/2010)

---

There are quite a few people here with Oracle skills, including Jeff. I'm not sure Jeff wants to help with Oracle, but worth a...

I agree with Jeffrey. It sounds like you are joining on just the analyst id, when you should also be joining on the company id. Also, make sure that you...

Are you saying that you actually have Excel loaded on your server? Excel (all Office products) are not supported on a server.

Since it is a PK (not just an index), you will have to drop it. Try this:

ALTER TABLE dbo.Vendors DROP CONSTRAINT PK_Vendors

Alan Armstrong-249094 (6/3/2010)

---

Perfect, this is exactly what I needed! I will need to review your Dynamic Cross-Tab section as strLoginID with access will vary widely based on the idSpecOrder.

Thanks for...

It's fully explained in BOL under sys.database_files

I believe that you're looking for "^" (bitwise Exclusive OR) operator.

The syntax you're looking for is:

INSERT INTO STPWH.dbo.GPIV00101 (<column list, doesn't need to be qualified>)

SELECT (<column list, qualify with table alias ("i" in my example)>)

FROM A068.dbo.IV00101 i

...

Does your sql server NEED to run in mixed authentication mode? If not, change it to Windows Authentication only.

Of bigger concern... you are selecting, within a trigger, into a variable. This usually means that the trigger is not set up to properly handle multiple rows of data -...

Specifically, a LEFT OUTER JOIN.

Change the code to:

SELECT @szTitle = COALESCE( M.TITLE,'None')

FROM Meet_Master M

LEFT JOIN inserted i

...

I'd suggest replacing that c.u.r.s.o.r with:

UPDATE c

SET c.businessunit_name = t.BUSN_NM

FROM Card c

JOIN ##TEMP_CARD t

...

This looks like the error I get on my 64-bit laptop... there is no 64-bit version of the Jet engine. Is the sql running on a 64-bit OS?

Grant Fritchey (6/3/2010)

---

I'd like to hear that occasionally. I'm constantly barraged with "We've been doing it this way for 10 years..."

Like doing something stupid for a long time makes it...

TheSQLGuru (6/2/2010)

---

Jeff, can you please try the sample you have where the row-number-diff code falls off a cliff with the following changes: 1) temp table instead of table variable...