Click here to Skip to main content
15,867,756 members
Home / Discussions / Database
   

Database

 
GeneralRe: Getting started with SSIS Help Pin
Rupert Todd19-Dec-07 10:44
Rupert Todd19-Dec-07 10:44 
GeneralParent not present in GetChanges() Pin
goldoche19-Dec-07 6:43
goldoche19-Dec-07 6:43 
GeneralRe: Parent not present in GetChanges() Pin
Giorgi Dalakishvili19-Dec-07 6:54
mentorGiorgi Dalakishvili19-Dec-07 6:54 
GeneralRe: Parent not present in GetChanges() Pin
goldoche19-Dec-07 11:14
goldoche19-Dec-07 11:14 
GeneralRe: Parent not present in GetChanges() Pin
Giorgi Dalakishvili19-Dec-07 23:39
mentorGiorgi Dalakishvili19-Dec-07 23:39 
GeneralGenerating script in MS Access Pin
Lijo Rajan19-Dec-07 6:13
Lijo Rajan19-Dec-07 6:13 
GeneralRe: Generating script in MS Access Pin
pmarfleet19-Dec-07 9:14
pmarfleet19-Dec-07 9:14 
Generalsql query Pin
niki_nilu19-Dec-07 0:33
niki_nilu19-Dec-07 0:33 
hi i have one table

-------------------------------------------------------------------------
Analyst security Stock User Assign Status Updated Updated
code(pk) code Name Id Date Code By Date
-------------------------------------------------------------------------
1 500103 HDFC PatelAmi Jul 20 2007 A - - 2 500410 ATC Ltd Shah Vis nov 01 2007 A - -
-------------------------------------------------------------------------

In my Project my first query is

update tAnalystAssignHistory set StatusCode ='C'where
UserId ='PatelAmi' and StockName='HDFC LTD'

in this query status code will update.

i want 2nd query is like ===
I want to INSERT same 1st record in new row But i didnt have any control for inserting record .Only i have StockName,UserId,UpdatedBy,UpdatedDate
that valus i will be insert other are same to same 1st record.so how can i write it.
pls help me
its urgent.
Gayatri

GeneralRe: sql query Pin
niki_nilu19-Dec-07 0:49
niki_nilu19-Dec-07 0:49 
GeneralRe: sql query Pin
niki_nilu19-Dec-07 17:31
niki_nilu19-Dec-07 17:31 
Generalplz tell me how Pin
wasimsharp18-Dec-07 23:26
wasimsharp18-Dec-07 23:26 
GeneralRe: plz tell me how Pin
pmarfleet19-Dec-07 0:29
pmarfleet19-Dec-07 0:29 
GeneralRe: plz tell me how Pin
Paul Conrad19-Dec-07 16:36
professionalPaul Conrad19-Dec-07 16:36 
QuestionC#:Password encryption algorithm Pin
kssknov18-Dec-07 21:04
kssknov18-Dec-07 21:04 
GeneralWrong forum Pin
pmarfleet18-Dec-07 21:23
pmarfleet18-Dec-07 21:23 
GeneralUPDATE depends on UPDATE, the two UPDATEs come together Pin
followait18-Dec-07 17:39
followait18-Dec-07 17:39 
GeneralRe: UPDATE depends on UPDATE, the two UPDATEs come together Pin
SimulationofSai18-Dec-07 20:09
SimulationofSai18-Dec-07 20:09 
GeneralRe: UPDATE depends on UPDATE, the two UPDATEs come together Pin
GuyThiebaut18-Dec-07 22:41
professionalGuyThiebaut18-Dec-07 22:41 
Generalselect year/month syntax (for contracts up for renewal in X month) Pin
tellytub18-Dec-07 16:09
tellytub18-Dec-07 16:09 
GeneralRe: select year/month syntax (for contracts up for renewal in X month) Pin
Giri K18-Dec-07 17:11
Giri K18-Dec-07 17:11 
GeneralRe: select year/month syntax (for contracts up for renewal in X month) Pin
tellytub18-Dec-07 20:15
tellytub18-Dec-07 20:15 
GeneralRe: select year/month syntax (for contracts up for renewal in X month) Pin
Giri K19-Dec-07 11:55
Giri K19-Dec-07 11:55 
Questionjoins of two tables +search Pin
regin18-Dec-07 1:42
regin18-Dec-07 1:42 
GeneralRe: joins of two tables +search Pin
pmarfleet18-Dec-07 1:59
pmarfleet18-Dec-07 1:59 
GeneralRe: joins of two tables +search Pin
andyharman18-Dec-07 3:47
professionalandyharman18-Dec-07 3:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.