What is the key for this relation?
Please look at the ERD http://www.mepopo.com/image/1/38504 If I mapping the ERD into relational database schema R(k1, k2, k3, a, b) (which is before normalization). What will be the key for R? Thanks a lot! Jean
Answer Question
| June 11, 2013 4:55 AM
ERD, ERD (Entity Relationship Diagram)
Please look at the ERD http://www.mepopo.com/image/1/38504 If I mapping the ERD into relational database schema R(k1, k2, k3, a, b) (which is before normalization). What will be the key for R? Thanks a lot! Jean
Answer Question
| June 11, 2013 4:55 AM
ERD, ERD (Entity Relationship Diagram)
Compile Program for previous system level
Hi, My system is on IBM i V7R1. I have a SQL procedure on AS/400 created using “CREATE PROCEDURE” command on SQL400 command prompt. By default resultant Program object is created with CLE attribute & for System Level V7R1M0. I want to compile this program for System Level V6R1M1. How to do this as source [...]
Answer Question
| June 10, 2013 2:00 PM
AS/400 and SQL, IBM i, SQL procedure
Hi, My system is on IBM i V7R1. I have a SQL procedure on AS/400 created using “CREATE PROCEDURE” command on SQL400 command prompt. By default resultant Program object is created with CLE attribute & for System Level V7R1M0. I want to compile this program for System Level V6R1M1. How to do this as source [...]
Answer Question
| June 10, 2013 2:00 PM
AS/400 and SQL, IBM i, SQL procedure
Update from another table and multiple criteria
update PHYS_COUNT_TAG set COUNT_QTY= (SELECT qty from MC_PART_LOCATION where MC_PART_LOCATION.part_id = PHYS_COUNT_TAG.PART_ID and MC_PART_LOCATION.location_id = PHYS_COUNT_TAG.LOCATION_ID) The above does not work with the error Msg 4104, Level 16, State 1, Line 4 The multi-part identifier “PCT.PART_ID” could not be bound. Msg 4104, Level 16, State 1, Line 5 The multi-part identifier “PCT.LOCATION_ID” could not be [...]
Answer Question
| June 10, 2013 5:36 AM
SQL Server, SQL Server tables
update PHYS_COUNT_TAG set COUNT_QTY= (SELECT qty from MC_PART_LOCATION where MC_PART_LOCATION.part_id = PHYS_COUNT_TAG.PART_ID and MC_PART_LOCATION.location_id = PHYS_COUNT_TAG.LOCATION_ID) The above does not work with the error Msg 4104, Level 16, State 1, Line 4 The multi-part identifier “PCT.PART_ID” could not be bound. Msg 4104, Level 16, State 1, Line 5 The multi-part identifier “PCT.LOCATION_ID” could not be [...]
Answer Question
| June 10, 2013 5:36 AM
SQL Server, SQL Server tables
SQL installation
What is an Instance Name? What is an Instance ID?
Answer Question
| June 7, 2013 12:11 AM
SQL, SQL Installation
What is an Instance Name? What is an Instance ID?
Answer Question
| June 7, 2013 12:11 AM
SQL, SQL Installation
VarChar to Numeric in SSRS
I am trying to convert from a varchar to numeric format using the “Expression” in Visual Studio. =FormatNumber(Fields!wo_udf8.Value) This seems to change the format of the numbers shown, however, when I try to “Sum” the column, I get this error message: Warning [[rsAggregateOfNonNumericData] The Value expression for the textrun ‘wo_udf81.Paragraphs[0].TextRuns[0]’ uses a numeric aggregate function [...]
Answer Question
| May 14, 2013 3:25 PM
SSRS 2008, SSRS reports
I am trying to convert from a varchar to numeric format using the “Expression” in Visual Studio. =FormatNumber(Fields!wo_udf8.Value) This seems to change the format of the numbers shown, however, when I try to “Sum” the column, I get this error message: Warning [[rsAggregateOfNonNumericData] The Value expression for the textrun ‘wo_udf81.Paragraphs[0].TextRuns[0]’ uses a numeric aggregate function [...]
Answer Question
| May 14, 2013 3:25 PM
SSRS 2008, SSRS reports
Flowchart and algorithm
How can I find a flow chart and algorithm of a program that finds the minimum of three values?
Answer Question
| May 12, 2013 11:18 AM
SQL program, SQL Server 2005
How can I find a flow chart and algorithm of a program that finds the minimum of three values?
Answer Question
| May 12, 2013 11:18 AM
SQL program, SQL Server 2005
Flowchart
Can someone help me write a flow chart and algorithm of a program where the user is asked to find an integer number between 1 and 50? Thanks!
Answer Question
| May 12, 2013 11:13 AM
Algorithms, SQL Server 2005
Can someone help me write a flow chart and algorithm of a program where the user is asked to find an integer number between 1 and 50? Thanks!
Answer Question
| May 12, 2013 11:13 AM
Algorithms, SQL Server 2005
MSDTC promoting a transaction only in some environments
We have a service which uses LINGTOSQL to process some updates on a remote SQL box. On some machines everything is fine and it works without DTC enabled. On other machines, that appear identical the transaction is being elevated to a distributed transaction and failing if it hasn’t been enabled correctly. This is on SQL [...]
Answer Question
| May 8, 2013 2:45 PM
DTC, SQL 2008, SQL 2008 R2
We have a service which uses LINGTOSQL to process some updates on a remote SQL box. On some machines everything is fine and it works without DTC enabled. On other machines, that appear identical the transaction is being elevated to a distributed transaction and failing if it hasn’t been enabled correctly. This is on SQL [...]
Answer Question
| May 8, 2013 2:45 PM
DTC, SQL 2008, SQL 2008 R2
How to insert Hex values through SQL/400
Hi, I’m creating a table querying the data from 3 different tables through joins. I need to insert a Hex value ‘3F’ at the end of the last record in the Output file (Table) I create to know the end of file for another system reading the file. I do not know whether this can [...]
Answer Question
| April 23, 2013 11:07 PM
SQL Database, SQL Query, SQL/400
Hi, I’m creating a table querying the data from 3 different tables through joins. I need to insert a Hex value ‘3F’ at the end of the last record in the Output file (Table) I create to know the end of file for another system reading the file. I do not know whether this can [...]
Answer Question
| April 23, 2013 11:07 PM
SQL Database, SQL Query, SQL/400
Any unsurpassed method to start-off this procedure an appropriate
I’m used to a setup which welcomes anyone who wishes a sort of an executive entry to a domain only to get imputed to the domain admin’s group. I apologize for such faulty actions, and am now separating all of our “admins” into their own groups. Specifically, I have users who require permission to assign [...]
Answer Question
| April 19, 2013 5:31 AM
SQL Server, SQL Server permissions
I’m used to a setup which welcomes anyone who wishes a sort of an executive entry to a domain only to get imputed to the domain admin’s group. I apologize for such faulty actions, and am now separating all of our “admins” into their own groups. Specifically, I have users who require permission to assign [...]
Answer Question
| April 19, 2013 5:31 AM
SQL Server, SQL Server permissions
Access
How do I access SQL data in software?
Answer Question
| April 18, 2013 11:20 AM
SQL Database, VB .NET
How do I access SQL data in software?
Answer Question
| April 18, 2013 11:20 AM
SQL Database, VB .NET
How to read MS SQL tables using iSeries RPG
Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?
Answer Question
| April 4, 2013 9:27 PM
iSeries, RPG Program, SQL 2008
Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?
Answer Question
| April 4, 2013 9:27 PM
iSeries, RPG Program, SQL 2008
SQL Plus stops before finishing
Why does SQL+ stop after running so many characters in a long SQL statement?
Answer Question
| April 3, 2013 12:23 PM
SQL Plus, SQL statement
Why does SQL+ stop after running so many characters in a long SQL statement?
Answer Question
| April 3, 2013 12:23 PM
SQL Plus, SQL statement
Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database?
Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database? I need to access data in an Intersystems Cachè Database from an SQL Server database. Can I do a select in SQL Server from a table in another DBMS system? How can I do it? Data is in a [...]
Answer Question
| April 2, 2013 2:22 PM
Cache, Database, InterSystems, SQL Server
Can I create a view in SQL Server 2008 selecting data from an Intersystems Cachè Database? I need to access data in an Intersystems Cachè Database from an SQL Server database. Can I do a select in SQL Server from a table in another DBMS system? How can I do it? Data is in a [...]
Answer Question
| April 2, 2013 2:22 PM
Cache, Database, InterSystems, SQL Server
webservice and iDB2 connections slow on startup
We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the [...]
Answer Question
| April 1, 2013 2:11 PM
AS 400, DB2 connectivity, i series, SQL Server
We have a web service running on a SQL server sending data to our I-Series using a DB2 connection. The first time the service is run to submit an order, there is a long delay before it is submitted. On repeated orders it much quicker. Is there something we can do to speed up the [...]
Answer Question
| April 1, 2013 2:11 PM
AS 400, DB2 connectivity, i series, SQL Server
I need the date to go to my dataTable
I have a form that updates the amounts a parent is either charging or paying which is working but I need the date to go to my parent table also for the date of a payment or a separate column if it was a charge. I would put my code on here but I dont [...]
Answer Question
| March 29, 2013 5:10 PM
SQL Database, VB 2012
I have a form that updates the amounts a parent is either charging or paying which is working but I need the date to go to my parent table also for the date of a payment or a separate column if it was a charge. I would put my code on here but I dont [...]
Answer Question
| March 29, 2013 5:10 PM
SQL Database, VB 2012
Convert from text to number – exporting to Excel 2003 from SQL Reporting Services 2008 R2
Hi I was trying to export a report which is in float format. When I do that, all the numbers in excel have a green small tag beside it saying “The number in this cell is formatted as text or preceded by an apostrophe”. I have to sum my report values and this can only [...]
Answer Question
| March 29, 2013 9:37 AM
Microsoft Excel 2003, SSRS 2008
Hi I was trying to export a report which is in float format. When I do that, all the numbers in excel have a green small tag beside it saying “The number in this cell is formatted as text or preceded by an apostrophe”. I have to sum my report values and this can only [...]
Answer Question
| March 29, 2013 9:37 AM
Microsoft Excel 2003, SSRS 2008
Exchange – extracting email properties
Hi there, just need a bit of guidance here. I need to extract from email accounts a list of the emails in that account – I don’t want the content of the emails – but what I want is emailID, subjsy, date received and it’s current location (ie what folder is it in) in that [...]
Answer Question
| March 29, 2013 9:35 PM
Microsoft Exchange 2007, SQL Server tables
Hi there, just need a bit of guidance here. I need to extract from email accounts a list of the emails in that account – I don’t want the content of the emails – but what I want is emailID, subjsy, date received and it’s current location (ie what folder is it in) in that [...]
Answer Question
| March 29, 2013 9:35 PM
Microsoft Exchange 2007, SQL Server tables
Importing Excel data into SQL Server and filtering columns of Excel data in SQL
I’m trying to import Excel sheet’s data into SQL server and filter column data.eg: pim ,rib,rpm,rms,ssrs ets sub topics comes under Oracle retail tower. Likewise, I need to filter for 9 other towers. How can I do this? Can anyone please help me?
Answer Question
| March 26, 2013 5:34 AM
Microsoft Excel 2010, SQL Server
I’m trying to import Excel sheet’s data into SQL server and filter column data.eg: pim ,rib,rpm,rms,ssrs ets sub topics comes under Oracle retail tower. Likewise, I need to filter for 9 other towers. How can I do this? Can anyone please help me?
Answer Question
| March 26, 2013 5:34 AM
Microsoft Excel 2010, SQL Server
Server upgrade 2003 to 2008
I’m upgrading my server hardware, I currently have server 2003. I also want to upgrade to server 2008 too. The new server I’m getting comes with its own new drives. How can I upgrade to a completely new server and upgrade to 2008, while retaining all of my data and Active Directory, etc.
Answer Question
| March 26, 2013 10:13 PM
SQL Server 2003, SQL Server 2008 R2
I’m upgrading my server hardware, I currently have server 2003. I also want to upgrade to server 2008 too. The new server I’m getting comes with its own new drives. How can I upgrade to a completely new server and upgrade to 2008, while retaining all of my data and Active Directory, etc.
Answer Question
| March 26, 2013 10:13 PM
SQL Server 2003, SQL Server 2008 R2
