Yes, I did and it had no effect on the performance when run against the entire table.

Here we go......

Problem description:

After running the creation scripts and then running the SP...

If you look at MRN 1821, you will see that they have 4 insurance plans but...

Lynn Pettis (10/24/2008)

---

The sooner you can provide the schema and some sample data the better. Suggestion for the schema and data, primary key(s) on the table, and the additional...

Nope, as it is joining different other tables for other data.

How?

We have been contemplating rewriting the utility to use sqlcmd.

It varied..

One was where we were adding 3 columns in separate calls and the first column never got added, the second and third did, however, and the resulting SP created...

My bad, it wasn't the create procedure part of the script doing it but a real bonehead

definition of [varchar(25)] in a create table. DUH!!!

I forgot that the error message comes...

I used ApexSQLDiff to do this and it worked great. The DIFF script is fairly verbose

but you can modify it at your desire.

Depends, the later versions needed an add-on for command line support.

Check the help topic "command line interface"

RBY...

-- ptEncounter

CREATE TABLE [dbo].[ptEncounter](

[EncounterID] [int] IDENTITY(1,1) NOT NULL,

[BillNumber] [int] NOT NULL,

[ClaimNumber] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[LatestRec] [bit] NOT NULL,

[MRN] [varchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[SubscriberContactID] [int] NULL,

[LocationID] [int] NULL,

[AuthID] [int] NULL,

[BillerUserID] [int] NULL,

[PostingDtTm]...

Ok, sorry for the delay. I created an index on MRN+Status on ptDictation today and

made no difference in the plan.

Here is the execution plans and code used:

Execution Plans

-- Query1.sqlplan

-- 346195...

Do all the bak files begin with seven letters then the date?

Hey, that's pretty cool. There's more than one way to skin a cat!

Nevermind, got it working on my own.

Thanks for taking a look, though...

IF OBJECT_ID('dbo.fn_FormatSSN') IS NOT NULL

DROP FUNCTION dbo.fn_FormatSSN

GO

CREATE FUNCTION dbo.fn_FormatSSN (@Input NVARCHAR(MAX))

RETURNS NVARCHAR(MAX)

AS

BEGIN

...