How to write Bcp command to insert data in to a table
declare @bcp as varchar(200) set @bcp = ‘bcp DBname.dbo.tablename in \serverfilepathtmpTestFile.txt -c -t : -r # -Sserver -Ulogin -Ppassword exec master..xp_cmdshell @bcp bcp needs full path to table and doesn’t like ##temptables switches Field terminator -t Row terminator -r

View Answer   |  December 29, 2008  3:05 PM
BCP Utility, SQL, SQL 2005

Query performance and tuning
In order to improve the performance of the query you can use NOLOCK for example SELECT b.id, b.name, ( t.id ) AS tag_id, ( t.name ) AS tag_name FROM blog_entry b INNER JOIN blog_entry_tag_jn btjn (NOLOCK) ON b.id = btjn.blog_entry_id INNER JOIN tag t (NOLOCK) ON btjn.tag_id = t.id thanx Danish

View Answer   |  December 29, 2008  11:30 AM
GROUP BY statement, ORDER BY statement, Query optimization, Query performance, SQL, SQL development, SQL performance, SQL queries, SQL statements

Looking for good network simulator software
Well, <a href=”http://www.firewall.cx/index.php”>this site</a> is supposed to have an online Cisco lab but I have not seen it operating. Maybe contact the owner and see what he suggests. You might also find some spare gear at a refurbisher that would allow you to use it temporarily for training. I recently purchased NetSim from Tetcos for [...]

View Answer   |  December 28, 2008  1:23 PM
IT education, IT training, Network simulator, Software

Is there any way to update Actual results in Quality Center from an Excel?
There is an easy way which may not do everything you want and a harder way which can do everything. 1. The easy way: There should be a set of Excel Macros included with your release of QC for importing and exporting to the TD part of QC. 2. The hard way: you should be [...]

View Answer   |  December 27, 2008  10:27 PM
HP Quality Center, Microsoft Excel, Quality assurance, Quality assurance testing, Software Quality Assurance, Software testing

Need to open network diagram
to open a netviz .net file you need the netviz Professional/3D/Project Author product of the same version or newer. I have worked with the netviz product since version 1.0a and helped develop the product. If you want, I could open it for you and export the data into html pages/visio files/powerpoint/text. Kind regards Andrew

View Answer   |  December 27, 2008  7:51 PM
.NET, .vdx, NetViz, Network, Network Diagram, Visio

ORA-12154 from Visual Studio
I found a solution: replace SID with SERVICE_NAME in the Oracle file tnsnames.ora, for the problem database.

View Answer   |  December 26, 2008  8:25 PM
ORA-12154, Visual Studio 2005

programing routine to select and copy files
Hunny, ] you should write it in text page then copy it to excal sheet … best regards…..

View Answer   |  December 26, 2008  7:20 PM
Code, programs

MS Access 2003 replacing a text string in a table with a specific number
Just use an UPDATE QUERY. <a href=”http://599cd.com/tips/access/update-query?key=ITKnowledgeExchange”>Here’s a tutorial</a>

View Answer   |  December 26, 2008  2:29 PM
MS Access 2003, text string replacement, text strings, updating data

VC++: int keyword gives different results in Oracle 9i and 10g
I am using VC++ 6.0 MFC classes, the function <b>GetFieldValue</b> sends the control to <b>case DBVT_DOUBLE:</b> in oracle 9i case while to <b>case DBVT_STRING:</b> in oracle 10g case. The GetFieldValue function is in a static library which got called from a C file, yes both DBVT_DOUBLE and DBVT_STRING have results in the library but when [...]

View Answer   |  December 24, 2008  5:43 AM
Data Type behaviour, int keyword, Integer variable, NUMBER datatype, Oracle 10g, Oracle 9i, Oracle development, Variables, VC++, Visual C++, Visual C++ 6.0

Crystal Report Query – Birthday Formula
What I would do is create an if statement that adds a year to the year if the date is before the current date. For example if Date(year(CurrentDate),month({driver_details.drd_dob}), day({driver_details.drd_dob})) >= Date() then Date(year(CurrentDate),month({driver_details.drd_dob}), day({driver_details.drd_dob})) else Date(year(CurrentDate)+1,month({driver_details.drd_dob}), day({driver_details.drd_dob})) end if Hope this helps, Dustin

