Insert data into table

-----Original Message-----
From: Tessitura Technical Forum on behalf of Ken McSwain
Sent: Wed 12/1/2010 6:40 PM
To: Teresa Dean
Subject: Re: [Tessitura Technical Forum] Insert data into table

Hi Teresa

What I would do is:

1.Use the Import Data tool in SQLS Management Studio to import your
spreadsheet into a local table. ( I actually have a "staging" db set up to
hold temp import data like this, to try to keep impresario a bit tidier)
2.use the INSERT INTO / SELECT syntax to copy from the temp table into
t_custom_ask_amounts, like this:

INSERT INTO impresario.dbo. t_custom_ask_amounts
([customer_no],[season_no],[type],[amount])
SELECT [customer_no],[season_no],[type],[amount])
FROM staging.dbo.LT_teresas _import_table
or something like that
Ken

From: Teresa Dean
Sent: 12/1/2010 6:13:40 PM


I'm drawing a blank and need some help. I need to populate the
t_custom_ask_amounts table with data from a spreadsheet. I think there is a
much easier way besides an insert script one row at a time. I just can't
remember what I did last season to populate the table. Can someone give me a
quick and easy way to get my spreadsheet data into the table???

Teresa




This message was sent automatically to you by www.tessituranetwork.com
because you subscribed to the Tessitura Technical Forum. You may reply to
this message to post to the Technical forum or visit the site to search, read
and post to the forums. In the interest of keeping the forum posts from
becoming cluttered, we encourage you to delete previous message text from
your reply before sending. Thank you!

-----Original Message-----
From: Tessitura Technical Forum on behalf of Ken McSwain
Sent: Wed 12/1/2010 6:40 PM
To: Teresa Dean
Subject: Re: [Tessitura Technical Forum] Insert data into table

Hi Teresa

What I would do is:

1.Use the Import Data tool in SQLS Management Studio to import your
spreadsheet into a local table. ( I actually have a "staging" db set up to
hold temp import data like this, to try to keep impresario a bit tidier)
2.use the INSERT INTO / SELECT syntax to copy from the temp table into
t_custom_ask_amounts, like this:

INSERT INTO impresario.dbo. t_custom_ask_amounts
([customer_no],[season_no],[type],[amount])
SELECT [customer_no],[season_no],[type],[amount])
FROM staging.dbo.LT_teresas _import_table
or something like that
Ken

From: Teresa Dean
Sent: 12/1/2010 6:13:40 PM


I'm drawing a blank and need some help. I need to populate the
t_custom_ask_amounts table with data from a spreadsheet. I think there is a
much easier way besides an insert script one row at a time. I just can't
remember what I did last season to populate the table. Can someone give me a
quick and easy way to get my spreadsheet data into the table???

Teresa




This message was sent automatically to you by www.tessituranetwork.com
because you subscribed to the Tessitura Technical Forum. You may reply to
this message to post to the Technical forum or visit the site to search, read
and post to the forums. In the interest of keeping the forum posts from
becoming cluttered, we encourage you to delete previous message text from
your reply before sending. Thank you!