Data source for Time Dimension?

Hi;

I have been trying to create Time Dimension for one of the column in the table i.e. EntryDate and I am unable to connect the time dimension which I create using the Wizard using the 2nd option which is Without using data source. It created a dimension but it is not connected to any data source and when I process it gives me error, data source is not specified.

I am very new to Analysis service, I am using SQL Server 2005. I want to create a report where I can show my data by month, by year depending upon the EntryDate column of a table.

Thanks

Have you tried the adventure works dw data base that is part of the samples that you can install with SQL Server 2005 and SSAS2005? In that database you have several dimension tables and a time dimension table.

If you would like to test your skills in building dimensions with a data source I recommend this database.

Regards

Thomas Ivarsson

Data Relationship & SQL data adapter

Hi

I was trying to fill SqlDataAdapter from a " View" with inner join of two tables. When I call the update method of the data adapter it is failing as it cannot generate automatic SQL for multiple tables in my view. Writing own SQL script for update is one way out but it is tedious process.

Is there any other work around to do this?

Can I create a view of two joined data sets on some condition (Just like creating a view in database) in the memory.

Cheers,

Sudath Attanayake.One option you might look into which is extremely common among database programmers, is to only do updates through stored procedures. One of the main reason is security. If you disalow any updates to hapen to the tables or views, then you can control who can update what by simply controlling the permission to execute the individual stored procs, or special case what data can be updated.

Data Recovery Book

Hi!
I am glad to introduce World's First Book on Professional Data
Recovery Programming. Book also Includes a FREE CD, which contains
complete Source Codes of all the software/Programs described within
the book and may interesting tools
You can see the contents of the book and order Online on following
link:
http://www.DataDoctor.biz/author.htm
The Details of the Book are as follows:
Title of the book: "Data Recovery with & without Programming"
Author of the book: Tarun Tyagi
Publishers of the book: BPB Publications, New Delhi, India
Number of Pages: 540
Size: (9.5 x 7.5 x 1.0) Inches
ISBN: 81-7656-922-4
Price: $ 69.00 (Including Shipping Charge, Cost of
Book and Other expenses)
Enjoy Reading!!
Regards,
Tarun Tyagi
J-110, Patel Nagar - 1,
Ghaziabad (U.P.), India -201001
Cell: (+91)9868337762
http://www.DataDoctor.Biz
Your page doesn't render at all in Firefox. You might want to check that
out.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Author Tarun Tyagi" <tyagi_st@.yahoo.com> wrote in message
news:a921f5f5.0412010120.1b976a90@.posting.google.c om...
> Hi!
> I am glad to introduce World's First Book on Professional Data
> Recovery Programming. Book also Includes a FREE CD, which contains
> complete Source Codes of all the software/Programs described within
> the book and may interesting tools
> You can see the contents of the book and order Online on following
> link:
> http://www.DataDoctor.biz/author.htm
> The Details of the Book are as follows:
> Title of the book: "Data Recovery with & without Programming"
> Author of the book: Tarun Tyagi
> Publishers of the book: BPB Publications, New Delhi, India
> Number of Pages: 540
> Size: (9.5 x 7.5 x 1.0) Inches
> ISBN: 81-7656-922-4
> Price: $ 69.00 (Including Shipping Charge, Cost of
> Book and Other expenses)
> Enjoy Reading!!
> Regards,
> Tarun Tyagi
> J-110, Patel Nagar - 1,
> Ghaziabad (U.P.), India -201001
> Cell: (+91)9868337762
> http://www.DataDoctor.Biz

Data Recovery Book

