the issue is datatypes; integers/number datatypes do not have preceeeding zeros;

i think your table dbo.ReportFinal.MedRecNO is defined as an integer;

you said it's defined as an nvarchar, but that's the only...

Ray it's easy to do, but trying to do it in TSQL is not a good implementation.

TSQL's the wrong tool for this job.

I'd say it's much better and easier to...

if you move the alter into an EXEC statement, it will work:

If Not Exists(Select column_name From information_schema.columns

Where column_name = 'InsertedDateTime'

And table_name = 'RecipEligToVendorErr')

Begin

Begin Transaction

EXEC('Alter Table RecipEligToVendorErr

Add InsertedDateTime DateTime...

some of it is your order of operations:

you are replacing this first:

replace(billtoaddress1, 'PTE I', 'PT')

replace(billtoaddress1, 'PTE II', 'PT')

replace(billtoaddress1, 'PTE III', 'PT')

so the end result is PTEII

that's not what you...

some of this may be beyond my ability to explain it, but here goes:

a TEXT or IMAGE datatype fields can store something like 2 gig of characters; it's variable...

both your tables have a column named "NAME" of the datatype TEXT:

..Name TEXT NOT NULL ,...

those data types are stored in a different way; a pointer is stored and the...

lol the redirect thread has more posts than the thread we should reply to.

it might help...the devil is in the details.

the pseudo code example we have so far doesn't give us enough to work with...if the big table has an index on the...

I think by just adding to the WHERE statement to Gianluca's fine example, you'd make sure you don't change fields where they already match, you'll prevent re-processing of the same...

get a copy of the free program SQLRecon from specialopssecurity.com[/url];

it is the most full featured pprogram I've found for discovering all the SQL servers on a network;

the documentation says it...

Once again, you guys helped me be a better programmer; I learned a lot with this thread.

converting that MTVF to an ITVF made me understand the concept better, and this...

something like this Simon;

the CHARINDEX function lets you find the position of specific strings within strings; then it is just a bit of tweaking to skip the parts you do...

the issue is data related; you are going for a diff in seconds; the max value is an integer(2147483648 or unsigned 4294967296?)

but the difference between the two dates is bigger...

you have to use a split function which changes the string @tech_list into a table function. otherwise you are trying use IN on a string which just happens to contain...

the error is related to the row size of the insert; > 8062

for example, if i have 25 columns, and they are all defined as varchar(500), 25 X 500 =...