Access databases
Yes, you can setup a linked server from the SQL Server to the Access database. However when doing this, do remember that it is an Access database and performance will not be very good. If you open books online and look under “linked servers [SQL Server], Access databases” you’ll see a page specifically talking about [...]
View Answer
| August 13, 2008 1:22 AM
Access Database, Microsoft Access, SQL, SQL Server 2000
Yes, you can setup a linked server from the SQL Server to the Access database. However when doing this, do remember that it is an Access database and performance will not be very good. If you open books online and look under “linked servers [SQL Server], Access databases” you’ll see a page specifically talking about [...]
View Answer
| August 13, 2008 1:22 AM
Access Database, Microsoft Access, SQL, SQL Server 2000
How Do I assign a value if a value in the field is empty
I’m seeing a couple of issues here. First, I don’t see you closing your case statements. <pre>SELECT DISTINCT … CASE WHEN balcode = ‘ACTUAL’ AND yr = 2008 AND period = 6 THEN full_value END AS Act_Amt, …</pre> Now if the full_value has a NULL value in it, it’s a little easier to work with. [...]
View Answer
| August 13, 2008 1:18 AM
CASE statement, SQL, SQL Query
I’m seeing a couple of issues here. First, I don’t see you closing your case statements. <pre>SELECT DISTINCT … CASE WHEN balcode = ‘ACTUAL’ AND yr = 2008 AND period = 6 THEN full_value END AS Act_Amt, …</pre> Now if the full_value has a NULL value in it, it’s a little easier to work with. [...]
View Answer
| August 13, 2008 1:18 AM
CASE statement, SQL, SQL Query
auto transfer of as400 to pc
Use CPYTOIMPF and point the target to the windows server /QNTC/myserver/myshare/myfile.csv
View Answer
| August 12, 2008 5:48 PM
AS/400 import/export, CL, CSV format
Use CPYTOIMPF and point the target to the windows server /QNTC/myserver/myshare/myfile.csv
View Answer
| August 12, 2008 5:48 PM
AS/400 import/export, CL, CSV format
MS Access Forms
Make sure that the “Allow Additions” form property is not set to No for some reason.
View Answer
| August 12, 2008 2:50 PM
Access forms, Database programming, Microsoft Access
Make sure that the “Allow Additions” form property is not set to No for some reason.
View Answer
| August 12, 2008 2:50 PM
Access forms, Database programming, Microsoft Access
I want to return multiple value in the THEN clause of CASE statement
That isn’t going to work as written. The output of a CASE statement has to be a single value, but for it to work for the IN, each letter has to be a seperate value. I’d recommend setting up a joining table between the e.emp_status and c.com_inactive_flag columns so that you can find the matches [...]
View Answer
| August 11, 2008 8:52 PM
CASE statement, SQL
That isn’t going to work as written. The output of a CASE statement has to be a single value, but for it to work for the IN, each letter has to be a seperate value. I’d recommend setting up a joining table between the e.emp_status and c.com_inactive_flag columns so that you can find the matches [...]
View Answer
| August 11, 2008 8:52 PM
CASE statement, SQL
Database hanged due to concurrence
If several users are simply running <a href=”http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-the-select-statement/”>SELECT</a> statements against the same table and getting locked up then you may need to look at your indexes. They probably aren’t setup correctly. In addition you may want to change your SELECT statements to use the WITH (NOLOCK) hint. This will prevent the SELECT statements from taking [...]
View Answer
| August 11, 2008 4:08 PM
Database performance and tuning, SQL Server 2000, SQL Server database, Windows Server 2003
If several users are simply running <a href=”http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-the-select-statement/”>SELECT</a> statements against the same table and getting locked up then you may need to look at your indexes. They probably aren’t setup correctly. In addition you may want to change your SELECT statements to use the WITH (NOLOCK) hint. This will prevent the SELECT statements from taking [...]
View Answer
| August 11, 2008 4:08 PM
Database performance and tuning, SQL Server 2000, SQL Server database, Windows Server 2003
Database how to connect OpenOffice base to Visual Basic
Not a “Final Answer”, more of a places to check list: Here’s a few resources that should help with your problem. OpenOffice Basic Programming Guide Programming OpenOffice with Visual Basic If these do not seem to help, Open Office has it’s own version of basic as well.
View Answer
| May 14, 2013 1:27 PM
Database connectivity, OpenOffice Base, Visual Basic
Not a “Final Answer”, more of a places to check list: Here’s a few resources that should help with your problem. OpenOffice Basic Programming Guide Programming OpenOffice with Visual Basic If these do not seem to help, Open Office has it’s own version of basic as well.
View Answer
| May 14, 2013 1:27 PM
Database connectivity, OpenOffice Base, Visual Basic
Convert table entry from text to numeric
Hi, You could try using the DIGITS function to convert a character field to numeric. I’m not sure whether this would work with Query Management. Regards, Martin Gilbert.
View Answer
| August 11, 2008 12:16 PM
Query Management Facility
Hi, You could try using the DIGITS function to convert a character field to numeric. I’m not sure whether this would work with Query Management. Regards, Martin Gilbert.
View Answer
| August 11, 2008 12:16 PM
Query Management Facility
Learning Javascript
hi…. jus chek out<b> A beginner’s guide to Javascript by john pollock</b>….i used that book when i started wid javascript…..
View Answer
| August 11, 2008 12:03 PM
Career development, IT careers, JavaScript, Recommended reading
hi…. jus chek out<b> A beginner’s guide to Javascript by john pollock</b>….i used that book when i started wid javascript…..
View Answer
| August 11, 2008 12:03 PM
Career development, IT careers, JavaScript, Recommended reading
About MCSE
Hi Rinsa, Pls go through this <a href=”http://www.microsoft.com/learning/mcp/mcse/windows2003/default.mspx”> MCSE on Windows Server 2003 Certification Requirements </a> from Microsoft. Which will guide u what exams u need to complete. Thanks & Regards, Vlvpk
View Answer
| August 10, 2008 1:13 AM
Career development, CCNA, Certifications, Cisco certifications, IT careers, MCSE, Microsoft certifications, Networking certifications
Hi Rinsa, Pls go through this <a href=”http://www.microsoft.com/learning/mcp/mcse/windows2003/default.mspx”> MCSE on Windows Server 2003 Certification Requirements </a> from Microsoft. Which will guide u what exams u need to complete. Thanks & Regards, Vlvpk
View Answer
| August 10, 2008 1:13 AM
Career development, CCNA, Certifications, Cisco certifications, IT careers, MCSE, Microsoft certifications, Networking certifications
FOXPRO 2.6 FOR MS DOS DATABASE CONVERSION
I Think if you know the complete data structure write new utility to print the additional new reports.If you run separte compiler files(fxp) from menu select any one which is not used.Make same name program creating sub-menu for new reports. Like this you can add as many as you want. arvind_dudhade@rediff.com There are two ways: [...]
View Answer
| August 9, 2008 8:06 AM
Database, FoxDent, FoxPro, FoxPro 2.6, HIPAA, Printing
I Think if you know the complete data structure write new utility to print the additional new reports.If you run separte compiler files(fxp) from menu select any one which is not used.Make same name program creating sub-menu for new reports. Like this you can add as many as you want. arvind_dudhade@rediff.com There are two ways: [...]
View Answer
| August 9, 2008 8:06 AM
Database, FoxDent, FoxPro, FoxPro 2.6, HIPAA, Printing
DTS of TEXT to BLOB or CLOB
Not as far as I know of.
View Answer
| August 8, 2008 9:43 PM
BLOB, CLOB, Data Transformation Services, DTS
Not as far as I know of.
View Answer
| August 8, 2008 9:43 PM
BLOB, CLOB, Data Transformation Services, DTS
database form
The EASIEST is to simply build forms, reports, etc. with in the Access 2003 database and make it an MDE file so that users can’t modify the forms and reports. I would have the application mdb link to the data mdb. You could also build web forms in Access 2003 if you want.
View Answer
| August 8, 2008 1:56 PM
Access 2003, Microsoft Access
The EASIEST is to simply build forms, reports, etc. with in the Access 2003 database and make it an MDE file so that users can’t modify the forms and reports. I would have the application mdb link to the data mdb. You could also build web forms in Access 2003 if you want.
View Answer
| August 8, 2008 1:56 PM
Access 2003, Microsoft Access
Date Ranges in Access 2000
If the items are stored as rows in a table with a date, you could do this in a query: Select Item, Sum(IIf(DateDiff(“d”,[ItemDate],Now()) Between 1 And 15,1,0)) AS 0to15, Sum(IIf(DateDiff(“d”,[ItemDate],Now()) Between 16 And 30,1,0)) AS 16to30…… From Table Group By Item.
View Answer
| August 8, 2008 1:52 PM
Access 2000, Microsoft Access
If the items are stored as rows in a table with a date, you could do this in a query: Select Item, Sum(IIf(DateDiff(“d”,[ItemDate],Now()) Between 1 And 15,1,0)) AS 0to15, Sum(IIf(DateDiff(“d”,[ItemDate],Now()) Between 16 And 30,1,0)) AS 16to30…… From Table Group By Item.
View Answer
| August 8, 2008 1:52 PM
Access 2000, Microsoft Access
Which Is More Optimized
I feel Switch will be more optimized rather than using nested If… Endif…
View Answer
| August 8, 2008 6:01 AM
CASE statement, IF ELSE statement, VB.NET, Visual Basic 2005
I feel Switch will be more optimized rather than using nested If… Endif…
View Answer
| August 8, 2008 6:01 AM
CASE statement, IF ELSE statement, VB.NET, Visual Basic 2005
Right channel for working abroad?
Have you heard of <b>LinkedIn.com</b>. It is an international professional’s network site, so ideally you can post your detailed requirement there and most probably you should get response.
View Answer
| August 8, 2008 5:57 AM
Career development, IT careers, IT jobs
Have you heard of <b>LinkedIn.com</b>. It is an international professional’s network site, so ideally you can post your detailed requirement there and most probably you should get response.
View Answer
| August 8, 2008 5:57 AM
Career development, IT careers, IT jobs
what is the diff between cursor and plsql table
Cursor expressions (sometimes known as cursor subqueries) are an element of the SQL language (earlier) and now of the PL/SQL too. A cursor expression can be used as an actual parameter to a PL/SQL procedure or function, which has great significance in connection with table. It can also be used functions in the SELECT statement [...]
View Answer
| August 7, 2008 5:25 AM
Cursor Table, PL/SQL Table
Cursor expressions (sometimes known as cursor subqueries) are an element of the SQL language (earlier) and now of the PL/SQL too. A cursor expression can be used as an actual parameter to a PL/SQL procedure or function, which has great significance in connection with table. It can also be used functions in the SELECT statement [...]
View Answer
| August 7, 2008 5:25 AM
Cursor Table, PL/SQL Table
can i do abap
As of now if we see in IT field, you are a raw or fresh hand with no practical knowledge. Yes, you can go for ABAP, as it has ample growth scope but it all depends on your taste, choice and calibre. First of all you have to locate an authorized centre where you can [...]
View Answer
| August 7, 2008 5:09 AM
ABAP, IT careers
As of now if we see in IT field, you are a raw or fresh hand with no practical knowledge. Yes, you can go for ABAP, as it has ample growth scope but it all depends on your taste, choice and calibre. First of all you have to locate an authorized centre where you can [...]
View Answer
| August 7, 2008 5:09 AM
ABAP, IT careers
Hardware requirements for SQL Server 2005
THIS IS NOT A BAD CHOICE ON THE CHEAP CP1-AM2-6400A MADE BY amd.Though depending on what the server is being used for.If you are working for or own the company.Depending on how much growth your company might predict in the future <a href=”http://www.intel.com/products/processor/xeon7000/index.htm?iid=technology_quadcore_index+body_xeon7000″>dual/quad xeon</a> (http://www.intel.com/products/processor/xeon7000/index.htm?iid=technology_quadcore_index+body_xeon7000)might be the best way to go.Dont let possible enviroment of [...]
View Answer
| August 7, 2008 4:50 AM
Database design, SQL Server 2005, SQL Server performance
THIS IS NOT A BAD CHOICE ON THE CHEAP CP1-AM2-6400A MADE BY amd.Though depending on what the server is being used for.If you are working for or own the company.Depending on how much growth your company might predict in the future <a href=”http://www.intel.com/products/processor/xeon7000/index.htm?iid=technology_quadcore_index+body_xeon7000″>dual/quad xeon</a> (http://www.intel.com/products/processor/xeon7000/index.htm?iid=technology_quadcore_index+body_xeon7000)might be the best way to go.Dont let possible enviroment of [...]
View Answer
| August 7, 2008 4:50 AM
Database design, SQL Server 2005, SQL Server performance
Insert for a table
Does the other table have the new item numbers? If so you can simply use an insert statement to copy the data. <pre>INSERT INTO ItemTable (ItemId, ItemName) SELECT ItemId, ItemName FROM OtherTable</pre> Is the ItemId column an IDENTITY Column? If so it will assign new numbers for you automatically. <pre>INSERT INTO ItemTable (ItemName) SELECT ItemName [...]
View Answer
| August 6, 2008 7:59 PM
INSERT statement
Does the other table have the new item numbers? If so you can simply use an insert statement to copy the data. <pre>INSERT INTO ItemTable (ItemId, ItemName) SELECT ItemId, ItemName FROM OtherTable</pre> Is the ItemId column an IDENTITY Column? If so it will assign new numbers for you automatically. <pre>INSERT INTO ItemTable (ItemName) SELECT ItemName [...]
View Answer
| August 6, 2008 7:59 PM
INSERT statement