Hi!
I am glad to introduce World's First Book on Professional Data
Recovery Programming. Book also Includes a FREE CD, which contains
complete Source Codes of all the software/Programs described within
the book and may interesting tools
You can see the contents of the book and order Online on following
link:
http://www.DataDoctor.biz/author.htm
The Details of the Book are as follows:
Title of the book: "Data Recovery with & without Programming"
Author of the book: Tarun Tyagi
Publishers of the book: BPB Publications, New Delhi, India
Number of Pages: 540
Size: (9.5 x 7.5 x 1.0) Inches
ISBN: 81-7656-922-4
Price: $ 69.00 (Including Shipping Charge, Cost of
Book and Other expenses)
Enjoy Reading!!
Regards,
Tarun Tyagi
J-110, Patel Nagar - 1,
Ghaziabad (U.P.), India -201001
Cell: (+91)9868337762
http://www.DataDoctor.BizYour page doesn't render at all in Firefox. You might want to check that
out.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Author Tarun Tyagi" <tyagi_st@.yahoo.com> wrote in message
news:a921f5f5.0412010120.1b976a90@.posting.google.com...
> Hi!
> I am glad to introduce World's First Book on Professional Data
> Recovery Programming. Book also Includes a FREE CD, which contains
> complete Source Codes of all the software/Programs described within
> the book and may interesting tools
> You can see the contents of the book and order Online on following
> link:
> http://www.DataDoctor.biz/author.htm
> The Details of the Book are as follows:
> Title of the book: "Data Recovery with & without Programming"
> Author of the book: Tarun Tyagi
> Publishers of the book: BPB Publications, New Delhi, India
> Number of Pages: 540
> Size: (9.5 x 7.5 x 1.0) Inches
> ISBN: 81-7656-922-4
> Price: $ 69.00 (Including Shipping Charge, Cost of
> Book and Other expenses)
> Enjoy Reading!!
> Regards,
> Tarun Tyagi
> J-110, Patel Nagar - 1,
> Ghaziabad (U.P.), India -201001
> Cell: (+91)9868337762
> http://www.DataDoctor.Biz

Data Normalization - Best approach?

Hi!

I wonder what would be the best (at to be honest - how to do it at all) to perform data normalization with SSIS. The scenario is as follows:

I got plain table with several columns in it.Some of columns can be copied straight into destination tableSome columns (String) should be lookup in another table to get ID
On success just replace string with IDOn fail - create new record in lookup table and return newly created ID

Thanks for any ideas and maybe short samples

Anrijs Vitolins

Yeah you can do all of this. This link will get you started regarding the lookup and putting new records into the lookup table - I recommend method 2: http://www.sqlis.com/default.aspx?311

You'll need a MULTICAST transform in there at some point as well by the sounds of it.

-Jamie

data mixed up after update

Hi!

I have quite strange problem, that I haven't seen before.

When I use update command:

UPDATE categorys SET banner_valid= '0', section_id= '1', main_cat_default= '0', banner= '', b_link= '', external_text= 'Nākotnes parks ', in_frontpage= '1', name = '100. pants' WHERE (id = 130)

Then the field EXTERNAL_TEXT should have value Nākotnes parks but instead of this it makes it Nakotnes parks.

I changed collation to Latvian and this did not work.

But!!! When I open Enterprise manager and just type in Nākotnes parks and save it then it is ok, but it does not work with Update/add script

Any help or ideas?

I would try changing Asp.net to UTF16, maybe Latvian is only UTF 16. That maybe the reason it works in Enterprise manager and not in your application. SQL Server Unicode is multibyte UTF16 while .NET you have the option of using singlebyte UTF8. Hope this helps.

Kind regards,

Gift Peddie

|||You need to tell SQL Server that you're submitting Unicode text by giving your string the N prefix:
UPDATE categorys
SET banner_valid= '0',section_id= '1', main_cat_default= '0', banner= '', b_link= '',external_text= N'Nākotnes parks ', in_frontpage= '1', name = '100.pants'
WHERE id = 130
|||

SQL Server Unicode is multibyte UTF16

Actually it's not. It's UCS2, which is a fixed-length encoding.

you have the option of using singlebyte UTF8

