Actually, I create the linked tables on the fly. The way I handle the temporary tables is to use ADO to call stored procedures and then I have a routine that will transfer the first table returned from a dataset into whatever table you specify (the field names have to match exactly). Then I display […]
2004-03-29
Thanks guys, I do have requirement of not to Lock the table while exporting the data. Can I be able to do BCP in batches? I would like each batch to export just 1 million records instead of 10 millions at once. Any thoughts of how BCP can do this like DTS where you set […]
2004-03-29
Hmmm... Well here is a quick sample SP I just wrote that should help you with the variable usage. USE pubs GO -- First check to see if the sproc exists and if so drop it. IF EXISTS(SELECT * FROM sysobjects WHERE id = object_id('MySampleSproc')) DROP PROCEDURE MySampleSproc GO /*--------------------------------------------------------------------------------------- Name: MySampleSprocDescription: sample procedure for […]
2004-03-24
rachel,here's what i use and works just fine. follow the instructions and you shouldn't have any problems. if you have any questions feel free to ask ones.--1) create view CREATE VIEW v_BcpOutMyTableWithColumnNames ASSELECT TOP 100 PERCENT Col01, Col02, Col03... FROM ( SELECT 1 seq, 'Col01' Col01, 'Col02' Col02, 'Col03' Col03, ... UNION ALL SELECT 2 […]
2004-03-23
108 reads
I created a view that returned a record number for each sku within the group then modified your query to be based on this view and it works fine.Thanks for the suggestion =:-)
2004-03-22
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-03-22
Hi,0. Excuse my bad english (no native english speaker)1. Renaming the File http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vaobjfilesystemobject.asp Look at the methods of the object2. Sending EmailTo send an email I´m using "Email Task" at the end of the workflow of the DTS package. The information about the attachment path, email adress, subject, etc. is stored into "global variables" (using ActiveX Task […]
2004-03-17
Use Books on Line (BOL) - it is the help file when clicking help for Query Analyzer - look up "Setting Data Base Options" then scroll down to "Quoted Identifier" - might help you understand why I did what I did
2004-03-14
2004-03-13
Wow, that's really cool. It's pretty close to what I need, but I think there might be some problems. First, it's going to be used by a "human" - and if a record is deleted, it'll create a gap in the sequence which the human won't understand (or would expect to be able to fill […]
2004-03-12
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers