Will Visual Studio 2003 and SQL Server 2008
Will Visual Studio 2003 work with SQL Server 2008 databases.

Answer Question   |  December 23, 2009  2:15 PM
SQL Server 2008, Visual Studio 2003

Power builder 7.0 compatible with SQL 2005
We currently use Powerbuilder 7.0 with SQL Server 2000. We want to upgrade to SQL Server 2005. Does anyone know if SQL Server 2005 is compatible with Powerbuilder 7.0?

Answer Question   |  December 22, 2009  11:48 AM
PowerBuilder, PowerBuilder 7.0, SQL 2005

convert from msaccess to sql2005
SELECT Format(DTrans.DATE,’dd/mmm/yyyy’) AS dated, DTrans.trntype as Expr1 , DTrans.JVNO, ‘By ‘ & FINNACCO.ACCNAME , (select analscode from INCEXPAN where analscode=val(DTrans.CRANALSCODE) and accode=craccode) AS CRANALSCODE, ” , DTrans.AMOUNT, dtrans.craCCODE AS accode, DTrans.jID,”,”,dtrans.narration,dtrans.status FROM DTrans INNER JOIN FINNACCO ON DTrans.dRACCODE = FINNACCO.ACCODE order by DTrans.DATE

Answer Question   |  December 23, 2009  6:59 AM
Microsoft Access, Query Manager, SQL 2005

odbc data source
odbc data source not displaying all dbs when pointing to sql2008. Only shows default db. odbc data source that points to sql2000 shows all dbs user has access to.

Answer Question   |  December 23, 2009  2:01 PM
ODBC, ODBC Errors, SQL 2000, SQL 2008

SSRS statistics
Hi, I new to SSRS. I have a table grouped by a category. I need to make a statistics about number of rows of particular item and sum of few columns in each of the group. I can make those statistics inside the tablix. But I need to have those statistics outside of the tablix [...]

Answer Question   |  December 21, 2009  1:50 AM
SQL Server 2008, SQL Server Reporting Services, SSRS

Mainframe access to SQL server data
How can I access SQL server data from a mainframe COBOL program?

Answer Question   |  December 24, 2009  6:35 PM
SQL Server

Trigger SSRS report when particular table is updated in the database
Hi, I need Trigger or run the SSRS report automaticallty and deliver to my email when some updates happens in particular table. Is that Data driven subscriptions is solution for the above or any other methods to be done. Looking forward you answer quickly   Thanks

Answer Question   |  December 18, 2009  2:39 PM
SQL Server Reporting Services, SSRS, SSRS reports

Transposing a table in SQL Server Reporting Services Layout.
Hi Eveyone, Can anybody tell me that [strong]How to Transpose a table in SQL Server Reporting Services Layout?[/strong] I am having my data displayed in a [strong]Table[/strong] inn SSRS 2005; Please help… Thanks, Swapnil

Answer Question   |  December 17, 2009  11:06 AM
SQL Server Reporting Services, SSRS, SSRS 2005, SSRS Table Transposing

SQL server production virtualization – to do or not to do
I am being pushed to say yes for virtualizing our production server. We have already moved all our application servers, developement, stage and qa database environments to the virtualized environment (VMware). (These environments are not nearly the same size or power as production, can barely funtion at fraction of the actual activity in production. ) [...]

Answer Question   |  December 16, 2009  10:06 PM
Database, Database administration, Enterprise Virtualization, SQL Server Virtualization

DB2 to SQL Server migration
We have a client that is migrating from the AS/400 DB2 to .NET and SQL Server and they want us to find them a resource to help locate and then migrate the data stored on the DB2 data base to SQL Server and I was wondering if that is more for a DB2 DBA or [...]

Answer Question   |  April 13, 2010  5:39 PM
DB2, SQL Server migration

Using Right() inside SQL Join
I need to join two tables where one table uses 0809 as data in the field and the other table uses 200809. Can this be done? Can I use a Right() statement in the join? Thanks