UTF-8 is a variable-length encoding, so a given character encoded with UTF-8 *may* only require a single byte, or it may require two bytes, or four. It can represent anything that you can store in UCS2 just fine.

Data migration in MSDE

Hi
I have a set of distributors who use MSDE as their
database and have VB as the front end. I am planning to
have a second version to my application.
During this upgrade new tables are being added, old
tables modified and some tables modified.
What would be the best approach for this migration.
Rgds
Kudla
hi Kudla,
"Kudla" <johnvellaip@.yahoo.com> ha scritto nel messaggio
news:135201c4a13d$18f54260$a401280a@.phx.gbl
> Hi
> I have a set of distributors who use MSDE as their
> database and have VB as the front end. I am planning to
> have a second version to my application.
> During this upgrade new tables are being added, old
> tables modified and some tables modified.
> What would be the best approach for this migration.
in order to install both a database from scratch, or updating existing ones,
I do personally use another companion (still VB6, at the moment) application
provided with our main apps..
this other application, via SQLDMO (but you can use whatever access method
of your choice like ADO, Ado.Net, ..) will create/update the database(s)
from a reserved defintion file described like:
[Database]
Name=xxx
DataName=logical_name|physical_name
DataNameN=logical_name|physical_name ; for additional .Ndf files
LogTo=logical_name|physical_name
LogToN=logical_name|physical_name ; for additional .Ldf files
other key to specify additional settings
each database is described in it's structure by another reserved file which
list all actions, .sql DDL files, BCP to be executed, like
<BOF>
SQL=\Tables\MasterTables.sql
'which is a T-SQL DDL file including CREATE TABLE statements
SQL=\Tables\otherTB.sql
SQL=\Views\Views.sql
SQL=\SP\StoredProcedure.sql
.....
SQL=\general\CreateLogins.sql
SQL=\general\Grant.sql
SQL=\general\Deny.sql
.....
SQL=\Populate\TableXXX.sql
'which is a T-SQL INSERT INTO file to load tables
....
BCPIN=\PopulateBCP\tableYYY.txt|table_name|
'which performs a BCP IN bulk load
....
EXEC=INSERT INTO .....
EXEC=UPDATE ...
'which are T-SQL statements to be directly performed
....
<EOF>
personally I based this app on SQLDMO... the app will parse the file, read
references to the described files (\Tables\MasterTables.sql) and execute
it's contained statements or perform the appropriate task based on the
action prefix..
this app takes command line parameters in order to upgrade existing schema
too, to subsequent schema changes stored in version folders like
\00000001\
\00000002\
\0000000n\
the migration path will then generate the new objects executing all listed
and required DDL scripts and perform migration via standard INSERT
statements, or first provide BCP out with successive BCP in, or generate
INSERT INTO DML scripts for specific tables to be later executed...
Red-Gate now provides a new product that should be able to perform the same
task... have a look at http://www.red-gate.com/sql/sql_packager.htm
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Data Migration - Insert Script / Fresh install

Hi

I have some tables in my SQL Server 2005 database. I need to create insert scripts for them. Since these tables contain the CLOB and BLOB values and the number of records is huge, I need to devise a way to install this table data on any new database(Assuming the new database is created and the table structure exists) .Can some one suggest me how I can do this ?

DTS or SSIS is out of question because least manual interference is required.

Thanks & Regards
ImtiazYou could use BCP to export the data into text/binary files and then import it back. This is the most efficient way. Generating insert statements is not cumbersome (there are some 3rd party tools that does this). But the files will still be huge and difficult to manage.

Data in table is deleted

