What I mean is find a row that is not correctly filtered. Get the input param from that row and run the function manually. That will show you...

is250sp (3/16/2011)

---

CREATE FUNCTION dbo.CI(@chg_ref_num varchar(10))

RETURNS VARCHAR(1000)

AS

BEGIN

declare @ci varchar(1000)

select @ci = coalesce(@ci + ', ', ' ') + cast(cor.resource_name as varchar(50))

from ca_owned_resource cor

inner join lrel l on substring(l.r_persid, 4, 60)...

Function is not working properly. Nothing else could explain this.

It's not the same query... it's like asking your gps to find New-york.

But you're sitting somewhere on jupiter. Not going to work!

of course it works, the dbname is hardcoded in the query!

The case needs to be in the select itself.

You're getting this error because you have no from clause in the case's select. So sql can't find the columns and...

I've had the same "issue" when showing the reports on the web. However iirc when exporting that issue was gone.

My guess was that MS changed the way the reports...

lindsaywang (3/15/2011)

---

Hi,

Is there anybody can help me take a look?

I want to create one temp tble by using the query like select * into #tmptbl from EXEC SP......

Just to add to what Lynn is saying. How do you identify the rows that need to be deleted?

Once you have that figured out it's easy to code the...

Can't find anything usefull on google. I guess I'm searching for the wrong terms!

The only idea I have is to replace * with something silly like [star] and then...

Assuming vb6 transposes to ssis :

day(date) would be 15 today.

so that makes...

Have you tried doubling it or using brakets around it?

I'm thinking the other way around completely.

Get a "change log". Generate dynamic sql from there and exec.

No need to loop in all tables if only 1 table was changed.

Option Z

Rename old table, drop all constraints (name conflicts)

Then create new table with all constraints and indexes.

You still have a backup of the table and you have an empty table...

Once the domain is setup on the new location, plug a pc and try to connect.

Debug if it fails.

repeat step 1 untill it works.

The server is working now. So...