Hi,

I suggest you construct some dynamic sql as per below, using the intersect operator instead of the AND.

select id from entitiesFullText eft where eft.word like 'med%'

INTERSECT

select id from entitiesFullText eft...

...or use the SMO from within SSIS as this is where he's doing the rest of his scripting.

Check out this article [/url]which generates audit tables based on your tables using xsl. If you're already using ssis for the other scripts, you could leverage this to do...

I would suggest you don't load the data into a float datatype unless you're sure that's what you want. Best to use a high precision numeric.

In the import wizard,...

I haven't tested this, but something like this should do the trick.

SELECT wh_id as Wh, dateadd(m,datediff(m,0,create_dtim),0),count(*) as Plan FROM Backtest where wh_id in (1,9) group by wh_id, datediff(m,0,create_dtim)

No great revelations I'm afraid. I can just give you what I think is the Oracle approach.

If I understand you correctly, you're in a query window, rather than a...

SwePeso (12/9/2013)

---

Here is a link to download the schema of my hybrid solution.

It can also be found on my web page http://www.sqltopia.com[/quote%5D

Just starting to try to get my...

Thanks Jeff...although.....

Hmmmm.....I must have been unclear in my question....but I'll say it again....I'm asking about Oracle (hence I posted in the Working with Oracle forum.)

.....I hate for your salient contributions...

...and I thought I was missing the point! 😉

My question relates to ORACLE!

Thanks anyway.

I'm curious what you mean by "each of which pulls roughly 50 records"...how are you joining your tables? INNER JOIN, LEFT JOIN or UNION?

The number 20 (tables) shouldn't be...

Thanks, Stephanie....makes sense at last!

tom.w.brannon (10/27/2015)

---

I am completely baffled by being able to get a result for Server2 before it has even been connected to. Can somebody give a better explanation? The...

UPDATE dbo.tblCustomer

SET Extra=NULL

FROM inserted tI

WHERE dbo.tblCustomer.CID = tI.CID

-- Worth checking for non empty?

AND dbo.tblCustomer.Extra <> ''

If you want the column to be set always to null, then...

...then use the script I provided, and change the last select into an update.

In the following link you can see which are the advanced options.

http://msdn.microsoft.com/en-us/library/ms189631.aspx

The advice is that these are best left to the experts!

(Important : Advanced options...