Hi!
I have a problem with table in a SQL Server 2000 box. It seems like the
table is truncated from time to time! I don't know why and it has just
started occuring, but it happens maybe once a week now.
Is there any way to monitor if a delete statement occurs on just that table?
Is it possible in Profiler to monitors just action against one table?
Any hint or tips would be greatly appreciated!!
regards
Fredrik
Yes you can have profiler monitor a single table... Set the table in the
filter clause... Delete is not the same as truncate however, so watch for
both...(Delete will run a trigger, if one exists, and truncate does not.)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fredrik" <Fredrik@.discussions.microsoft.com> wrote in message
news:7631AE53-49D2-4504-8A87-6FB5C61FB517@.microsoft.com...
> Hi!
> I have a problem with table in a SQL Server 2000 box. It seems like the
> table is truncated from time to time! I don't know why and it has just
> started occuring, but it happens maybe once a week now.
> Is there any way to monitor if a delete statement occurs on just that
table?
> Is it possible in Profiler to monitors just action against one table?
> Any hint or tips would be greatly appreciated!!
> regards
> Fredrik

Data Import

Hi
I am importing data into a column and want to change all the values to read
in percentages i.e. 15 should become 0.15
How do I do this during an import? or how do I update the column afterwards?How are you performing the import? If you use DTS you should be able to
enter the expression in the source query of a Transform Data task.
The UPDATE is straightforward:
UPDATE YourTable SET col = col / 100
David Portas
SQL Server MVP
--|||Hi,
At the time of import data from table ,divide by that column with 100 and
then import the value,I think this will solve your problem.
for ex:
select price/100 as 'price' from titles
Regards
Arindam
"Jaco Wessels" wrote:

> Hi
> I am importing data into a column and want to change all the values to rea
d
> in percentages i.e. 15 should become 0.15
> How do I do this during an import? or how do I update the column afterward
s?
>
>|||use * .01 rather than /100 just in case you have a zero entry which may caus
e
a divide by zero error.
regards,
Mark Baekdal
http://www.dbghost.com
http://www.innovartis.co.uk
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change
management for SQL Server
"Jaco Wessels" wrote:

> Hi
> I am importing data into a column and want to change all the values to rea
d
> in percentages i.e. 15 should become 0.15
> How do I do this during an import? or how do I update the column afterward
s?
>
>

data from multiple tables

Hi
I have 6 databases and each has a table sys_items. My client asked me
to create a list of all the unique items from these tables from all
the databases.
select a. item, b, item, c.item, d.item, e.item, f.item
from a, b, c, d, e,f
there are a few common items in each table. so it means i want all the
common and unique items in my list.
any idea? suggestions?
please let me know
thanks
Ajit
Try:
select
a.item
from
DatabaseA.dbo.sys_items a
join DatabaseB.dbo.sys_items b on b.Item = a.Item
join DatabaseC.dbo.sys_items c on c.Item = a.Item
join DatabaseD.dbo.sys_items d on d.Item = a.Item
join DatabaseE.dbo.sys_items e on e.Item = a.Item
join DatabaseF.dbo.sys_items f on f.Item = a.Item
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Ajit - The Scorpio" <ajitscorpio@.gmail.com> wrote in message
news:1184705626.221486.182570@.e16g2000pri.googlegr oups.com...
Hi
I have 6 databases and each has a table sys_items. My client asked me
to create a list of all the unique items from these tables from all
the databases.
select a. item, b, item, c.item, d.item, e.item, f.item
from a, b, c, d, e,f
there are a few common items in each table. so it means i want all the
common and unique items in my list.
any idea? suggestions?
please let me know
thanks
Ajit
|||I think he wants to find the items that are common to all DB's.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:GKednS7PK8RAsADbnZ2dnUVZ8sKlnZ2d@.giganews.com ...
"Ajit - The Scorpio" <ajitscorpio@.gmail.com> wrote in message
news:1184705626.221486.182570@.e16g2000pri.googlegr oups.com...
> Hi
> I have 6 databases and each has a table sys_items. My client asked me
> to create a list of all the unique items from these tables from all
> the databases.
> select a. item, b, item, c.item, d.item, e.item, f.item
> from a, b, c, d, e,f
> there are a few common items in each table. so it means i want all the
> common and unique items in my list.
>
SELECT item FROM a.dbo.tbl UNION
SELECT item FROM b.dbo.tbl UNION
SELECT item FROM c.dbo.tbl UNION
SELECT item FROM d.dbo.tbl UNION
SELECT item FROM e.dbo.tbl UNION
SELECT item FROM f.dbo.tbl ;
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||Thanks guys.. I tried Union and it worked...

