ckmoied ,

Sergiy is correct. Please do use INSERT statements. If you should find a need to use Enterprise Manager for appending new rows, you should be able to quickly write...

Cherie_Bonnici,

Sergiy is correct. You will have to explicitly convert DateTime to Varchar when concatenating values in a PRINT statement. For more details regarding "CAST/CONVERT' see the following link: http://msdn2.microsoft.com/en-us/library/aa226054(SQL.80).aspx

Quick Example:

declare...

Verl,

This is the implementation that I can think of right away and may not take much time to produce and even create a template, assuming that you can use table...

Duplicate Posting......

See http://www.sqlservercentral.com/Forums/Topic402003-8-1.aspx

Regards,

Wameng Vang

goodguy,

The following implementation assumes that the foreign keys have the same column names in the respective tables. If should find that the following example does not work, please double check...

Looks like someone read the documentation.... awesome... LOLz....

Thanks

In response to the original post,

From my past experiences, this is the closest example I can think of. The example uses SQL_Variant_Property() System MetaData Function, which should be present in both...

Carlos,

There are a number of ways to accomplish this. The implementation will depend on the requirements.

Options:

1. Create a DTS/SSIS package to extract, transform, and load the data into staging tables.

2....

virgilash ,

Please post the structure of the two views, and maybe even the table structures, along with the indexes, this way we can...

Yeap...

Almost the same logic, I chose my way simply so that I can explain, to the original post, the steps, mathematics and logic.

Regards,

Here's a similar solution to Lynn's:

CREATE FUNCTION dbo.fn_BRound (

    @TestValue decimal(38,12),

    @pos int

)

RETURNS money

as begin

    return

round(@TestValue,@pos,