This does indeed require a restart. Schedule maintenance time.

Thanks for the reply Steve. I'm spinning up a test instance now and will report back my findings.

Maybe:

Select IsNull(t1.ServerName,t2.ServerName) as ServerName,

IsNull(t1.ApplicationName,t2.ApplicationName) as ApplicationName,

Case

When t1.ApplicationName is null then 'Table2'

When t2.ApplicationName is null then 'Table1'

Else 'Combine'

End AppServer

From Table1 t1

Full Outer Join Table2 t2 on

(t1.ServerName = t2.ServerName)...

I haven't tested this since there was no test data supplied, but I think this should work.

Insert into MergeTable (Project number, IsProjNumConverted)

Select Coalesce(x.proj_id,i.proj_id) as projID,

Case...

This should work, but you might want to run this against a copy of your table first to ensure that the results are what you are looking for.

select ptid, pat_ext_id,...

You can also just do it inline like this:

Declare @LeadingZeros Table

(

sValuevarchar(100)

)

Insert into @LeadingZeros

SELECT '000123'

UNION ALL

SELECT '00123'

UNION ALL

SELECT '0123'

UNION ALL

SELECT '123'

UNION ALL

SELECT '01020z'

UNION ALL

SELECT '0s.123'

Select...

If it's something you are going to use quite a bit, you might want to create a function.

Create FUNCTION [dbo].[DropLeadingZeros](

@iString VARCHAR(100)

) RETURNS VARCHAR(100)

AS

BEGIN

DECLARE @oStringvarchar(100)

Select...

Does anyone know how much a trip to space costs? Seems like it would be a lot more than $100,000.

I tried to import the query from the "fast" db to the "slow" one, but got the same results. I was inspired by Ninja's suggestion and ultimately I made...

Thanks for the suggestion, but unfortunately not everything is the same between the two files so I can't simply copy it over.

Nik,

We use Databridge here as well to populate a SQL database from our Unisys Mainframe.

Is the field that the mainframe guys want to delete a calculated field? If...

This is a good script. I had a use for something similar some time ago and created the sproc below with some additional parameters to limit searches.

Create Procedure...

I have found that TAB separated files seem to cause the least number of problems. Unfortunately TABs aren't always possible, if you have to work with a file...