why not use a function, instead of a stored procedure, and have the function return a @Table?

then you'd have what you are after...

yes, but you have to be able to identify what has not been changed.

it most likely will NOT be faster, but should avoid locking the entire table for the updates

something...

not built in , no; typically formatting is left for the presentation layer, like vb;

you can do something pretty close:

declare @val decimal (12,6)

set @val = 0.43365

select convert(varchar,convert(decimal(5,2),@val* 100.0)) + '%'

--43.37%

once I've connected with Object Explorer, I can expand the server name, open the Replication Folder, and see everything I've got in the two folders there, "local Publications" and "Local...

sELECT CASE WHEN first_Name

Like 'MR.%'THEN

Right(First_Name,Len(First_Name)-4)

ELSE

Right(First_Name,Len(First_Name)-3)

END nn

FROM tblCust

WHERE Len(First_Name) >= 4

the only other solution i have used was creating an .NET RTF to HTML converter that you could use in reporting services, so it does a best guess at converting...never...

i just had a very similar question in a different thread...it was to scan all columns in a table where for all three search terms occurs

basically, i just did a...

Narayana Vyas Kondreddi wrote a really good proc over at http://vyaskn.tripod.com called sp_generate_inserts, which dumps the table's contents out to INSERT statements.

i use it all the time and have used...

i don't think replication is a single setting...you can have different replications going for each database...and i think you can have different replication types going on even a single database...you...

just a syntax error...you left out the FROM! if you are going to update one table from another, you have to include that table in the from statement:

UPDATE HouseKeeping

...

sorry if my post bothered you dev, we get a lot of new posters who ask for help on their homework, without putting any effort in themselves.

For your issue, I've...

interesting...

there must be a business reason why you are going thru each file, instead of just using the last backup...You basically need the history of changes(if any) between backups, right?

this...

your example shows 4 columns, none of which intuitively seem to be the PK...

Is the PK of each table ALWAYS an identity field, or is always the first column of...

pretty much every db reporting tool out there...from freebies written in Delphi , to crystal reports, etc, all have an RTF object that you just point to the field in...

typically, you might pass a comma delimited string to the procedure, and the proc then uses one of the many SPLIT functions in the Scripts section here on SSC to...