The Best SQL Query Tool To Visualize Data Relationship
Nov 29, 2005Another marketing campaign :eek:
View 1 Replies
ADVERTISEMENT
Visualize Execution Of SSIS Package
May 21, 2007Hello everybody!
I have a question - is it possible to visualize an execution of the SSIS package when it is being run from SQL Agent? "Visualize" means to show a data-flow "live" - similair to the visualization provided by BI Dev.Studio when you run a package there, with coloured boxes, blinking etc.
I searched the Web but found nothing - neither MS-related nor utilities from third parties. Is it possible in any way?
Thanks in advance,
Andrey.
P.S. Parsing log-files is an option, but we would like to try first something less "painfull" and more universal...
Master Data Services :: User Friendly Way To Manage Data With Many-to-many Relationship
Sep 28, 2015I've been quite excited about SQL Server MDS that should allow non-IT staff to easily maintain data. However maintaining data that have many-to-many relationships seems to be quite a pain. I believe the best way is:
Open up your MDS web interfaceGo to entities > product (for example)Add a new member and fill the details Click "product parts" in the bottom right "Related Entities" partAdd a new memberTry and find the product you just created from the dropdownlistSelect the first part and click OKAgain try and find the product you have created from the dropdownlistSelect the second part and click OKRepeat...Close the tab on your browser and finish your product entity.How I wish it worked:
Open up your MDS web interfaceGo to entities > product (for example)Add a new member and fill the detailsCheck a checkbox for each part visible under "product parts" in the bottom right "Related Entities" partFinish your product entity.
How Can I Create A One-to-one Relationship In A SQL Server Management Studio Express Relationship Diagram?
Mar 25, 2006How can I create a one-to-one relationship in a SQL Server Management Studio Express Relationship diagram?
For example:
I have 2 tables, tbl1 and tbl2.
tbl1 has the following columns:
id {uniqueidentifier} as PK
name {nvarchar(50)}
tbl2 has the following columns:
id {uniqueidentifier} as PK
name {nvarchar(50)}
tbl1_id {uniqueidentifier} as FK linked to tbl1.id
If I drag and drop the tbl1.id column to tbl2 I end up with a one-to-many relationship. How do I create a one-to-one relationship instead?
mradlmaier
Power Pivot :: Use Relationship Not Overriding Conflicting Active Relationship?
Oct 14, 2015I have four tables with relationships as shown. They have a circular relationship and so one of the relationships is forced to be inactive.
  Operation (Commodity, OperationKey)  ==========>Â
Commodity (Commodity)
                     /                                                                       Â
/
                      |                                                                        Â
|
  Advice (OperationKey)      ====== (inactive)=======>
