Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
|
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old October 3rd, 2006, 02:36 PM
Registered User
 
Join Date: Oct 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default insertor update with currend date stamp

i have to insert the data into table if not exit or udate if price are diffrent using DDQ,
LIKE source
book price
aa 4
bb 5
cc 8

dest

book price currenttimesatmp
aa 3
bb 5


o/p should be
book price currenttimesatamp
aa 4
bb 5
cc 8


currenttime stamp require i done this whit satging table but not work out help me

 
Old October 23rd, 2006, 08:10 AM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

Default your column value to 'CURRENT_TIMESTAMP' or default column to getdate() and when reporting the column value format date as you like.

Jaime E. Maccou





Similar Threads
Thread Thread Starter Forum Replies Last Post
store insert/update date/time stamp in sql2k db alexdcosta ASP.NET 2.0 Basics 0 June 22nd, 2006 05:44 AM
Inserting Time Stamp into SQL testsubject ADO.NET 1 May 19th, 2006 07:14 AM
Update Date Field desireemm Access 1 October 16th, 2005 12:25 AM
Date/Time Stamp on Reports dillig BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 1 August 11th, 2004 08:21 AM
Date from timedate stamp badgolfer Access 5 November 19th, 2003 07:59 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.