hi everyone:
the report show two tables two matrixs
how can i control the distance between them
I want to set the same distance between the table and matrix
or (table and table )
Younger,
You could possible place your tables and Matrix each inside of a rectangle and then maintain the distance between your rectangle should get you to your desired results.
Ham
|||Ham
Thank you very much
Your idea is good, that is worked well.
Younger
Let say I have 6 tables. I want to autogenerate the PK for each table and that is unique for each table and cant be duplicated on other tables. Let say I have table with PK of 1, so table2 to table6 wouldnt have a PK of 1. If table2 have a PK of 2, table1, table3 to table6 wouldnt have a PK of 2. Same for others. Identity will not be appropriate. Will 'uniqueidentifier' data type suffice? How bout guid? Or what must be my datatype? Or what will I do to implement this? Any links? Thanks
What you describe isn't really applicable to a 'normal' primary key.
In the 'normal' case, a PK doesn't care about the values of other PK's in other tables.
There are cases where one would want to distribute PK values like you describe, though I don't know if that's your reason.
(eg some replication / distribution strategies)
However, if you want to read some about keys, here's a link that mayshed some light.
http://www.datamodel.org/DataModelKeys.html
=;o)
/Kenneth
|||have a composite primary key
key1 and key2
have key1 to have a default value of "A" for the first table, "b" for the second and "c" for the third
key2 would be an identity
your pk would be a combination of key1 and key2
and that would definitely be unique across the enterprise
|||
hi KeWin,
its implemented in a CRM thats why we're try to do the same. Any ideas how?
joeydj,
How would I get the latest PK, for example A3456 is the most recent. So the next generated PK is A3457. Can you show a sprocs that would do that. Thanks. :)
|||Well, personally I'm not too keen on keys like 'A3457' - where 'A' has some significant meaning.
This is what's called an 'intelligent key' or 'concatenated key' (because the key itself is made up of several parts that has independent meaning), and is ususally something you want to avoid.
What a certain key should look like - well, it depends.
It's a desginer's choice, and it's part of the datamodel.
There may be a number of reasons behind any PK's design, the most important thing about it (imo) is that the designer really understands what a primary key is, and why he/she want it implemented in a certain way. Be it natural or a surrogate, it should be deliberate with some thought behind it.
This leads to the next question, how to decide?
There's no simple answer to that question, unfortunately, it's one of those 'it depends' things....
Your best tool is understanding, both of the database in question, the business it should support, and the concept of primary keys etc.
(I don't have any good links handy, but google usually manages to come up with something =;o)
/Kenneth
|||portect wrote:
hi KeWin,
its implemented in a CRM thats why we're try to do the same. Any ideas how?
joeydj,
How would I get the latest PK, for example A3456 is the most recent. So the next generated PK is A3457. Can you show a sprocs that would do that. Thanks. :)
try this. this is called a composite pk solution. the advantage is that you dont need to worry whats
the next number in sequence. the problem is joining with other table.
|||CREATE TABLE [mytable] (
[key1] [char] (1) NOT NULL CONSTRAINT [DF_mytable_key1] DEFAULT ('A'),
[key2] [int] IDENTITY (1, 1) NOT NULL ,
[data1] [char] (10) NULL ,
[data2] [char] (10) NULL ,
CONSTRAINT [PK_mytable] PRIMARY KEY CLUSTERED
(
[key1],
[key2]
) ON [PRIMARY]
) ON [PRIMARY]
GOinsert into mytable(data1,data2)values('mydata1a','mydata2a')
insert into mytable(data1,data2)values('mydata1b','mydata2b')
select * from mytable
an alternative solution here.
remember that an identity has a seed and increment parameter.
seed Is the value that is used for the very first row loaded into the table.
this is called an identity seed and contraint solution.
first table shall be between 1 and 10M
pk type bigint, identity on, seed=1
data type bigint
constraint: pk between 1 and 10,000,000
second table shall be between 10M+1 and 20M
pk type bigint, identity on, seed=10,000,0001
data type bigint
constraint: pk between 10,000,001 and 20,000,000
third table shall be between 20M+1 and
|||Thanks all. I think surrogate keys will be appropriate.|||pk type bigint, identity on, seed=20,000,0001
data type bigint
constraint: pk between 20,000,001 and 30,000,000
if your not happy with 10M difference make it 100M.
this solution seems better to me.
follow up question:
http://forums.microsoft.com/MSDN/showpost.aspx?postid=857019&siteid=1
thanks.
sqlBut when I try to connect to sql database using the following connection strings I am unable to do so...
**************
SqlConnection myConnection = new SqlConnection("server=PLATINUM\VSdotNET;database=pubs;Trusted_Connection=yes");
SqlDataAdapter myCommand = new SqlDataAdapter(" * from Authors", myConnection);
DataSet ds = new DataSet();
myCommand.Fill(ds, "Authors");
MyDataGrid.DataSource=ds.Tables["Authors"].DefaultView;
MyDataGrid.DataBind();
**************
I have written the servername as "PLATINUM\VSdotNET" because when Iinstalled SQL SERVER 2000 I found a tray icon where the server name wasdisplaying the same (my computer name is PLATINUM).
When I used webmatrix I enterd the same server name and windowsauthentication I was able to create a database but How to createtable...
Please help me out
Thanks in advance...Please explain "I am unable to do so". Are you receiving an error message?|||Actually I don't know whether the connection string I am using is correct or not...
Because I am unable to create tables using the connection strigns what I told before...
when I try running this page I get the error message like
Compiler Error Message:CS1009: Unrecognized escape sequence
and the compiler shows a error in the connection string , So as far I guess there is problem with the connection string only.
If I get a sample page for what I am trying to do i.e connecting to SQLdatabase, Creating tables as well as accessing table my problem will besolved.
Thanks for your time.
|||Well, I always use this resource for building connection strings:http://www.connectionstrings.com/ Check out the SqlConnection (.NET) options under SQL Server. Yourproblem *might* be that you should use True, not Yes, forTrusted_Connection. In any case, I would try to stick as closelyas possible to the advice listed there.|||* from Authors is not a valid SQL Statement. Try SELECT * FROM Authors
Hi All,
I am not able to connect oracle database from MS-Analysis Services.
All my Fact tables and Dimension tables are residing on Oracle
database.Both the Oracle database and MS Analysis Services are on the
same server.
I am working on the node and I was able to create the datasource using
"Microsoft OLE DB Provider for Oracle " and the test connection also
succedded but while creating the cubes using the cube wizard it throws
error saying " Connection to the data source Failed".
Any one could help me in this regards.
What are the ways to connect the oracle DB from MS Analysis Services.
Is this problem becoz of any permission settings, how do I give permissions for the users.
Regards
Saravanavel
What users are you talking about?
Are you going to let someone else to design cubes using your data source? In this case anyone trying to run cube wizard should have permissions to access Oracle database. Cube wizard requires access to relational database.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Hi
I'd like to know how I can combine two tables from two different sql instances ito one db?
thanks.
Volkan, can you provide a little more info?
Are you trying move the data from sql instance 1 and sql instance 2 into a new database on sql instance 3?
Are you asking how you can query the data from two different instances?
You can query separate instances by using a four-part qualifier if the instances are defined as linked servers.
select * from [servername].[databasename].[schema].[tablename]
Example: server = MySQL1, database = MyDatabase, schema = dbo, table = MyTable
select * from MySQL1.MyDatabase.dbo.MyTable
|||
If both the DBs are on same Server and the current user have access permission on both database then you can use the following query..
Select SomeColumns From CurrentDBName..TableName
Select SomeColumns From OtherDBName..TableName
If the databases are on different Server then you have to use the Linked Server..
EXEC sp_addlinkedserver @.server = 'SERVER', @.provider = 'SQLOLEDB.1', @.srvproduct = '', @.provstr = 'Privider=SQLOLEDB.1;Data Source=TargetServer;Initial Catalog=Database'
go
Exec sp_addlinkedsrvlogin @.rmtsrvname = 'SERVER', @.useself = true, @.locallogin = null, @.rmtuser = 'Userid', @.rmtpassword = 'Password'
On your SP you can use..
Select * From OpenQuery(MyRemoteServer, 'Select * From Sysobjects')
--OR
Select * From MyRemoteServer.DatabaseName.dbo.Sysobjects