data from multiple tables

Hi
I have 6 databases and each has a table sys_items. My client asked me
to create a list of all the unique items from these tables from all
the databases.
select a. item, b, item, c.item, d.item, e.item, f.item
from a, b, c, d, e,f
there are a few common items in each table. so it means i want all the
common and unique items in my list.
any idea' suggestions'
please let me know
thanks
Ajit"Ajit - The Scorpio" <ajitscorpio@.gmail.com> wrote in message
news:1184705626.221486.182570@.e16g2000pri.googlegroups.com...
> Hi
> I have 6 databases and each has a table sys_items. My client asked me
> to create a list of all the unique items from these tables from all
> the databases.
> select a. item, b, item, c.item, d.item, e.item, f.item
> from a, b, c, d, e,f
> there are a few common items in each table. so it means i want all the
> common and unique items in my list.
>
SELECT item FROM a.dbo.tbl UNION
SELECT item FROM b.dbo.tbl UNION
SELECT item FROM c.dbo.tbl UNION
SELECT item FROM d.dbo.tbl UNION
SELECT item FROM e.dbo.tbl UNION
SELECT item FROM f.dbo.tbl ;
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Try:
select
a.item
from
DatabaseA.dbo.sys_items a
join DatabaseB.dbo.sys_items b on b.Item = a.Item
join DatabaseC.dbo.sys_items c on c.Item = a.Item
join DatabaseD.dbo.sys_items d on d.Item = a.Item
join DatabaseE.dbo.sys_items e on e.Item = a.Item
join DatabaseF.dbo.sys_items f on f.Item = a.Item
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Ajit - The Scorpio" <ajitscorpio@.gmail.com> wrote in message
news:1184705626.221486.182570@.e16g2000pri.googlegroups.com...
Hi
I have 6 databases and each has a table sys_items. My client asked me
to create a list of all the unique items from these tables from all
the databases.
select a. item, b, item, c.item, d.item, e.item, f.item
from a, b, c, d, e,f
there are a few common items in each table. so it means i want all the
common and unique items in my list.
any idea' suggestions'
please let me know
thanks
Ajit|||I think he wants to find the items that are common to all DB's.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:GKednS7PK8RAsADbnZ2dnUVZ8sKlnZ2d@.gi
ganews.com...
"Ajit - The Scorpio" <ajitscorpio@.gmail.com> wrote in message
news:1184705626.221486.182570@.e16g2000pri.googlegroups.com...
> Hi
> I have 6 databases and each has a table sys_items. My client asked me
> to create a list of all the unique items from these tables from all
> the databases.
> select a. item, b, item, c.item, d.item, e.item, f.item
> from a, b, c, d, e,f
> there are a few common items in each table. so it means i want all the
> common and unique items in my list.
>
SELECT item FROM a.dbo.tbl UNION
SELECT item FROM b.dbo.tbl UNION
SELECT item FROM c.dbo.tbl UNION
SELECT item FROM d.dbo.tbl UNION
SELECT item FROM e.dbo.tbl UNION
SELECT item FROM f.dbo.tbl ;
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Thanks guys.. I tried Union and it worked...

data from multiple databases

Hi
I have 6 databases and each has sys_items table. my client ask me to
create an Excel file with all the unique items from all these
databases.
e.g. get all the items from database1.sys_items then merge all the
unique items from database2.sys_items and so on
i hope you guys are getting my point.
Please advice
thanks
Ajit
I am trying to create a sql query and i tried to explain giving an
example. i.e. get all items from database1.sys_items and then get all
unique items from other databases with same table name.
i dont have any sql query at the moment and that is my question in
this post.
i am not getting any error as i dont have anything to execute at this
moment.
Thanks
Ajit
>
>
>
>
> Replied in the previous thread.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> -- Hide quoted text -
> - Show quoted text -

