Viewing 15 posts - 511 through 525 (of 3,232 total)
Typically, you could create a temp table and run an INSERT INTO <tempTable> EXEC <YourProc>, but having to account for dynamic columns makes this approach not feasable.
You may...
April 23, 2010 at 10:39 am
What is the scope of the insert/update/deletes? Do they all impact one single row or mutiple rows in the destination tables?
April 23, 2010 at 10:27 am
You need to type cast your expression to a date datatype:
(DT_DBTIMESTAMP)(SUBSTRING(DateValue,1,4) + "-" + (SUBSTRING(DateValue,6,2) + "-" + SUBSTRING(DateValue,9,2) + " " + SUBSTRING(DateValue,12,2) + ":" + SUBSTRING(DateValue,15,2) + ":"...
April 22, 2010 at 2:03 pm
Yes, it is possible; but I too would like to better understand your requirement before teaching you something that may not be the best approach.
April 22, 2010 at 1:31 pm
I'm with Steve here. This is a change management issue. I would develop a process to deliver the SP changes to your client DBs.
April 22, 2010 at 1:02 pm
This may be a candidate for Notification Services. You can have your VB or C# app 'subscribe' to a recordset and it will get a notification when that recordset...
April 22, 2010 at 12:53 pm
Tom.Thomson (4/20/2010)
John Rowan (4/20/2010)
multiplyfruitfully or arithmetically?
fruitfully
April 21, 2010 at 11:51 am
In addition to what Brian and Elliot have said, here's Microsoft's opinion on backup security:
The best practice for protecting backups is to store backup tapes in a secure location or...
April 20, 2010 at 11:36 am
Can you post the table DDL for the 2 tables in question as well as some sample data? I have some recommendations for how to do that in the...
April 19, 2010 at 3:22 pm
Greg Edwards-268690 (4/19/2010)
Lynn Pettis (4/19/2010)
Grant Fritchey (4/19/2010)
April 19, 2010 at 12:49 pm
Viewing 15 posts - 511 through 525 (of 3,232 total)