CSV data into Excel 2007
Yes there is a way withing excel itself, if your up on your visual basic code you can enter the editor via the menu or i believe its F11 from here you can take the contents of a cell, break it up and change values in to the chr value. One easy way is to [...]
View Answer
| April 3, 2008 7:27 AM
Access 2007, CSV, Excel 2007
Yes there is a way withing excel itself, if your up on your visual basic code you can enter the editor via the menu or i believe its F11 from here you can take the contents of a cell, break it up and change values in to the chr value. One easy way is to [...]
View Answer
| April 3, 2008 7:27 AM
Access 2007, CSV, Excel 2007
DB2 Web Query- Change Report Layout
This is the anwser of IBM to a very similar question: I have my own style sheets that I want to use for my reports. How do I make them available from Report Assistant? In Report Assistant, on the Reporting options tab, you can specify a style sheet under the Apply an existing WebFocus Stylesheet [...]
View Answer
| April 2, 2008 6:26 PM
DB2, DB2 Web Query
This is the anwser of IBM to a very similar question: I have my own style sheets that I want to use for my reports. How do I make them available from Report Assistant? In Report Assistant, on the Reporting options tab, you can specify a style sheet under the Apply an existing WebFocus Stylesheet [...]
View Answer
| April 2, 2008 6:26 PM
DB2, DB2 Web Query
Data transfer from DB2 (AS400) TO SQL SERVER 2005
You will have to create a link between your AS/400 and SQL server first using ODBC. Then, create an SQL server database having a file definition corresponding to your AS/400 data description and then write a stored proc to insert informations into those files based on the external AS/400 file.
View Answer
| April 2, 2008 2:01 PM
AS/400, AS/400 DB2, Data transfer, DB2, ODBC, SQL Server 2005
You will have to create a link between your AS/400 and SQL server first using ODBC. Then, create an SQL server database having a file definition corresponding to your AS/400 data description and then write a stored proc to insert informations into those files based on the external AS/400 file.
View Answer
| April 2, 2008 2:01 PM
AS/400, AS/400 DB2, Data transfer, DB2, ODBC, SQL Server 2005
How are H-1B visas impacting your company?
I think the issue of H1-B visas got out of proportion and become a political issue rather than a business issue. I still recall a conversation I had with an immigration lawyer few years back when the total number of visas issued annually was around 120,000, he said “these visas never get used up.” Although [...]
View Answer
| April 1, 2008 4:37 PM
Career development, CIO, H-1B visas, IT careers, Midmarket businesses, Staffing
I think the issue of H1-B visas got out of proportion and become a political issue rather than a business issue. I still recall a conversation I had with an immigration lawyer few years back when the total number of visas issued annually was around 120,000, he said “these visas never get used up.” Although [...]
View Answer
| April 1, 2008 4:37 PM
Career development, CIO, H-1B visas, IT careers, Midmarket businesses, Staffing
referential integrity
Hi, I think you’ve got it covered without referencing A and C to D. Regards, Martin Gilbert.
View Answer
| April 1, 2008 3:48 PM
Database, Referential integrity
Hi, I think you’ve got it covered without referencing A and C to D. Regards, Martin Gilbert.
View Answer
| April 1, 2008 3:48 PM
Database, Referential integrity
Need career advice for Network Communications Management
It depends on what type of organization you would like to join when you graduate. No matter what, you will need to show real-world experience of addressing issues. Experience counts. Education is good but unless you have had some practical experience in troubleshooting support or design, you may not easily find what you really want [...]
View Answer
| March 28, 2008 3:55 PM
CCNA, Certifications, IT careers, Networking certifications, VoIP jobs
It depends on what type of organization you would like to join when you graduate. No matter what, you will need to show real-world experience of addressing issues. Experience counts. Education is good but unless you have had some practical experience in troubleshooting support or design, you may not easily find what you really want [...]
View Answer
| March 28, 2008 3:55 PM
CCNA, Certifications, IT careers, Networking certifications, VoIP jobs
Flexgrid loading from CSV and saving to CSV
Hi, Please be specific on language…mention now. You can access CSV directly using File.Open Alternately using ODBC. Tell me your choise while I cook the answer Regards, CarolNandini
View Answer
| March 28, 2008 1:09 PM
CSV, MSFlexGrid
Hi, Please be specific on language…mention now. You can access CSV directly using File.Open Alternately using ODBC. Tell me your choise while I cook the answer Regards, CarolNandini
View Answer
| March 28, 2008 1:09 PM
CSV, MSFlexGrid
Automation engineering/SAP career which I should persue?
Well… That’s a tough one! I guess nobody can answer this one for you but yourself! You can have very good careers in all these domains. I guess the right question to ask yourself is what do you prefer to do? Automation, production planning or quality control? Joelle Hi As Joelle has said, you need [...]
View Answer
| March 25, 2008 3:39 AM
Automation engineering, IT careers, SAP careers
Well… That’s a tough one! I guess nobody can answer this one for you but yourself! You can have very good careers in all these domains. I guess the right question to ask yourself is what do you prefer to do? Automation, production planning or quality control? Joelle Hi As Joelle has said, you need [...]
View Answer
| March 25, 2008 3:39 AM
Automation engineering, IT careers, SAP careers
select only duplicate employee numbers
Hi, In SQL, you can use GROUP BY … HAVING. To get a distinct list of the duplicate numbers: <pre> SELECT employee_number FROM table_name GROUP BY employee_number HAVING COUNT (*) > 1; </pre> To find all the records that have one of those numbers, use the IN operator with the query above: <pre> SELECT * [...]
View Answer
| March 24, 2008 2:19 PM
Database
Hi, In SQL, you can use GROUP BY … HAVING. To get a distinct list of the duplicate numbers: <pre> SELECT employee_number FROM table_name GROUP BY employee_number HAVING COUNT (*) > 1; </pre> To find all the records that have one of those numbers, use the IN operator with the query above: <pre> SELECT * [...]
View Answer
| March 24, 2008 2:19 PM
Database
Job Change
You are really the only one who can answer this. The big question is, do you want to move out of a technical role and into a business role? If you do then this might be the right leap for you. If you want to remain technical then a Vendor Management role isn’t what you [...]
View Answer
| March 19, 2008 9:21 PM
Developers, IT careers, IT jobs
You are really the only one who can answer this. The big question is, do you want to move out of a technical role and into a business role? If you do then this might be the right leap for you. If you want to remain technical then a Vendor Management role isn’t what you [...]
View Answer
| March 19, 2008 9:21 PM
Developers, IT careers, IT jobs
Is there a server running on localhost: 3306?
The easy way to see if there is a service listening on that port is to telnet to the port. From a command prompt run telnet localhost 3306. If you get back a flashing cursor then a service is listening, If you get an error message then no service is listening. #######Added by kb3cgj############## You [...]
View Answer
| March 19, 2008 5:06 PM
ColdFusion, java.sql.SQLException, MySQL
The easy way to see if there is a service listening on that port is to telnet to the port. From a command prompt run telnet localhost 3306. If you get back a flashing cursor then a service is listening, If you get an error message then no service is listening. #######Added by kb3cgj############## You [...]
View Answer
| March 19, 2008 5:06 PM
ColdFusion, java.sql.SQLException, MySQL
Running different versions of MySql on same machine?
The whole idea behind this is to compile the new MySQL server with different TCP/IP ports and Unix socket files so that each one is listening on different network interfaces. Compiling in different base directories for each installation also results in separate compiled-in data directory, log file, and PID file location for each server. <a [...]
View Answer
| March 19, 2008 2:56 PM
Database, MySQL
The whole idea behind this is to compile the new MySQL server with different TCP/IP ports and Unix socket files so that each one is listening on different network interfaces. Compiling in different base directories for each installation also results in separate compiled-in data directory, log file, and PID file location for each server. <a [...]
View Answer
| March 19, 2008 2:56 PM
Database, MySQL
Create Information_Schema view
Not that I know of. Everytime I’ve tried to create an object in the sys schema I get an error. What’s the end result of the view you are trying to create? SQL 2005 has tons of data exposed via the DMVs.
View Answer
| March 17, 2008 6:36 PM
INFORMATION_SCHEMA views, SQL Server 2000, SQL Server 2005
Not that I know of. Everytime I’ve tried to create an object in the sys schema I get an error. What’s the end result of the view you are trying to create? SQL 2005 has tons of data exposed via the DMVs.
View Answer
| March 17, 2008 6:36 PM
INFORMATION_SCHEMA views, SQL Server 2000, SQL Server 2005
Using Case Statement Inside SQL Join
You will have to build the whole SQL statement into a variable in one go then execute it. The INNER JOIN is implied e.g. select x.a from x, y where x.rowid=y.rowid This is an inner join and will only return rows where there is a reference in both tables
View Answer
| March 17, 2008 4:54 PM
CASE statement, JOIN statement, SQL, T-SQL
You will have to build the whole SQL statement into a variable in one go then execute it. The INNER JOIN is implied e.g. select x.a from x, y where x.rowid=y.rowid This is an inner join and will only return rows where there is a reference in both tables
View Answer
| March 17, 2008 4:54 PM
CASE statement, JOIN statement, SQL, T-SQL
Design a SQL Server trigger to calculate column averages and return them to another table
What you want is actually a stored procedure not a trigger. Triggers can not be fired off on schedule, while stored procedures can. First you need to write your select statement which simply returns the data that you need to load into the destination table. The query will look something like this. <pre>SELECT IdField, AVG(NumericField) [...]
View Answer
| March 16, 2008 11:33 PM
SQL Server development, SQL Server performance, Triggers
What you want is actually a stored procedure not a trigger. Triggers can not be fired off on schedule, while stored procedures can. First you need to write your select statement which simply returns the data that you need to load into the destination table. The query will look something like this. <pre>SELECT IdField, AVG(NumericField) [...]
View Answer
| March 16, 2008 11:33 PM
SQL Server development, SQL Server performance, Triggers
Create error message for check constraint
When data is entered into a column of the wrong data type an error will be returned already. For example is a column has the data type of INT and you try to put text data into the column the database will return an error message. If you want a text field and you add [...]
View Answer
| March 16, 2008 5:10 AM
check constraint
When data is entered into a column of the wrong data type an error will be returned already. For example is a column has the data type of INT and you try to put text data into the column the database will return an error message. If you want a text field and you add [...]
View Answer
| March 16, 2008 5:10 AM
check constraint
job prospects
Certifications are a great way to show what you know, however without a few years of experience you won’t be able to move out of the entry level position. As you are already working in help desk, that is an excellent first step. From help desk moving into a NOC position is a good next [...]
View Answer
| March 14, 2008 5:40 PM
CCIE, CCNA, CCNP, Certifications, Cisco certifications, IT careers, IT jobs, Network+, Networking certifications
Certifications are a great way to show what you know, however without a few years of experience you won’t be able to move out of the entry level position. As you are already working in help desk, that is an excellent first step. From help desk moving into a NOC position is a good next [...]
View Answer
| March 14, 2008 5:40 PM
CCIE, CCNA, CCNP, Certifications, Cisco certifications, IT careers, IT jobs, Network+, Networking certifications
Daily trigger in SQL
This would be a stored procedure not a trigger. You can not schedule triggers to run on a schedule. Create a stored procedure with the code needed to calculate the averages and then use the SQL Server Agent to schedule the stored procedure to run nightly.
View Answer
| March 13, 2008 10:26 AM
SQL, Triggers
This would be a stored procedure not a trigger. You can not schedule triggers to run on a schedule. Create a stored procedure with the code needed to calculate the averages and then use the SQL Server Agent to schedule the stored procedure to run nightly.
View Answer
| March 13, 2008 10:26 AM
SQL, Triggers
Setting up database mirroring for disaster recovery in SQL Server
When you fail over to the mirror, once the primary server is back online SQL will automatically being feeding the transactions back. When you look at the databases in the UI it will say if it’s mirroring or synchronized. If it says that it is synchronized then there are no pending transactions to be sent. [...]
View Answer
| March 12, 2008 7:00 AM
Database mirroring, Disaster Recovery, High Availability, SQL Server 2000, SQL Server 2005
When you fail over to the mirror, once the primary server is back online SQL will automatically being feeding the transactions back. When you look at the databases in the UI it will say if it’s mirroring or synchronized. If it says that it is synchronized then there are no pending transactions to be sent. [...]
View Answer
| March 12, 2008 7:00 AM
Database mirroring, Disaster Recovery, High Availability, SQL Server 2000, SQL Server 2005
Connectiveity JAVA to Sql server 2000
Did you try to download SQL Server 2000 Driver for JDBC SP3 or SQL Server 2000 Driver for JDBC SP2? If not, you can find them here: http://support.microsoft.com/default.aspx/ph/2852?cid=C_48273 Thanks! Joelle
View Answer
| March 11, 2008 2:06 PM
JDBC, SQL Server 2000, Windows Server 2003
Did you try to download SQL Server 2000 Driver for JDBC SP3 or SQL Server 2000 Driver for JDBC SP2? If not, you can find them here: http://support.microsoft.com/default.aspx/ph/2852?cid=C_48273 Thanks! Joelle
View Answer
| March 11, 2008 2:06 PM
JDBC, SQL Server 2000, Windows Server 2003
