Count several columns Group by accounts Greater than value Beginner
I would try this as a union all statement SELECT ‘d1′,COUNT(d1) AS Doubles, StuNum, SchNum, TchNum FROM table WHERE (d1 > 1) GROUP BY StuNum, SchoolNum, TeachNum UNION ALL SELECT ‘d2′,COUNT(d2) AS Doubles, StuNum, SchNum, TchNum FROM table WHERE (d2 > 1) GROUP BY StuNum, SchoolNum, TeachNum UNION ALL SELECT ‘d3′,COUNT(d3) AS Doubles, StuNum, SchNum, [...]
View Answer
| April 18, 2008 5:04 PM
COUNT, GROUP BY statement, SQL
I would try this as a union all statement SELECT ‘d1′,COUNT(d1) AS Doubles, StuNum, SchNum, TchNum FROM table WHERE (d1 > 1) GROUP BY StuNum, SchoolNum, TeachNum UNION ALL SELECT ‘d2′,COUNT(d2) AS Doubles, StuNum, SchNum, TchNum FROM table WHERE (d2 > 1) GROUP BY StuNum, SchoolNum, TeachNum UNION ALL SELECT ‘d3′,COUNT(d3) AS Doubles, StuNum, SchNum, [...]
View Answer
| April 18, 2008 5:04 PM
COUNT, GROUP BY statement, SQL
in what direction should i work
I realy do think all of you are absolutely WRONG. That is if you are not job hunting in the US. IT in the US has been shipped overseas for years. Coding jobs in the US are VERY difficult to find – an if you do look out for lay offs. I’ve been in IT [...]
View Answer
| April 18, 2008 4:09 PM
Career development, Certifications, COBOL, HTML, IT careers, SQL
I realy do think all of you are absolutely WRONG. That is if you are not job hunting in the US. IT in the US has been shipped overseas for years. Coding jobs in the US are VERY difficult to find – an if you do look out for lay offs. I’ve been in IT [...]
View Answer
| April 18, 2008 4:09 PM
Career development, Certifications, COBOL, HTML, IT careers, SQL
breaking into the IT field
Hi and welcome to the IT community. This is a frequently asked question. The IT discipline has many concentrations. My suggestion is to learn as much as possible about the different jobs, roles and responsibilities and decide what you would like to focus on. Taking and passing the CompTIA A+ and Network+ exams is a [...]
View Answer
| April 18, 2008 2:40 AM
A+, Certifications, IT careers, Network+
Hi and welcome to the IT community. This is a frequently asked question. The IT discipline has many concentrations. My suggestion is to learn as much as possible about the different jobs, roles and responsibilities and decide what you would like to focus on. Taking and passing the CompTIA A+ and Network+ exams is a [...]
View Answer
| April 18, 2008 2:40 AM
A+, Certifications, IT careers, Network+
Problem occuring while performing Mirroring
That is the way it is supposed to be. The database on the mirror server can not be accessed as data is being fed into it in real time. If you need to access the database, you can try creating a snapshot of the database. This will be a static read only copy of the [...]
View Answer
| April 18, 2008 12:29 AM
Database mirroring, SQL Server, SQL Server 2005
That is the way it is supposed to be. The database on the mirror server can not be accessed as data is being fed into it in real time. If you need to access the database, you can try creating a snapshot of the database. This will be a static read only copy of the [...]
View Answer
| April 18, 2008 12:29 AM
Database mirroring, SQL Server, SQL Server 2005
Difficult SQL query, is this possible?
1) These tables were designed to have this type of logic used against them is it too late to go back and shoot the person who did this? it won’t solve your problem, but it might make you feel better actually, the person who should be shot is the manager of the person who thought [...]
View Answer
| April 17, 2008 2:42 PM
Database, Developers, Development, Query, Query tuning, SQL, SQL Query
1) These tables were designed to have this type of logic used against them is it too late to go back and shoot the person who did this? it won’t solve your problem, but it might make you feel better actually, the person who should be shot is the manager of the person who thought [...]
View Answer
| April 17, 2008 2:42 PM
Database, Developers, Development, Query, Query tuning, SQL, SQL Query
rpg sql concat
Can you please refine your question in terms of what you’re trying to do? For example: 1) Would you like to add a datetime column to the table and be able to populate the current date (or a date data) directly from the database? Would you like to be able to query date data between [...]
View Answer
| April 16, 2008 5:25 PM
Concatenate, Database, RPG, SQL
Can you please refine your question in terms of what you’re trying to do? For example: 1) Would you like to add a datetime column to the table and be able to populate the current date (or a date data) directly from the database? Would you like to be able to query date data between [...]
View Answer
| April 16, 2008 5:25 PM
Concatenate, Database, RPG, SQL
Alternatives to ODBC
This depends on the tool/language you’re developing with (VB6, .NET, Access, etc.). Some tools cannot work with any connectivity type. For example, if you are using .NET, it might be better to use .NET Provider or OLEDB. Here is an article explaining the differences between OLEDB and ODBC: <ul> http://www.ibprovider.com/eng/documentation/firebird_interbase_odbc_drivers.html</ul> And an old article describing [...]
View Answer
| April 16, 2008 4:56 PM
Database connectivity, ODBC, SQL
This depends on the tool/language you’re developing with (VB6, .NET, Access, etc.). Some tools cannot work with any connectivity type. For example, if you are using .NET, it might be better to use .NET Provider or OLEDB. Here is an article explaining the differences between OLEDB and ODBC: <ul> http://www.ibprovider.com/eng/documentation/firebird_interbase_odbc_drivers.html</ul> And an old article describing [...]
View Answer
| April 16, 2008 4:56 PM
Database connectivity, ODBC, SQL
SQL Server 2005 – Are There Any Easy Appl. Builders
Have you tried using Microsoft Access shipped with the Microsoft Office? You can connect to SQL Server via ODBC and build simple forms very easily. Hope this helps. Michelle.
View Answer
| April 16, 2008 3:45 PM
Database connectivity, Database frontend, SQL Server 2005
Have you tried using Microsoft Access shipped with the Microsoft Office? You can connect to SQL Server via ODBC and build simple forms very easily. Hope this helps. Michelle.
View Answer
| April 16, 2008 3:45 PM
Database connectivity, Database frontend, SQL Server 2005
Eenabling full outer join option in crystal report
I am not a Crystal Report expert but it might be that the version you have does not support FULL OUTER join. You can simulate the FULL OUTER join by using RIGHT OUTER join and a LEFT OUTER join with a UNION in between. Hope this helps. Michelle.
View Answer
| April 16, 2008 3:36 PM
Crystal Reports, Database, FULL OUTER JOIN
I am not a Crystal Report expert but it might be that the version you have does not support FULL OUTER join. You can simulate the FULL OUTER join by using RIGHT OUTER join and a LEFT OUTER join with a UNION in between. Hope this helps. Michelle.
View Answer
| April 16, 2008 3:36 PM
Crystal Reports, Database, FULL OUTER JOIN
Replication
You asked the same question twice so: yes and yes. Michelle.
View Answer
| April 16, 2008 3:32 PM
SQL database replication, SQL Server, SQL Server administration
You asked the same question twice so: yes and yes. Michelle.
View Answer
| April 16, 2008 3:32 PM
SQL database replication, SQL Server, SQL Server administration
Data Migration Betrieve Tables to MS SQL Server 2005
What to prepare if we are going to migrate instead…. or what are the steps that we should take. Thanks. correcting and adding my posted question. ————————- I have several Btrieve databases being pulled into SQL 2005 via SSIS. Basically you will need to create a connection into the database (ODBC is best here in [...]
View Answer
| April 15, 2008 8:27 AM
Data migration, Database migration, Migration, Pervasive, SQL Server 2005, SQL Server migration
What to prepare if we are going to migrate instead…. or what are the steps that we should take. Thanks. correcting and adding my posted question. ————————- I have several Btrieve databases being pulled into SQL 2005 via SSIS. Basically you will need to create a connection into the database (ODBC is best here in [...]
View Answer
| April 15, 2008 8:27 AM
Data migration, Database migration, Migration, Pervasive, SQL Server 2005, SQL Server migration
Add to Excel spreadsheet from System i
Hi, We’ve asked our Search400 experts this question, and they’ve Kent Milligan provided an answer <a href=”http://iseries.blogs.techtarget.com/2008/04/14/adding-data-from-db2-to-excel/”>here.</a> I hope you find it useful. –Leah
View Answer
| April 14, 2008 4:19 PM
DB2 Everyplace, Microsoft Excel, System i
Hi, We’ve asked our Search400 experts this question, and they’ve Kent Milligan provided an answer <a href=”http://iseries.blogs.techtarget.com/2008/04/14/adding-data-from-db2-to-excel/”>here.</a> I hope you find it useful. –Leah
View Answer
| April 14, 2008 4:19 PM
DB2 Everyplace, Microsoft Excel, System i
Oracle Application Express Item
This depends upon the primary key of the child table. If a record already exists in the child table with the given foreign key value and the parent record is updated, then a “post update trigger” on the parent table can be written to update the foreign key value of the child table. All key [...]
View Answer
| April 9, 2008 7:22 PM
Database, Foreign keys, Oracle, Primary keys
This depends upon the primary key of the child table. If a record already exists in the child table with the given foreign key value and the parent record is updated, then a “post update trigger” on the parent table can be written to update the foreign key value of the child table. All key [...]
View Answer
| April 9, 2008 7:22 PM
Database, Foreign keys, Oracle, Primary keys
How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel
First you’ll need to fire up BIDS (Business Intelligence Development Studio) from the SQL Server 2005 Program Group and create a new project. You’ll need to drag a data flow task into the package. This is where you will setup the import from Access to the SQL Server. Double click the data flow task. You’ll [...]
View Answer
| April 9, 2008 12:10 AM
Microsoft Access, SQL Server integration/interoperability, SSIS, Stored Procedures
First you’ll need to fire up BIDS (Business Intelligence Development Studio) from the SQL Server 2005 Program Group and create a new project. You’ll need to drag a data flow task into the package. This is where you will setup the import from Access to the SQL Server. Double click the data flow task. You’ll [...]
View Answer
| April 9, 2008 12:10 AM
Microsoft Access, SQL Server integration/interoperability, SSIS, Stored Procedures
Fetchind duplicate rows from a table
I’d check out <a href=”http://itknowledgeexchange.techtarget.com/sql-server/”>SQL Server with Mr. Denny</a> for more information… But I would think that a command similar to the following would do the trick (I don’t have a sql server I can test with at the moment): select * from tablename where fieldname not like ‘%string1%’ and fieldname not like ‘%string2%’ and [...]
View Answer
| April 8, 2008 6:58 PM
Database, Fetchind
I’d check out <a href=”http://itknowledgeexchange.techtarget.com/sql-server/”>SQL Server with Mr. Denny</a> for more information… But I would think that a command similar to the following would do the trick (I don’t have a sql server I can test with at the moment): select * from tablename where fieldname not like ‘%string1%’ and fieldname not like ‘%string2%’ and [...]
View Answer
| April 8, 2008 6:58 PM
Database, Fetchind
How can I collect database/server information across multiple MSSQL versions.
Many people setup a single management server and consolidate this information into the server on a schedule (daily, hourly, weekly, etc depending on the information gathered). The easiest way to do this is to setup your management server and setup linked servers from the management server to all your other servers. This will then allow [...]
View Answer
| April 8, 2008 3:45 PM
Database, Scripting, SQL Server, Stored Procedures
Many people setup a single management server and consolidate this information into the server on a schedule (daily, hourly, weekly, etc depending on the information gathered). The easiest way to do this is to setup your management server and setup linked servers from the management server to all your other servers. This will then allow [...]
View Answer
| April 8, 2008 3:45 PM
Database, Scripting, SQL Server, Stored Procedures
MySql Query
If the jiuser table doesn’t have a uri field (or the primary key from the jiresourcefolder), and the jiresourcefolder doesn’t have a username field (or a column which would be the primary key from the jiuser table) then you’ll need to find the table which contains the username (or primary key from the jiuser table) [...]
View Answer
| April 8, 2008 1:44 AM
Database, JasperServer, Java, MySQL, Open source, SQL, SQL Query
If the jiuser table doesn’t have a uri field (or the primary key from the jiresourcefolder), and the jiresourcefolder doesn’t have a username field (or a column which would be the primary key from the jiuser table) then you’ll need to find the table which contains the username (or primary key from the jiuser table) [...]
View Answer
| April 8, 2008 1:44 AM
Database, JasperServer, Java, MySQL, Open source, SQL, SQL Query
Great Plains 8 ODBC Error (45)
Answering my own question, but Called M$ support and this is the solution Log into the SQL server, go to Enterprise Manger, Find the database associated ‘Databasename’ > Right click on it > Click on Properties Once Properties is open click on the Options Tab From the Options tab, Uncheck the Restrict Access, click apply [...]
View Answer
| April 7, 2008 2:40 PM
Database, Great Plains, ODBC, SQL Server errors
Answering my own question, but Called M$ support and this is the solution Log into the SQL server, go to Enterprise Manger, Find the database associated ‘Databasename’ > Right click on it > Click on Properties Once Properties is open click on the Options Tab From the Options tab, Uncheck the Restrict Access, click apply [...]
View Answer
| April 7, 2008 2:40 PM
Database, Great Plains, ODBC, SQL Server errors
Cloning Vista installation
Download sysprep for Windows Vista and sysprep the image machine. Pull the hard drive out and then ghost it to the other machines hard drives. When you boot them up it will run through the wizard and auto configure what ever info you configured sysprep for. If you don’t want to deal with the ghost [...]
View Answer
| April 7, 2008 9:07 AM
clone, Ghost image, Vista, Vista installation
Download sysprep for Windows Vista and sysprep the image machine. Pull the hard drive out and then ghost it to the other machines hard drives. When you boot them up it will run through the wizard and auto configure what ever info you configured sysprep for. If you don’t want to deal with the ghost [...]
View Answer
| April 7, 2008 9:07 AM
clone, Ghost image, Vista, Vista installation
Installing McAffee = Crashed laptop
Copy the install files locally and try again, you can delete them once your done.
View Answer
| April 3, 2008 4:10 PM
Crash, error, McAfee, McAfee Total Protection
Copy the install files locally and try again, you can delete them once your done.
View Answer
| April 3, 2008 4:10 PM
Crash, error, McAfee, McAfee Total Protection
