Hi Simon

It's a long shot, but could it be case sensitivity? Try 'ortussearch' in your sp_MSforeachdb query.

Cheers

ChrisM

Cool, well done.

There were a couple of changes to make between the original and the final,...

This works for me...just a couple of small changes

ALTER PROCEDURE dbo.Sun5_OFAC_Export

@bus_unit varchar(3)

AS

Declare @sql varchar(2000)

--build the SQL statement

SET @sql =

'SELECT '''...

Richard, can you post the result of the print statement please?

Hi Richard

The statement is longer than NVARCHAR(1000), so increase the value:

DECLARE @sql NVARCHAR(2000) should be more than enough.

bhushanhegde (12/3/2008)

---

Hi,

I want check a perticular table is blank or having any rows? is it possible with using exist keyword? itried with isnull. but it is not working.

select isnull(empid,0) from...

Hi Richard

Give this a try. When you've got it working, then's the time to put it into a stored procedure. Notice the PRINT statement? Take the output from this, paste...

Hi Ankur

Please have a quick read of the link at the bottom of my post. We need a larger data set as test data, posted as a script to create...

Skull Killer (12/3/2008)

---

Hi there

U can also create a var @ActionTable TABLE(id INT IDENTITY(1,1),Action VARCHAR(20))

insert the possible actions into this table

INSERT INTO @ActionTable (id,Action)

SELECT 'NEW'

UNION ALL

SELECT 'DELETE'

UNION ALL

...

or better...

If you have to do it this way, then something like this should suffice:

[font="Courier New"]-- Make some sample data

DROP TABLE #TablefieldPositionLength

CREATE TABLE #TablefieldPositionLength ([field name] VARCHAR(30), startingposition INT, fieldlength INT)

INSERT...

Hi Adam

If you run this code snippet, it will return dupe pairs. How would you identify which of each dupe pair to delete?

SELECT *

FROM vFRDonation a

INNER JOIN (SELECT OriginalTransNumber

FROM vFRDonation

WHERE...

Top work, Jeff. You have a rare talent for mixing informal narrative with a technically challenging subject - and with ruthless precision 😎

Cheers

ChrisM

Yep, thanks for the confirmation, Gail. I'm outta here.

Heh - no worries. Can you please run the following two statements and post the values they return?

SELECT MAX(LEN(RTRIM(i.Client))) AS Client_LEN,

MAX(LEN(RTRIM(i.CountryCode))) AS CountryCode_LEN,

MAX(LEN(RTRIM(i.ClientID))) AS ClientID_LEN

FROM dbo.vwImportAllNewClientIDs i

SELECT...

Hello

I've taken the liberty of simplifying/reformatting your code to make it a little more readable:[font="Courier New"]INSERT INTO dbo.tblDeals(Client,Bought_Sold,RIC,

   Trade_Date, Price, Counterparty_Code,

   Dealer, Commission, Consideration,

   Quantity, Currency, SEDOL, Participant_ID,

   FIDESSA_Ref, FX_Rate,...