Operation Commmodity (Commodity, OperationKey)
I have the following measure:
Advice No. Commodity:=CALCULATE (
COUNTROWS ( 'Advice' ),
USERELATIONSHIP(Advice[OperationKey],'Operation Commodity'[OperationKey]),
operation
)
However, the userelationship function does not override the active relationship between Operation & Advice and so the measure is limited to Advices directly filtered by the Operation table.
If I delete the relationship between Operation and Advice, then the measure works as expected i.e. Operation indirectly filters Operation Commodity which filters Advice.
Query Relationship
Jan 4, 2007Hi all I have a question, In my view I have two tables linked together for the users, my issue is that I want them to see one record so they can get the proper total amount of records. The main table is reports and the child table is subjects. How do I make it so that they see one record from the reports table, because if there is more then one subject linked to a reports number which is the primary key, they will see more then one report number. Does that make sense??
View 9 Replies View RelatedDifficult Query With Many-To-Many Relationship
Sep 20, 2007I'm writing a workflow management application for my work, and its somewhat complicated, here's a general idea of how it works:
- Anything that a company does is defined by a workflow.
- A workflow consists of tasks.
- Some tasks in a workflow can't be started until other tasks have been completed. If task A can't be started until tasks B and C are finished, then task A depends on B and C.
You might imagine that a bank has a workflow for handling a house loan. Before a bank could sign a contract with an applicant, they'd need proof of house ownership, but before they could get proof of house ownership they need an applicant's proof of identity like a driver's license or military ID.
Here's an oversimplified visual:
Each arrow points to its dependency. Each task can have multiple dependencies.
The setup above is represented in the database by a Tasks and a Dependencies table. Tasks has an ID field, and Dependencies has a TaskID and DependencyID field which are both foreign keys to Tasks.ID.
Code:
[Tasks]
ID Status Name
-- ------ ----
1 Done Start Processing Loan Application
2 Done Photocopy applicant's driver's license
3 NotDone Photocopy proof of house ownership
4 NotDone Get a copy of applicant's W-2 forms
5 NotDone Perform credit check on applicant
6 NotDone Sign loan contract
[Dependencies]
TaskID DependencyID
------ ------------
1 0
2 1
3 1
4 2
5 2
5 3
6 4
6 5
Tasks has a many-to-many relationship with itself.
Here's the hard part:
- A task can't be started until all of its dependencies have been completed.
- after a task is completed (meanings its status is marked "done"), I need to return a list of all the new tasks that are ready to be started.
When TaskID 2 is marked "Done", then TaskID 4 is ready to begin; however, TaskID 5 is not ready to begin since it depends on 2 and 3, and 3 hasn't been completed yet.
The requirements of the query are very simple, but the implementation is difficult.
I'll post a prelimenary solution in the next post:
Recursive Relationship Query
May 21, 2006Hi all,
Im really confused and need some help please from some of you clever people.
I know the basics of SQL but Ive no idea how to write a query to do this.
Basically, we have two tables, the first containing a list of people and the second containing two relationships to the person table. The first is the parent relationship and the second the child relationship. Each person may be related to one or more other people (e.g. father, son, brother, sister etc.). If you can imagine we have a few hundred people in the person going back a couple of hundred years.
Now Ive set the scene Im really trying to create a query that can navigate all the relationships from a set point (Person).
Ultimately I would like to (given a PersonID, navigate the full PERSON_ASSOCIATION table to find:
a. All people below the PersonID (if there are any)
b. All people above the PersonID (if there are any)
For example, in the data below there is somebody called John Smith.
Going down the PERSON_ASSOCIATION table I would like to show:
John Smith has a brother called Andrew Jones who has a brother-in-law called Stephen Barnes
John Smith has a wife called Jane Wallace
John Smith has a daughter called Mary Joseph
What I am going round in circles on is the multiple relatationships, e.g. A is related to B who in turn is related to D who in turn is related to E therefore A is related to E.
PERSON
ID NAME
1 John Smith
2 Andrew Jones
3 Jane Wallace
4 Steven Barnes
5 Mary Joseph
98 Me
99 Joanne
PERSON_ASSOCIATION
ID PARENT_PERSON_ID CHILD_PERSON_ID RELATIONSHIP
1 1 2 Brother
2 1 3 Wife
3 1 5 Daughter
4 2 4 Brother-In-Law
5 98 1 Father
6 98 99 Husband
Can somebody please point me in the right direction by explaining how I can write some SQL that will navigate (and iterate through) all the PERSON and PERSON_ASSOCIATION tables.
Im sure there must be a straight forward way of doing this.
One final thing, if it helps, Im hoping to eventually end up with a stored procedure which I can basically pass in a PERSON_ID and it returns a list of all the relationships from that person.
MANY BIG thanks in advance
Im really sorry but it is driving me crazy
Mike
How To Add Data Into A PK To FK Relationship?
Jan 7, 2008HiI have 2 tables one is called QuickLinks and another called QuickLinkItemsQuickLinksQuickLinkID<PK> UserID QuickLinkName-------------------------- ----------- ------------------------1 111-111-111-111 QuickLink12 111-111-111-111 QuickLink23 222-222-222-222 QuickLink1 QuickLinkItemsQuickLinkID <FK> CharacterName CharacterImagePath---------------------- ------------------------------- ---------------------------------------- 1 a path11 b path22 d path32 e path43 a path14 b path 2 So thats how I see the data will look like in both of these tables the problem however I don't know how to write this into Ado.net code. Like I have made a PK to FK relationship on QuickLinkID(through the relationship builder thing). I am just not sure how to I do this. For the sake of an example say you have 5 text boxes 2 text boxes for inserting the character names and 2 text boxes for inserting the CharacterImagePath. Then one for the Name of the QuickLink. So how would this be done? Like if it was one table it would be just some Insert commands. Like if this was all one table I would first get the userID from the asp membership table then grab all the values from the textBoxes and insert them where they go to and the QuickLinkID would get filled automatically. The thing that throws me off is the QuickLinkID since it needs to be the same ID as in the QuickLink table. So do I have to first insert some values into the QuickLink table then do a select on it and grab the ID then finally continue with the inserts Into the QuickLinkItems table? Or do I have to join these tables together?Thanks
View 18 Replies View RelatedGui Query Tool
May 27, 2004I'm looking for suggestions on what Query tool to use on SQL DB's for a group
of people who are used to creating ACCESS QUERIES. I'm having trouble running SQL as the backend and ACCESS as the query tool to run ANALYSIS.
TIMEOUT issues and such. So, I thought we might as well use the SQL tools.
Any suggestions...
Copying Data Problem With Export Data Tool
Nov 14, 2007I Have a problem when copying data from one server to another in Management studio, I need to create and exact copy of the original because of primary key relationships,
Currently when I export the data the data will run through an insert type statement, which means that all PKs are reissued, rather than being duplicated from the original, How can I be sure that the data will be copied exactly how it is on one server to the other.
SQL 2012 :: Data Modeling Tool For A Data Warehouse?
Oct 19, 2015I need a recommendation on a data modeling tool that can be used with a data warehouse. My warehouse is running SQL 2012.
Here is my challenge: Most of the tables in the warehouse do not have primary keys and none of the tables have foreign keys on them. However, there are indexes and unique keys/indexes on the tables. I am looking for a tool that I can create virtual relationships on how the data is related, so it is visually easier for the ETL developers to write the code.
I have looked at both ER/Studio 11 and ERwin 9.6. Neither of them do it exactly the way I want it too. However, ER/Studio is pretty close.
How Can I Populate Data In A One-to-one Relationship
Jul 20, 2006Here is what I have and (somewhat understand). I’m using Visual Web
Developer 2005 Express Edition and have setup my application to use form authentication
(which automatically creates the ASPNETDB.MDF file with several default tables
and views). I’m using the CreateUserWizard
which is fine…but I need to collect additional information like (firstname,
lastname, address…and on..). What I’ve
done. I’ve created a tabled named
UserProfile and set UserId as the primary key (uniqueidentifier).
I then setup a 1-to-1 relationship
between aspnet_Users and UserProfile (which I think is correct). On my UpdateContactInfo.aspx page (where
users go to update their personal information) I use a hidden label control
(UserValue) to receive the UserId during the page_load event as below:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load UserValue.Text = Membership.GetUser().ProviderUserKey().ToString() End Sub Now with the UserID available I need to populate the
UserProfile table with the UserId, firstname, lastname, address of the
currently logged in user. How can I do this and am I on the
right track..?
Data Manipulation With One-to-many-to-one Relationship
Dec 4, 2006Is it possible to INSERT, UPDATE, DELETE data in this type of relationship? If so, how in VS2005? Not having issues with SELECT, even without joins.
Thanks
SQL2005 Query Tool
Jul 21, 2007I had SQL200 query analyzer loadded on a machine but it crashed.
Culd find CD. We decided to load SQl Server Manager sudio express from a sql 2005 CD. THe problem is that wen running queries with it, it puts some strange characters in the output. They arenon-printable characters so you don't see them
when you edit them in notepad. I have an editor that allows you to edit different
modes. I looked at the file in hex mode and found the characters there at the beginning of the first record. I just want the results in the result pane of the query to save as a regular ASCII text file comma delimited. THis same script was used successfully
in SQL2000 query Analyzer. Can anyone help?
Adhoc Query Tool For Sql Server ???
Oct 31, 2005Hi !!We are developing an application where we need a Query tool which allows customer to do Ad-Hoc or random query.. something similar to lets say http://salebyowner.com/advancedSearch.phpWe have few more options than this on which customer can do search. I don't think dynamic query in C# code or something like that is going to help me. Am I right? Do we have to use any type of query tool or something for doing this?
View 6 Replies View RelatedFree Query Tool From AgileInfoSoftware
Aug 17, 2005AgileInfoSoftware LLC is proud to announce AgileInfoSoftware PowerQuery*4.1 release. PowerQuery is free database query tool to work with multiple databases simultaneously and effectively.
The key features of PowerQuery 4.1 are:
One unified user interface works with*all your databases. No need to switch from one database to another.
Easy to build and execute query.
Use native database connectivity to improve database query performance.
Graphical*table edit and commit change without writing any INSERT, UPDATE or DELETE statement.
Automatically monitor Oracle Server side activities, such as executed SQL statements, server memory usage, disk usage and many other performance measurements
To obtain free PowerQuery 4.1, go to http://ww.agileinfollc.com. After download and install the software, send the registration code (32 bytes hash string generated based on your installation time) to support@agileinfollc.com, we will send back free license code to activate the software permanently.
Looking For Browser-based Query Tool
Feb 2, 2005Does anyone know of a vendor who provides a packaged application that allows a user to pass T-SQL commands from a browser, to our IIS web server, to our SQL Server database?
Thanks!!!
SQL Server 2014 :: One To Many Relationship In Data Processing
Jun 24, 2014I have a scenario where one partner can have multiple competency like Grade A,Grade B or Grade C and Grade AB,Grade BC etc.
I need to pull the records of competency of higher level also there is a chance of changing this competency level in feature like Grade A of Grade AA like this.
What would be the best option to select this kind of records.
Database Table Data Modifications With PK/FK Relationship
Mar 21, 2007I have two tables (T1 and T2). In T1 I have a field FT1 that is aprimary key in T2 I have a field FT2 that is a foreign key linked toFT1. These fields have been populated with data. Lets say that in onerow of data I have in T1 under FT1 "my cell" as the data entry,similarly with T2 under FT2 I have 2 rows of data that also have "mycell" as the data entry. What is the best line of action is I wantedto change "my cell" to "my data"?
View 3 Replies View RelatedInserting 1:M Relationship Data Via One Stored Procedure
Sep 2, 2006Hi,
Uses: SQL Server 2000, ASP.NET 1.1;
I've the following tables which has a 1:M relationship within them:
Contact(ContactID, LastName, FirstName, Address, Email, Fax)
ContactTelephone(ContactID, TelephoneNos)
I have a webform made with asp.net, and have given the user to add maximum of 3 telephone nos for a contact (Telephone Nos can be either Mobile or Land phones). So I've used Textbox's in the following way for the appropriate fields:
LastName,
FirstName,
Address,
Fax,
Email,
MobileNo,
PhoneNo1,
PhoneNo2,
PhoneNo3.
Once the submit button is pressed, I need to take all of this values and insert them in the tables via a Single Stored Procedure. I need to know could this be done and How?
Eagerly awaiting a response.
Thanks,
How To Write A Select Query To Return Records In A Many-to-Many Relationship - Junction Table???
Oct 26, 2006Can Somebody please show me how to acheive this, using the order details in Northwinddatabase or any other good example. as much details as possible. Many Thanks!
View 6 Replies View RelatedSystem Performance Status Using Query Without Any Tool?
Dec 24, 2002Hello,
I just wanted how we can find the system performance without using tool like performance monitor or profiler.
I just need the query like equalent to peformance monitor for see the systmem status of CPU ,IO ,Memory and etc..
Thanks,
Ravi
Query/Reporting Tool For SQL Server Tables
Oct 6, 2005Just a general question about any recommendations for a third party tool that would allow setting up a data-dictionary against SQL Server tables and a user could go in and build their own queries, reports. Perhaps they could save their query/report definitions for reuse. Other nice to haves - ability to output to PDF and export to XLS. Would prefer web interface, but can consider desktop as well. Any immediate recommendations?
Thanks.
Online Query Tool SQL Server 2005
Feb 18, 2008Hi,I was wondering if someone could help advise me.Basically i have a client who wants to upgrade from a desktop msaccess solution to a web based system using MS SQL Server 2005.Basically their main concern is in losing the ability to write ad-hocqueries using the MS Access query manager. I can obviously writestatic reports etc but whats the best way to give them someflexibility ??Can anyone advise me if there is any product that can do this for SQLServer 2005 (which im sure there is) but will work in a webenvironment.Or does anyone have any helpful ideas ???all help / advice greatly appreciatedCG
View 1 Replies View RelatedInserting Data Into Two Tables With Parent-child Relationship
Nov 13, 2006I am trying to insert data into two tables with a SSIS package. One table has a foreign key relationship to the other table's primary key. When I try to run the package, the package will just seems to hang up in bids. I have found two ways around the issue but I don't like either approach. Is there a way to set which table gets insert first?
If I uncheck the check constraints option on the child table, the package will run very quickly but this option alters the child table and basically disables the constraint. I don't like this option because it is altering the database.
The second approach is to set the commit level on both tables to say 10,000 and make sure that the multicast component has the first output path moved to the parent table. I don't like this option because I am not sure if the records are backed out if the package should abend after records have been committed.
Tool To Script Data
Jan 2, 2004any one got a freeware/shareware tool that can script a table's contents?
you know...that it will make a text file of sql insert statements of data for each row in an existing table?
danka!
Web Data Admin Tool
May 4, 2004What is the Web Data Administration tool? More specifically, how does is it different from Enterprise Manager?
View 1 Replies View RelatedData Compare Tool
May 10, 2007Does anyone have an opinion on specific “data comparison tools�?
We are looking for something to use in our test or dev environments that will be able to compare snaps shots of the data in a database before verse after a test event.
We have been able to record and compare data in specific tables but are learning that other tables were also being changed that we didn’t track. We want to be able to see all changes to a database.
Michael
Data Mining Tool
Mar 16, 2006I am new to Data Mining
I downloaded the SQL SERVER 2005 Evaluation Edition.
Question:
For Data Mining which Product Edition of VISUAL STUDIO 2005 i have to download ? ,
SQL Server 2012 :: Query To Generate Relationship (Parent Child Hierarchy From A Table)
Jul 18, 2015I am working on a query to generate parent child hierarchy from a table.
Table has below records.
--===== If the test table already exists, drop it
IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL
DROP TABLE #mytable
--===== Create the test table with
CREATE TABLE #mytable
[Code] ...
how to achieve this.l tried with temp tables it doesn't work.
Query Tracer Tool For SQL Server Express 2005
Dec 3, 2007Hi guys,
I am using DLinq with SQL Server Express 2005 and I need to install some kind of user interface which shows me a trace of the SQL statements sent. I would like to see them in real time (I won't like to inspect a log after :-).
I remember that there was something similar in SQL Server 2000 full edition, but I requiere the same functionality in the Express version now.
Could you tell me if there is some tool to do that?
Thanks in advance,
Erich.
Integration Services :: Loading Data To Destination With Foreign Key Relationship
Apr 22, 2015I have to load data into destination table, it has foreign key relation to two different tables called person table and organization table . sample data to be loaded is like
person_id organization_id
1Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Null
2Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â NULL
Null               1
null              null
person table and organization table doesn't have null values in them, when I try to load this data none of them are laoded, I know either person_id or organization id having null value is failing foreign key constraint. But I want to transfer all the rows except the ones having both nulls. how this can be achieved ?