Because of the ORDER BY (select 0) in the over clause. The RANK is being calculated based on 0 for each record, and since they are the same each...

Just a guess, but by configuring the named instance to use port 1433, looks like you don't need the name of the instance. I'd be interesting knowing the why...

Microsoft. When you create a primary key constraint, if a clustered index does not exist on the table SQL Server defaults the primary key to a clustered index.

Not always...

Unless you configure the named instance to run (listen) on port 1433, it listens on a dynamically assigned port. This is why port 1434 needs to open so that...

Okay, I gave it my shot in the dark. Unfortunately we can't see what you see so unless you provide us with more information that's about all you will...

How about something like this:

/*

Master Table

ID, Name, Address, Job Desc

1, Bob", "New York","Sports Reporter"

2,"Chris","Washington","Doctor"

Notes Table

ID, EmpID,Note

1,2,"Chris has been"

2,2,"a doctor in the"

3,2,"USA for 5 years."

*/

create table dbo.MasterTable(

ID...

A guess, SSIS is expecting the third column to be an integer and the text data it found can't be converted.

This:

declare @loginname varchar(35)

set @loginname = '<rxno>001c</rxno>\test1'

select SUBSTRING(@loginname,CHARINDEX('<rxno>',@loginname)+6,CHARINDEX('</rxno>',@loginname)-CHARINDEX('rxno>',@loginname)-5)

Alan.B (3/5/2013)

---

Lynn, Jeff, Kevin, ChrisM: thank you very much. This has been a particularly informative and excellent thread. It's given me a lot of new things to chew on.

Inline...

sej2008 (3/5/2013)

---

let me make it clear what I want is u have

Server1 and two seperate instances

wherein db1 is mirroring with db2 ( endpoint MIrroring1)

now you have db3.....db4 mirroring...

Your tally table starts at 1 not 0.

PiMané (3/5/2013)

---

Thanks.

I believe that in this case, since the parameter...

I have to head to work. I may look at while eating lunch else it will be tonight.

ScottPletcher (3/5/2013)

---

Lynn Pettis (3/5/2013)

---

ScottPletcher (3/5/2013)

---

Jeff Moden (3/4/2013)

---

I'd love to take the credit for it but it's not my code. It's Scotts (although I'd have done it the same way).

I...

ScottPletcher (3/5/2013)

---

Jeff Moden (3/4/2013)

---

I'd love to take the credit for it but it's not my code. It's Scotts (although I'd have done it the same way).

I was just curious...