Hi

(and welcome at SSC 🙂 )

As a general answer: It depends.

It's hard (impossible?) to answer this question. A database server cannot be compared to something like .NET/C++/Java code which always...

Yup, this makes it easy to skip some tweets.

(BTW: One non-technical thing I really love is Lynn's...

Hi % 🙂

I like Twitter, since it works like a proactive search engine for technical stuff. Sure, there is a lot of useless noise (sometimes provided by myself :-P) but...

@jack-2 Corbett

Please correct me if I'm wrong...

When loading many data, Lookup Transformation might become a performance issue, doesn't it? At least if keys cannot be cached.

I'd prefer a...

Without any errors, the files should be copied. Maybe a rights problem? What do you get if you execute the following statement:

EXEC master..xp_cmdshell 'DIR \\OBBEVAER\IT_Reports\DBA\'

If you're fine with a single-user database without rich T-SQL features, try SQL Server Compact. Otherwise download and install SQL Server Express, as mentioned by Gail.

Greets

Flo

Hi

You can use a temp table to catch both results in separate executions.

Greets

Flo

Another option is to use Service Broker. Maybe have a look to BOL.

Greets

Flo

Hi

To load XML from file into a variable use OPENROWSET:

DECLARE @blob XML;

SELECT @blob = BulkColumn

FROM OPENROWSET(

BULK N'C:\Temp\test.xml'

...

Hi

You have to specify a ROOT element:

SELECT ProductModelID, Name

FROM Production.ProductModel

WHERE ProductModelID=122

or ProductModelID=119

FOR XML RAW, ROOT('MyRoot')

Greets

Flo

Hired 😉

Hi conradude

Did you check the execution plan? I get a index scan.

Greets

Flo

Terminated

Didn't notice the missing column name(s)...

Your approach should work, doesn't it?

Maybe this could be a better performance:

SELECT

MAX(

CASE WHEN field1 >...