Click here to Skip to main content
15,942,847 members
Home / Discussions / Database
   

Database

 
AnswerRe: Deploying SSIS Package and calling it from Console application Pin
unclepaul15-May-13 8:47
unclepaul15-May-13 8:47 
AnswerRe: Deploying SSIS Package and calling it from Console application Pin
Mycroft Holmes15-May-13 18:00
professionalMycroft Holmes15-May-13 18:00 
QuestionCreate trigger that executes on date Pin
damokk15-May-13 3:54
damokk15-May-13 3:54 
AnswerRe: Create trigger that executes on date Pin
Corporal Agarn15-May-13 6:31
professionalCorporal Agarn15-May-13 6:31 
AnswerRe: Create trigger that executes on date Pin
Mycroft Holmes15-May-13 17:55
professionalMycroft Holmes15-May-13 17:55 
GeneralRe: Create trigger that executes on date Pin
damokk15-May-13 23:06
damokk15-May-13 23:06 
GeneralRe: Create trigger that executes on date Pin
damokk15-May-13 23:08
damokk15-May-13 23:08 
GeneralRe: Create trigger that executes on date Pin
Mycroft Holmes15-May-13 23:33
professionalMycroft Holmes15-May-13 23:33 
Create a stored procedure that does the following
Get the expiring records
insert the relevant data into the target table.

In SSMS create a Job that calls the stored proc
schedule the job to run every day
Never underestimate the power of human stupidity
RAH

GeneralRe: Create trigger that executes on date Pin
damokk15-May-13 23:47
damokk15-May-13 23:47 
QuestionRegarding SSIS (SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel" failed with error code 0xC0202009.) Pin
Ravikiran72p14-May-13 21:09
Ravikiran72p14-May-13 21:09 
AnswerRe: Regarding SSIS (SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel" failed with error code 0xC0202009.) Pin
Mycroft Holmes14-May-13 23:24
professionalMycroft Holmes14-May-13 23:24 
QuestionRegarding DB2 Rows to Column String Concatenation Pin
SenthilKumar-8313-May-13 5:05
SenthilKumar-8313-May-13 5:05 
QuestionHow to Update this request Balance Column Pin
Robymon13-May-13 1:49
Robymon13-May-13 1:49 
AnswerRe: How to Update this request Balance Column Pin
Blue_Boy13-May-13 4:14
Blue_Boy13-May-13 4:14 
AnswerRe: How to Update this request Balance Column Pin
gvprabu13-May-13 5:36
gvprabu13-May-13 5:36 
AnswerRe: How to Update this request Balance Column Pin
Jörgen Andersson13-May-13 23:53
professionalJörgen Andersson13-May-13 23:53 
QuestionMigration process. Pin
nagesh2113-May-13 0:00
nagesh2113-May-13 0:00 
QuestionNeed your opinion on querying data for presentation on winforms / web page and for reports Pin
Nayan Ambaliya12-May-13 12:53
Nayan Ambaliya12-May-13 12:53 
AnswerRe: Need your opinion on querying data for presentation on winforms / web page and for reports Pin
Mycroft Holmes12-May-13 15:05
professionalMycroft Holmes12-May-13 15:05 
GeneralRe: Need your opinion on querying data for presentation on winforms / web page and for reports Pin
Nayan Ambaliya12-May-13 15:10
Nayan Ambaliya12-May-13 15:10 
QuestionCannot insert the value NULL into column Pin
Member 991209112-May-13 12:33
Member 991209112-May-13 12:33 
AnswerRe: Cannot insert the value NULL into column Pin
Mycroft Holmes12-May-13 15:02
professionalMycroft Holmes12-May-13 15:02 
AnswerRe: Cannot insert the value NULL into column Pin
Bikash Prakash Dash13-May-13 19:27
Bikash Prakash Dash13-May-13 19:27 
GeneralRe: Cannot insert the value NULL into column Pin
Mycroft Holmes13-May-13 20:55
professionalMycroft Holmes13-May-13 20:55 
QuestionComparing 2 values in same column SQL (C#) Pin
Member 991209111-May-13 5:56
Member 991209111-May-13 5:56 

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.