denis.gendera (8/21/2015)

---

I need to return 1 ip address for each machine. I can easily achieve this with using group by and return max(ipaddress) however I would like to filter...

Eirikur Eiriksson (8/14/2015)

---

Trying to put my finger on this, just cannot find which kind of XML phobia is plaguing you Jeff:Whistling:, so far I've...

With Pivot you effectively turn columns into rows and rows into columns http://sqlrambling.net/2013/10/31/pivot-basic-example/ - your example appear to want to turn an entire table into one row.

'Payer1' uses the 'Payer'...

Same here - it could have been phrased better.

In SSMS, right-click on the database and select Tasks/Generate Scripts.

Thanks for taking the time, much appreciated.

Hi Jacob,

Thanks for taking the time.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Test2](

[ID] [int] NOT NULL,

[Test_Value] [int] NOT NULL,

PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =...

So you just need the year as parameter 1, so you know which July 1st you're after. Then the number of periods, which equates to the number of months. You...

Execute the stored procedure 'sp_scriptpublicationcustomprocs' against the Publisher, with the Results to Text in SSIS.

This generates the default Stored Procedures for the Publication specified.

Execute the output against the Subscriber.

If you...

Local instances, where I can do anything I want (within reason). I use this to check that my understanding is correct, before moving into:

Test Server - where my changes and...

I have an example of how to locate the transaction causing the problem here - http://sqlrambling.net/2014/10/31/replication-monitor-basic-overview/

Brandie Tarvin (7/16/2015)

If you're going to stay for a few days, check out Abigail's Hotel[/url]. It is AWESOME and they make you breakfast. As in made to order with a...

Brandie Tarvin (7/16/2015)

---

BrainDonor (7/16/2015)

---

Lynn Pettis (7/15/2015)

---

And to widen this subject slightly - does anybody have suggestions as to how my wife could occupy herself in Seattle during the daytime? There...

Lynn Pettis (7/15/2015)

---

So, we are now in mid July, should I start looking at airline and hotel reservations for the Summit?

Not as concerned about getting a flight to Seattle as...

The packages we have here send emails via Script Tasks, which use system.net.mail.smtpclient.