You can use a LEFT JOIN to get only the countries which are not yet exist within your destination table and a ROW_NUMBER to create a PK.

CREATE TABLE #Country

...

Lynn Pettis (6/26/2009)

Florian Reischl (6/26/2009)

Jeff Moden (6/26/2009)

Heh......

Jeff Moden (6/26/2009)

Heh... I'm not sure where...

Thanks Paul.

@yaya1899:

Just fount a failure in one part of my post. I filled the Numbers table with a Tally table :hehe:. Since you probably done have both this will generate...

So, Paul gave me the GO...

There is almost never a reason to work with cursors or loops in T-SQL. As Paul and Gail wrote SQL Server is made for set-based...

Can we go on now? 😎

I hope (s)he did. Next posts have been really okay.

What about a LEFT JOIN...

SELECT

*

FROM PurchaseOrders po

LEFT JOIN ArrivedItems ai ON pon.PurchaseOrderNo = ai.PurchaseOrderNo

...

Hi

In SQL Server 2005 you can use the OUTPUT clause to work without a loop:

DECLARE @t TABLE

(

JobId INT,

JobCode VARCHAR(10),

Issued BIT,

...

Just to ensure, do you have a typo in your file name?

You:

sqlserver.exe.config

Error:

sqlservr.exe.Config

Did you buy one "e"...

rodan,

Let me take the working statement of "DBA with OCD" an add some slight improvements. To ensure that you don't get a mail if number of days is less than...

As first let me make your XML readable for other people here.

Usually you get:

1

...

Now we get together 😉

Just don't see any question in your current post. It returns the count of days between the maximal statdon and today (well, NOW).

Do you have any...

In front-end it doesn't matter if your data are stored as FILESTREAM or as usual VARBINARY(MAX) data directly in database. I just saw a Microsoft webcast which said rule of...

I have a vision and you have a task

@Lynn: Thanks for your blog "The Flip Side"!