[dba-SQLServer] Stored proc help for a newb

i don't know why, but I can't see anything on the file you posted.
-Francisco
http://sqlthis.blogspot.com | Tsql and More...


On Thu, Apr 16, 2009 at 2:05 PM, jean-paul natola <jnatola at hotmail.com>wrote:

>
> 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
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>