i am showing border to outer table border="1" and i placed a table inside outer table with border="1"
I am getting two borders at that point
Is there any way to show only one border. Can i combine both table border
View Complete Post
I have 3 Fact Tables I would like to combine them into 1, I am not sure what's the best way to do it.
In Adventure Works, it uses UNION in TSQL to create a sales_summary Fact from Internet Sales and Reseller Sales.
Can I just write a simple Calculated measure? What's the best way to handle this kind of situation?
[Distribution Partner].[Distribution Partner].[DP]
MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query If you need to search your entire database for specific data, this query will come in handy. So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.
Hi! I'm creating an application that's supposed to first add a record to table1, and then get the ID from that record to use when adding a record to table2, to be able to associate these two records with eachother.
The user gets to type in some values that goes to table1, and some values that goes to table2, but before the insert statement for table2 is executed i need the ID from the recently added record in table1. Some dude told me to use a trigger for the autopopulate purpose, but does that really work when i also need to save some values that's user input, and when those values doesn't get saved in table1?
Are there any other way to do this or can i send values to a trigger? I'm new to triggers and stored procedures, i don't have any particular knowledge of this, any help is appreciated!
i have a stored procedure which returns three tables to a dataset ..... now i need to merge all three tables to a single table from d same dataset
like dataset1 has table1 table2 and table3 .... i want all the three tabels to be merged into dataset1 itself .... instead of three diffrent tables so that i can show all three table data in a single datagrid as a compact data and combination of 3 tables from d single dataset.....
can some1 help me please.....
I have two tables
Trans with fields TransID, Date, CustomerID and some other stuff
Customer with fields CustomerID, Name, TaxId
On the screen the user only sees the fields Date and Customer Name. CustomerID is behind the scenes only.
I'm using SqlDataSource. Having no problems with SelectCommand. I don't know how to construct the UpdateCommand and InsertCommand.
Let's say the user changes the date, then I need to do an UPDATE.
UPDATE Trans SET Date = @Date, CustomerID = @CustomerID results in an error message and the record is not updated.
I get an error on the page that says "Sys.WebForms.PageRequestManagerServerErrorException: Input string was not in correct format".
I tried taking out the set for CustomerID and I still get the error on page.
Also, for inserting, the users will see a dropdownlist with Customer Names. I need to convert that to a CustomerID to be used in the new record being inserted in the database. I'm not sure how to do this.
Do I need to do something with Control Parameters?
Hi! I want to display a crystal report in my vb.net application. Suppose I have tables named student details, student
marks, student address, etc... Now
if I want to display all these details (fields of all tables)
in one crystal report (with page breaks if necessary) then how will I
achieve it. I will be providing a combo box in my application that contains list of student names.
How can I link this combo box with the cystal report to
dynamically display report for different student on selected index
change of combo box? Help me friends. An example would be appreciable.
In this article, Niels Flensted-Jensen demonstrates how you can combine new and existing Microsoft technologies with minimal new code to provide flexible authorization for individual Web service methods. Windows 2003 Authorization Manager, Web Service Enhancements 3.0, and Enterprise Library all play a part.
MSDN Magazine November 2005
The very tools that have helped drive the growing adoption of Web services, and the enabling abstractions that they provide, can often prevent developers from peeking behind the curtains at the XML standards that make up the Web services stack. This article will offer a solution that enables type sharing between proxies created for complementary Web services, while at the same time providing an opportunity to examine the Web Services Description Language (WSDL) and its interaction with the Web services tools you know and love.
MSDN Magazine March 2005
If you want to schedule ASP.NET tasks, one solution is to use a Web service to provide an interface to your ASP.NET application and build a Windows service that calls to it at scheduled intervals. Thus the ASP.NET application doesn't have to own the scheduling logic. Here the author shows how to schedule your ASP.NET tasks using a Windows service to initiate the Web service call because Windows services can start themselves when Windows boots up.
Dealing with error handling between T-SQL and a calling application, evaluating when a field's value has changed, and creating auditing tables in SQL ServerT are all common issues that developers must tackle.
MSDN Magazine April 2004
In a shared environment you typically don't have access to delete your database, and recreate it for fresh installs of your product.
I managed to find these scripts which should help you clean out your database.
Use at your own risk.
--Delete All KeysDECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSORSET @Cursor = CURSOR FAST_FORWARD FORSELECT DISTINCT sql = 'ALTER TABLE [' + tc2.TABLE_NAME + '] DROP [' + rc1.CONSTRAINT_NAME + ']'FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME =rc1.CONSTRAINT_NAMEOPEN @Cursor FETCH Join Two Tables and Prepare Report Hello, I have a select query which is executing well. Now, I want to add one more field to that query. That field is not in the current query table, It is in the another table. How do I join those two tables and get that field value in the existing select query.?TIA
I have a select query which is executing well. Now, I want to add one more field to that query. That field is not in the current query table, It is in the another table.
How do I join those two tables and get that field value in the existing select query.?
We're trying to migrate a one of our apps to our dev server for testing and development, but we're having problems with the membership functionality. We can add users, but there seems to be a disconnect with roles. We can query the aspnet_users table and find the new user in there, but when we query the aspnet_usersinroles table, that user id is not present.
We're also unable to run the Roles.GetUsersInRole("somerole") method. It returns 0 records. When I run Roles.ApplicationName, it returns the correct name, so .NET should be passing the correct app name.
We're just a little baffled. If anyone could shed some light on what could be the issue, we would appreciate it.