How do I run Excel Reports?
Excel doesn’t run reports like Access. I create my own reports on a separate worksheet by linking between the two sheets. The information needed, automatically transfers to the report. Good luck.
View Answer
| July 19, 2008 12:56 PM
Excel 2007, Microsoft Access, Reports
Excel doesn’t run reports like Access. I create my own reports on a separate worksheet by linking between the two sheets. The information needed, automatically transfers to the report. Good luck.
View Answer
| July 19, 2008 12:56 PM
Excel 2007, Microsoft Access, Reports
CASE sintaxis error in SELECT
You can use OR cases in Query just like: <b>and ( (tests.var_id = CASE WHEN t3.PMN1=’1′ then 392 WHEN t3.PMN1=’2′ then 514 else 638 end ) OR (tests.var_id = CASE WHEN t3.PMN1=’1′ then 393 WHEN t3.PMN1=’2′ then 515 else 639 end ) OR (tests.var_id = CASE WHEN t3.PMN1=’1′ then 394 WHEN t3.PMN1=’2′ then 516 else [...]
View Answer
| July 19, 2008 6:35 AM
CASE statement, SELECT statement, SQL Server 2005, T-SQL
You can use OR cases in Query just like: <b>and ( (tests.var_id = CASE WHEN t3.PMN1=’1′ then 392 WHEN t3.PMN1=’2′ then 514 else 638 end ) OR (tests.var_id = CASE WHEN t3.PMN1=’1′ then 393 WHEN t3.PMN1=’2′ then 515 else 639 end ) OR (tests.var_id = CASE WHEN t3.PMN1=’1′ then 394 WHEN t3.PMN1=’2′ then 516 else [...]
View Answer
| July 19, 2008 6:35 AM
CASE statement, SELECT statement, SQL Server 2005, T-SQL
Mainframe to SAP ABAP
I don’t suggest you to take this drastic step if you are happy and satisfied with your current profile. There is a dearth of mainframe professionals around the globe and the demand still exists. Are you a technical consultant in Mainframes? If yes, stick to it. If you move to SAP ABAP, you will be [...]
View Answer
| July 19, 2008 4:10 AM
ABAP, IT careers, SAP careers
I don’t suggest you to take this drastic step if you are happy and satisfied with your current profile. There is a dearth of mainframe professionals around the globe and the demand still exists. Are you a technical consultant in Mainframes? If yes, stick to it. If you move to SAP ABAP, you will be [...]
View Answer
| July 19, 2008 4:10 AM
ABAP, IT careers, SAP careers
Suggestion/reminder How to get your question answered
Also, in the tags, please be more specific than outlook, or exchange for instance. Include outlook 2003 or outlook 2007 for instance instead of just outlook, or include exchange 2003 or 2007 instead of just exchange, and how about windows vista or windows xp instead of just windows. These details make all the difference when [...]
View Answer
| July 18, 2008 6:30 PM
AS/400, Database, Development, Exchange, ITKE, Lotus Domino, Oracle, SAP, Security, Storage, Virtualization, Windows
Also, in the tags, please be more specific than outlook, or exchange for instance. Include outlook 2003 or outlook 2007 for instance instead of just outlook, or include exchange 2003 or 2007 instead of just exchange, and how about windows vista or windows xp instead of just windows. These details make all the difference when [...]
View Answer
| July 18, 2008 6:30 PM
AS/400, Database, Development, Exchange, ITKE, Lotus Domino, Oracle, SAP, Security, Storage, Virtualization, Windows
Career advise..
Electrical engineering and then Degree in MIS is a good combination. Usually people with engineering background turn out to carry good logical brain and hence become good developers and analysts. The exposure you are getting on SAP BW is quite good. Are you planning to go into technical or functional is very important at this [...]
View Answer
| July 18, 2008 10:31 AM
IT careers, SAP BW, SAP careers
Electrical engineering and then Degree in MIS is a good combination. Usually people with engineering background turn out to carry good logical brain and hence become good developers and analysts. The exposure you are getting on SAP BW is quite good. Are you planning to go into technical or functional is very important at this [...]
View Answer
| July 18, 2008 10:31 AM
IT careers, SAP BW, SAP careers
Which degree will open more doors?
Hi Defensor1, Congratulations and good luck in your studies. Having a diverse portfolio is definitely a plus. I will complete my MS within the next four weeks, and it does feel good. I also have numerous IT certifications as well. The options that you end up having may ultimately rest with how you are able [...]
View Answer
| July 18, 2008 7:16 AM
Career development, IT careers, IT education
Hi Defensor1, Congratulations and good luck in your studies. Having a diverse portfolio is definitely a plus. I will complete my MS within the next four weeks, and it does feel good. I also have numerous IT certifications as well. The options that you end up having may ultimately rest with how you are able [...]
View Answer
| July 18, 2008 7:16 AM
Career development, IT careers, IT education
Practical start in the IT field
To be effective in a field you have to speak the language and communicate. Having the certifications is one thing but understanding the application of the information is another. You definitely need some exposure and skills in networking to be a good security expert. Learn the protocols (TCP, UDP, IP). Learn the applications (SMTP, SNMP, [...]
View Answer
| July 18, 2008 4:26 AM
Information security, Information security careers, IT careers
To be effective in a field you have to speak the language and communicate. Having the certifications is one thing but understanding the application of the information is another. You definitely need some exposure and skills in networking to be a good security expert. Learn the protocols (TCP, UDP, IP). Learn the applications (SMTP, SNMP, [...]
View Answer
| July 18, 2008 4:26 AM
Information security, Information security careers, IT careers
How do I write the code to connect an .aspx webform to a MS SQL server and database
It seams to me that your connection string isn’t setup correctly. What’s the name of the server and instance that has your database information in it?
View Answer
| July 17, 2008 5:24 PM
Server errorlog, SQL Server 2005, SQL Server errors, VS 2008
It seams to me that your connection string isn’t setup correctly. What’s the name of the server and instance that has your database information in it?
View Answer
| July 17, 2008 5:24 PM
Server errorlog, SQL Server 2005, SQL Server errors, VS 2008
odbc in i5/OS
Assuming that you are using Windows XP, on Configuraiton Panel select “Admin tool” Icon and then “ODBC Data source” Then, on the “System data source” tab press the “Add” button. A new Window would pop up to give you the existing ODBC driver list on your PC. Assuming that you are using Client Access, Select [...]
View Answer
| July 17, 2008 2:17 PM
i5/OS, ODBC, ODBC on i5, OS/400
Assuming that you are using Windows XP, on Configuraiton Panel select “Admin tool” Icon and then “ODBC Data source” Then, on the “System data source” tab press the “Add” button. A new Window would pop up to give you the existing ODBC driver list on your PC. Assuming that you are using Client Access, Select [...]
View Answer
| July 17, 2008 2:17 PM
i5/OS, ODBC, ODBC on i5, OS/400
How to create a trigger for updating a table for a quantity decrease?
You need to create two triggers one is row level where you will move your ID’s into a global staging area (may be a table of record or temporary table), then in the statement level trigger you will handle all the updates on the ID’s which you have saved in row level trigger. The reason [...]
View Answer
| July 16, 2008 8:11 PM
Oracle development, Triggers
You need to create two triggers one is row level where you will move your ID’s into a global staging area (may be a table of record or temporary table), then in the statement level trigger you will handle all the updates on the ID’s which you have saved in row level trigger. The reason [...]
View Answer
| July 16, 2008 8:11 PM
Oracle development, Triggers
New to Industry
You shouldn’t really be all that scared for the A+ exam. It is entry-level for the industry; not designed to be hard, just weed out some of those who aren’t very knowledgeable. I’m not sure I understand the question, though. Are you looking for places to study/courses in San Diego, CA? That’s how I understand [...]
View Answer
| July 16, 2008 4:27 PM
CA, Certifications, IT careers, IT jobs, SD
You shouldn’t really be all that scared for the A+ exam. It is entry-level for the industry; not designed to be hard, just weed out some of those who aren’t very knowledgeable. I’m not sure I understand the question, though. Are you looking for places to study/courses in San Diego, CA? That’s how I understand [...]
View Answer
| July 16, 2008 4:27 PM
CA, Certifications, IT careers, IT jobs, SD
DB2 and talend
Hello, This error is a result of how the iSeries ODBC driver handles return strings. It requires 1 additional byte beyond the defined string length. Possible workarounds: 1) Use the previous version IBM Client Access ODBC driver instead of the IBM iSeries Access ODBC driver. 2) Temporarily change all char and varchar stored procedure parameters. [...]
View Answer
| July 16, 2008 3:57 PM
AS/400 errors, DB2, DB2 Universal Database, iSeries, Talend
Hello, This error is a result of how the iSeries ODBC driver handles return strings. It requires 1 additional byte beyond the defined string length. Possible workarounds: 1) Use the previous version IBM Client Access ODBC driver instead of the IBM iSeries Access ODBC driver. 2) Temporarily change all char and varchar stored procedure parameters. [...]
View Answer
| July 16, 2008 3:57 PM
AS/400 errors, DB2, DB2 Universal Database, iSeries, Talend
Catching an uncaptured error in SQL
I’m not sure why it isn’t catching the error. I would assume because BULK INSERT is throwing an OS error not a SQL error. I would recommend checking to see if the file exists prior to attempting the BULK INSERT command. You can do this via the xp_fileexist. You can see an example of use [...]
View Answer
| July 16, 2008 12:09 AM
CSV, SQL, SQL Server errors
I’m not sure why it isn’t catching the error. I would assume because BULK INSERT is throwing an OS error not a SQL error. I would recommend checking to see if the file exists prior to attempting the BULK INSERT command. You can do this via the xp_fileexist. You can see an example of use [...]
View Answer
| July 16, 2008 12:09 AM
CSV, SQL, SQL Server errors
How to find out what is happening in a Database?
The virtual tables which can be accessed via a trigger are called inserted and deleted. The inserted table contains the new values, while the deleted table contains the old values. Logging the security events won’t help you see what commands are being run against the database server. It will only log when someone logs into [...]
View Answer
| July 14, 2008 11:17 PM
SQL Server, SQL Server logs, Temp Tables, Triggers, Unknown processes
The virtual tables which can be accessed via a trigger are called inserted and deleted. The inserted table contains the new values, while the deleted table contains the old values. Logging the security events won’t help you see what commands are being run against the database server. It will only log when someone logs into [...]
View Answer
| July 14, 2008 11:17 PM
SQL Server, SQL Server logs, Temp Tables, Triggers, Unknown processes
How to manage memory for SQL 2005 x64 on 64-bit WS2003 Ent
The goal with SQL Server is to not use the page file at all. If SQL needs to page data out then additional RAM should be installed as accessing data within the page file is typically as slow or slower then accessing it within the database files directly. If you have SQL Server 2005 Enterprise [...]
View Answer
| July 14, 2008 10:43 PM
Database, Memory, Server management, SQL Server 2005, Windows Server 2003
The goal with SQL Server is to not use the page file at all. If SQL needs to page data out then additional RAM should be installed as accessing data within the page file is typically as slow or slower then accessing it within the database files directly. If you have SQL Server 2005 Enterprise [...]
View Answer
| July 14, 2008 10:43 PM
Database, Memory, Server management, SQL Server 2005, Windows Server 2003
Problem inserting data using OPENROWSET in SQL Server 2000
Hello, This website explains how to insert data into a table using OPENROWSET. http://books.google.com/books?id=5_AEiJXbyiEC&pg=PA73&lpg=PA73&dq=Problem+inserting+data+using+OPENROWSET+in+SQL+Server+2000+&source=web&ots=tRwpmAffg9&sig=WuRVr9Ixg0avtX-1sHBJtOSyWno&hl=en&sa=X&oi=book_result&resnum=3&ct=result#PPA73,M1 TPinky
View Answer
| July 14, 2008 5:32 PM
Functions, SQL Server 2000, tables
Hello, This website explains how to insert data into a table using OPENROWSET. http://books.google.com/books?id=5_AEiJXbyiEC&pg=PA73&lpg=PA73&dq=Problem+inserting+data+using+OPENROWSET+in+SQL+Server+2000+&source=web&ots=tRwpmAffg9&sig=WuRVr9Ixg0avtX-1sHBJtOSyWno&hl=en&sa=X&oi=book_result&resnum=3&ct=result#PPA73,M1 TPinky
View Answer
| July 14, 2008 5:32 PM
Functions, SQL Server 2000, tables
Rusty and Need Help
You need to have a student master with all relevant details and student number as a primary key, a course master with a unique course number (has to be unique key) – so course no. is the primary key, a company master with company no. or ID as primary key, a grants master with grant [...]
View Answer
| July 14, 2008 8:21 AM
Access 2007, Excel 2007, Microsoft Access, Microsoft Excel
You need to have a student master with all relevant details and student number as a primary key, a course master with a unique course number (has to be unique key) – so course no. is the primary key, a company master with company no. or ID as primary key, a grants master with grant [...]
View Answer
| July 14, 2008 8:21 AM
Access 2007, Excel 2007, Microsoft Access, Microsoft Excel
BizTalk interview Questions
Hey, Check this collection of Biztalk Interview Questions http://www.oopsconcepts.com/Biztalk+Interview+Questions www.dotnetrobert.com
View Answer
| July 13, 2008 2:27 AM
BizTalk, Career development, Interview questionaire, IT careers
Hey, Check this collection of Biztalk Interview Questions http://www.oopsconcepts.com/Biztalk+Interview+Questions www.dotnetrobert.com
View Answer
| July 13, 2008 2:27 AM
BizTalk, Career development, Interview questionaire, IT careers
Not able to coonect to SQL Server 2005 from Front End in windows Vista Home Basic
That would depend on your application. You do not specifiy what application you are trying to use to connect to your SQL server. Does it require a login and password to the SQL server? Have you provided the correct credentials? One application I use I had to input the SQL db username and password, it [...]
View Answer
| July 11, 2008 6:17 PM
.NET applications, Database connectivity, SQL Server 2005
That would depend on your application. You do not specifiy what application you are trying to use to connect to your SQL server. Does it require a login and password to the SQL server? Have you provided the correct credentials? One application I use I had to input the SQL db username and password, it [...]
View Answer
| July 11, 2008 6:17 PM
.NET applications, Database connectivity, SQL Server 2005
Business Process Management
For business process management one has to have good management skills, aptitude to understand business streams at a faster pace and years of experience on various business processes. One must be able to understand the business requirements viz a viz the existing scenario so that he/she is able to analyze the gap. Good communication skills [...]
View Answer
| July 11, 2008 11:21 AM
BPM, BPM modeling, IT careers
For business process management one has to have good management skills, aptitude to understand business streams at a faster pace and years of experience on various business processes. One must be able to understand the business requirements viz a viz the existing scenario so that he/she is able to analyze the gap. Good communication skills [...]
View Answer
| July 11, 2008 11:21 AM
BPM, BPM modeling, IT careers
