What did you get when you tried it?

When I ran this:

DECLARE @Var int

IF @Var IS NULL

SELECT 'It Works'

ELSE

SELECT 'Nope'

it returned It Works on my system at home.

Are you running this from BIDS in debug mode? If so, on your desktop system or the server? Is the file located on you desktop or the server?

torpkev (7/28/2009)

---

I believe you can try:

SELECT SERVERPROPERTY ('edition') as [Product Edition]

64 Bit should say Standard Edition (64 Bit)/Enterprise Edition (64 Bit) in the text, 32 bit will just say Standard...

Youri S. Pikulin (7/28/2009)

---

Yes, I have tried this.

The copy size is about 80 MB, even with an (empty) ntext column. So, this is a work-around (copy, drop original, rename copy)....

Now you added another table to the mix. Is Table2 used else where in this procedure?

Actually, the error message isn't really helping here. The real problem is that we can't see your package to determine what may be wrong. Start where Alvin suggested...

Something like this?

select

ISIN,

Ticker

from

#TestTab

where

len(Ticker) >=5

and (Ticker like '% %' or Ticker...

Might be E3L (or ETL, but then that might be cofused as something else), English as 3rd Language; as opposed to ESL, English as Second language.

I'm sorry but the second INSERT into Table1 has me totally confused. First, there is a typo as both instances of Table1 are aliased a. Second, it doesn't...

Okay, that's your data, but what does the table look like, what is the output from the query supposed to look like?

Alvin, did you lose your tin-foil hat again?? You know we are supposed to be able to read minds. 😉

I don't believe this is possible. However, if the user does not have permission, they won't be able to access the other databases.

Looking at the query and the fact that it uses just that one column, I'd add an index on that column. If it has to do a table scan...

select distinct

a.EMPID,

sdate

into

#temp1

from

dbo.vwJobcd as a

inner join #tabdates as b

...

I'd also make the following change to your where clause so that the Query Optimizer can make use of an index on meetingstartdate if it exists.

SELECT

meetingstartdate,

...