Answer Question   |  December 16, 2009  3:14 PM
MySQL functions, RIGHT JOIN, SQL join

32 and 64 Bit SQL 2005 on Same Server
We need to still link to MS Access databases and understand the 64 bit SQL Server does not allow. So, a thought is to have the new 64 bit SQL Server coexist with a 32 bit SQL Server Express instance. The thought is the 32 bit instance will enable linked server access to MS Access [...]

Answer Question   |  December 22, 2009  3:04 PM
MS Access, SQL Server, SQL Server 2005

The most-watched IT questions this week: Dec. 15, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Ak1bo78 asks for a C# how to on IF Statement’s, which Mshen and CarlosDL help create. 2. Dbsi2006 asks for help on how to map drives without UNC, which Rklanke, MrDenny, KevinBeaver and CarlosDL [...]

Answer Question   |  December 15, 2009  2:13 PM
AS/400, Channel, CIO, CRM, databse, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Stroage, Virtualization, VoIP

numeric test in SQL
I have a complex select query and must now add an additonal condition. One of the elements must be numeric. The ‘isnumeric’ function keeps erroring out on me. select FWVCCOA_FMS_CENTER cfmsctr,        fwvccoa_fund_code  cfundcde,        fwvccoa_orgn_code  corgncde,        ftvfund_orgn_code_def forgncde,        fwvccoa_prog_code  cprogcde,        ftvfund_prog_code_def fprogcde   from temple_finance.fwvccoa, ftvfund [strong]where ISNUMERIC(FWVCCOA_ACCI_CODE)= 1[/strong]  and fwvccoa_fund_code [...]

Answer Question   |  December 15, 2009  2:35 PM
SQL error messages, SQL Testing, WINSQL Numeric Function

how to save file doc, xls, into database sql server 2000 in VB6
how to save file doc, xls, into database sql server 2000 in VB6 with rdoconnection?

Answer Question   |  December 14, 2009  12:33 AM
Microsoft Office, SQL Server 2000, VB6, Visual Basic

The IT Blog Top 10: Dec. 10, 2009
10. No Exchange 2007 on Windows 2008 R2 – but why? Brendan Cournoyer delves into why the latest Windows 2008 R2 takes a surprising turn in not support Exchange 2007. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. What is Changed Block [...]

Answer Question   |  December 11, 2009  10:09 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

composite WHERE condition in SQL Server
In Oracle, I can do: Select * from table where field1 || field2 in (’01XX’,’02YY’,’03ZZ’) ; Where field1 has values of 01,02,03 and field2 has values of XX,YY,ZZ etc Can I do the same thing in SQL Server, or do I need define some derived fields to get the same effect?

Answer Question   |  December 11, 2009  2:42 PM
SQL Server development, SQL Server tables, WHERE condition

How to connect asp.net with sql 2005
I am trying to connect asp.net with sql2005 its not responding I am doing the contact us page where it will upload information to the database . the fields that im having is “Name,Surname,Email,Comments” it does connect but it doesnt up load to a database. Can you give some clues on how to code for [...]

Answer Question   |  February 26, 2010  1:57 PM
ASP.NET Web applications, SQL Server 2005 connectivity

SQL question
One table named as employee has 3 columns (name, salary, department). I need to retrieve the employees whose salary is greater than average salary of their department. that is name    salary   department iioo      10000    Technical aaaa    15000     HR pppp    17000     HR wwww    20000    Technical   I need to get employee details whose salary is greater than [...]

Answer Question   |  December 15, 2009  12:46 PM
SQL, SQL tables

The most-watched IT questions this week: Dec. 8, 2009
Here are the 10 most watched questions on ITKE: There’s some great discussion going on. Go answer a question now! 1. Pushan1234 asks about Returning string value from a stored procedure in sql server 2005 to vc# ide code at runtime. CarlosDL and MrDenny provide some pointers. 2. Bonbon78 runs into trouble Converting date values [...]

Answer Question   |  December 9, 2009  8:07 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, DataManagement, Development, Exchange, ITKE, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP