[dba-SQLServer] Stored proc help for a newb

jean-paul natola jnatola at hotmail.com
Thu Apr 16 16:05:07 CDT 2009


ok,  in  our app we add records that contain various pieces of data

 

there are three tables that make up the record-

 

aag00400

aag00401

aag10001

 

there is sproc  (comes builtin to the db) called dbo.taAATrxDimCodeMaint 

 

ftp://ftp.fcimail.org/IT/sproc.rtf

 

you view it here

 

now somehow (i think) i'm suppose to be utilize the sproc  to  do a mass import of records,

 

does this make sense?  

 

 

 

 

 



 
 
 
 
 
 
 
 
 
 
Jean-Paul Natola
 



 
> Date: Thu, 16 Apr 2009 13:15:05 -0700
> From: dbdoug at gmail.com
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer] Stored proc help for a newb
> 
> I'm not clear on what your problem is exactly.
> 
> Are you saying that you have SQL code that imports from Excel, and that you
> want to turn it into an SPROC, or do you have an SPROC which you can't
> figure out how to use? Can you give a bit more detail?
> 
> Doug Steele
> 
> On Thu, Apr 16, 2009 at 12:43 PM, jean-paul natola <jnatola at hotmail.com>wrote:
> 
> >
> > Thanks for the reply,
> >
> > and please excuse me if I sound ignorant or dont make any sense, but I see
> > no mention of using the SPROC , that only shows me how to get data from an
> > excle file into one table.
> >
> >
> >
> > The problem I have is that in teh DB there are 3 tables that are used in
> > creating the record, so this is where I'm getting lost
> >
> >
> >
> > TIA
> >
> > > Date: Thu, 16 Apr 2009 10:51:06 -0700
> > > From: dbdoug at gmail.com
> > > To: dba-sqlserver at databaseadvisors.com
> > > Subject: Re: [dba-SQLServer] Stored proc help for a newb
> > >
> > > Google is your friend.
> > >
> > > http://support.microsoft.com/kb/321686
> > >
> > > The section under 'Use Distributed Queries' shows you how to do it in one
> > > line of SQL.
> > >
> > > Doug Steele
> > >
> > >
> > > > Hi all,
> > > >
> > > > I'm having a problem that I hope can help me out- there is a stored
> > > > procedure in a database (took me a while just to figure where to locate
> > > > stored procs) now that I have found it - i'm trying to import records
> > from
> > > > an excel file using the stored proc (if thats even possible) i'm
> > totally new
> > > > as you can see -
> > > >
> > > > can someone help me shed some light on this
> > > >
> > > > GREATLY appreciated
> > > >
> > > >
> > > _______________________________________________
> > > dba-SQLServer mailing list
> > > dba-SQLServer at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > > http://www.databaseadvisors.com
> > >
> >
> > _________________________________________________________________
> > Windows Live™: Life without walls.
> > http://windowslive.com/explore?ocid=TXT_TAGLM_WL_allup_1b_explore_042009
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 

_________________________________________________________________
Windows Live™: Keep your life in sync.
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_allup_1a_explore_042009


More information about the dba-SQLServer mailing list