data from multiple databases

Hi
I have 6 databases and each has sys_items table. my client ask me to
create an Excel file with all the unique items from all these
databases.
e.g. get all the items from database1.sys_items then merge all the
unique items from database2.sys_items and so on
i hope you guys are getting my point.
Please advice
thanks
I answered this yesterday in this same newsgroup.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Ajit - The Scorpio" <ajitscorpio@.gmail.com> wrote in message
news:1184780384.310317.296780@.m37g2000prh.googlegr oups.com...
Hi
I have 6 databases and each has sys_items table. my client ask me to
create an Excel file with all the unique items from all these
databases.
e.g. get all the items from database1.sys_items then merge all the
unique items from database2.sys_items and so on
i hope you guys are getting my point.
Please advice
thanks
|||On Wed, 18 Jul 2007 15:02:37 -0400, "Tom Moreau"
<tom@.dont.spam.me.cips.ca> wrote:

>I answered this yesterday in this same newsgroup.
I think he is using Google Groups. When I checked a few minutes ago
nothing new appears there in .programming since mid-day yesterday.
Roy Harvey
Beacon Falls, CT

data from multiple databases

Hi
I have 6 databases and each has sys_items table. my client ask me to
create an Excel file with all the unique items from all these
databases.
e.g. get all the items from database1.sys_items then merge all the
unique items from database2.sys_items and so on
i hope you guys are getting my point.
Please advice
thanks
Ajit"Ajit - The Scorpio" <ajitscorpio@.gmail.com> wrote in message
news:1184706525.529792.94420@.o11g2000prd.googlegroups.com...
> Hi
> I have 6 databases and each has sys_items table. my client ask me to
> create an Excel file with all the unique items from all these
> databases.
> e.g. get all the items from database1.sys_items then merge all the
> unique items from database2.sys_items and so on
> i hope you guys are getting my point.
> Please advice
> thanks
> Ajit
>
Replied in the previous thread.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||I am trying to create a sql query and i tried to explain giving an
example. i.e. get all items from database1.sys_items and then get all
unique items from other databases with same table name.
i dont have any sql query at the moment and that is my question in
this post.
i am not getting any error as i dont have anything to execute at this
moment.
Thanks
Ajit
>
>
>
>
>
>
>
> Replied in the previous thread.
> --
> David Portas, SQL Server MVP
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
> SQL Server Books Online:http://msdn2.microsoft.com/library/ms130214(en-US,
SQL.90).aspx
> -- Hide quoted text -
> - Show quoted text -

data from multiple databases

Hi
I have 6 databases and each has sys_items table. my client ask me to
create an Excel file with all the unique items from all these
databases.
e.g. get all the items from database1.sys_items then merge all the
unique items from database2.sys_items and so on
i hope you guys are getting my point.
Please advice
thanksI answered this yesterday in this same newsgroup.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Ajit - The Scorpio" <ajitscorpio@.gmail.com> wrote in message
news:1184780384.310317.296780@.m37g2000prh.googlegroups.com...
Hi
I have 6 databases and each has sys_items table. my client ask me to
create an Excel file with all the unique items from all these
databases.
e.g. get all the items from database1.sys_items then merge all the
unique items from database2.sys_items and so on
i hope you guys are getting my point.
Please advice
thanks|||On Wed, 18 Jul 2007 15:02:37 -0400, "Tom Moreau"
<tom@.dont.spam.me.cips.ca> wrote:

>I answered this yesterday in this same newsgroup.
I think he is using Google Groups. When I checked a few minutes ago
nothing new appears there in .programming since mid-day yesterday.
Roy Harvey
Beacon Falls, CT