View Answer   |  December 23, 2008  6:12 PM
Birthdays, Crystal Reports, Crystal Reports formulas, Formula Workshop

validation
eval newfield = filed1char + %editc(field2Num : ‘X’) or perhaps with the trim to remove the leading and trailing spaces. eval newfield = %trim(filed1char) + %editc(field2Num : ‘X’) Phil

View Answer   |  December 23, 2008  2:43 PM
Concatenate, RPG/400, RPG/400 Field Concatenation, RPG/400 field validation

WebReady doesn’t load
<a href=”http://technet.microsoft.com/en-us/library/bb217326.aspx”>Here is an article</a> which may help you.

View Answer   |  December 22, 2008  5:57 PM
Event ID 68, Exchange 2007, Exchange error messages, Outlook, Outlook Web Access, OWA, WebReady

stored procedure in delphi with oracle
Are you having some specific problem matching some datatypes ? In general, data types from the database won’t be the same as the data types from Delphi, but you should use some similar data types (for example, a String delphi data type for a varchar2 oracle data type). You will probably need to read the [...]

View Answer   |  December 22, 2008  4:59 PM
Delphi, Delphi 5, Oracle, Oracle stored procedures, Stored Procedure variables

Error code 10: Function sequence error using CPYTOIMPF on AS/400
<i>We asked our site expert, Kent Milligan if he could provide an answer. He responded with this:</i> The error you describe sounds like a defect in the DB2 engine. I would apply the latest Database Group PTF onto your server. If the problem still persists, then you should contact IBM Support.

View Answer   |  December 22, 2008  4:18 PM
AS/400 DB2, AS/400 error messages, CPYTOIMPF, SQL

Embedded SQL to process ALL members
Alias is the standard answer for all things SQL and member– but that seems to be limited to one member per alias. Logical file can be over all members but you will probably not be in the database engine that you would prefer. Phil

View Answer   |  December 22, 2008  2:15 PM
AS/400, Embedded SQL, i, iSeries, Member, OVRDBF, RPG, SQL

Joining Tables in SQL Server
In SQL Server you can not create an outer join without specifying LEFT or RIGHT.

View Answer   |  December 20, 2008  6:19 AM
JOIN statement, LEFT OUTER JOIN statement, OUTER JOIN statement, SQL Server development, SQL Server Query, SQL statements

Unable to run macro in Microsoft Excel 2007
I hope this could be the problem that the macros are not enabled automatically in ur workbook Step 1 Please perform the below step Goto Tools —->Macros—–>Security—-> Choose medium & press ok Close & reopen the workbook. Step2: Click enable macros in the dialogbox when u open the excel sheet. Please post more information reg [...]

View Answer   |  December 19, 2008  6:26 PM
Excel 2007, Excel 2007 macros, Excel macros, Microsoft Excel, Microsoft Excel 2007

SQL Stored Procedure
As fare I know in SQL there no direct support for members of phisical file. My suggestons is to write external procedure for example in ILERPG. You can open specific member inside RPG with EXTMBR(….) and then return recordset directly form RPG. Alias <b>is</b> the support for *PF members.

View Answer   |  December 19, 2008  4:54 PM
iSeries, ODBC, SQL, SQL stored procedures

SQL Column Headings
For anyone that has been searching for an answer to my question regarding why some people using an SQL statement see the field name and some see the description, I thank you for your time however, I have figured out the answer. The difference is in using the COLHDG keyword in the file.

View Answer   |  December 19, 2008  4:51 PM
SQL, SQL Column Headings, SQL statements

Using the SQL IN clause in SQLRPGLE
I am doing this: d SelectedTypes s 30 Inz( *blanks ) d Qt s 1 Inz( X’7D’ ) // Build sql IN list values with report types requested For x = 1 to NbrOfTypes; SelectedTypes = %trim(SelectedTypes)+Qt+Type(x)+Qt ; If x < NbrOfTypes; SelectedTypes = %trim(SelectedTypes) + ‘,’ ; Endif; Endfor; stmt = ‘Insert Into qtemp/FILEA [...]

View Answer   |  December 19, 2008  4:40 PM
IN statement, iSeries, iSeries development, SQL statements, SQLRPGLE, WHERE statement