SQL Server Tag Directory

Featured SQL Server Questions

MSDTC promoting a transaction only in some environments
We have a service which uses LINGTOSQL to process some updates on a remote SQL box.  On some machines everything is fine and it works without DTC enabled.  On other machines, that appear identical the transaction is being elevated to a distributed transaction and failing if it hasn’t been enabled correctly.  This is on SQL [...]

Answer Question   |  May 8, 2013  2:45 PM
DTC, SQL 2008, SQL 2008 R2
asked by:
5 pts.

How to insert Hex values through SQL/400
Hi, I’m creating a table querying the data from 3 different tables through joins. I need to insert a Hex value ‘3F’ at the end of the last record in the Output file (Table) I create to know the end of file for another system reading the file. I do not know whether this can [...]

Answer Question   |  April 23, 2013  11:07 PM
SQL Database, SQL Query, SQL/400
asked by:
10 pts.

Access
How do I access SQL data in software?

Answer Question   |  April 18, 2013  11:20 AM
SQL Database, VB .NET
asked by:
5 pts.

How to read MS SQL tables using iSeries RPG
Has anyone found a technique for reading data directly from MS SQL using an iSeries RPG program?

Answer Question   |  April 4, 2013  9:27 PM
iSeries, RPG Program, SQL 2008
asked by:
5,525 pts.

I need the date to go to my dataTable
I have a form that updates the amounts a parent is either charging or paying which is working but I need the date to go to my parent table also for the date of a payment or a separate column if it was a charge. I would put my code on here but I dont [...]

Answer Question   |  March 29, 2013  5:10 PM
SQL Database, VB 2012
asked by:
5 pts.

Getting DB2 data into SQL 2008 database
We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged [...]

Answer Question   |  March 20, 2013  7:59 PM
AS/400, DB2, iSeries, SQL 2008
asked by:
3,890 pts.

Constant variable in SQL cursor
select  gthamcode as hamcode, gtnumber as item, ‘G’ from testlib/gtinl01 where (gtnumber between 08000000000000 and 08999999999999) union all select modkey as hamcode, modndcnum as item, ‘M’ from testlib/hammodel where (modndcnum between 08000000000 and 08999999999)   This works with interactive SQL but I need to use this in an COBOL embbeded SQL cursor. The ’M’ and  ’G’ are constants [...]

Answer Question   |  February 28, 2013  7:23 PM
AS/400, SQL Cursors
asked by:
5 pts.

Assign a serial number for each group
I want to assign a serial number for the below data using the Access query or by using SQL for Access     DateItems Sold2/1/20135462/1/20138975/1/20132565/1/201310325/1/20137858/2/20136548/2/20131211   I want the output like as below: S.noDateItems Sold12/1/201354622/1/201389715/1/201325625/1/2013103235/1/201378518/2/201365428/2/20131211   Can anyone help me?

Answer Question   |  February 25, 2013  9:59 AM
Microsoft Access 2002, SQL 2000
asked by:
5 pts.

Recursive SQL error
For the life of me I can not see what my problem is. Any help would be appreciated. *************** Beginning of data **************************************** WITH RPL (LEVEL, PINBR, CINBR, QTYPR) AS (SELECT 1, ROOT.PINBR, ROOT.CINBR, ROOT.QTYPR FROM ITSTRU ROOT WHERE ROOT.PINBR = ’8B714-0005651′ UNION ALL SELECT PARENT.LEVEL+1, CHILD.PINBR, CHILD.CINBR, CHILD.QTYPR FROM RPL PARENT, ITSTRU CHILD WHERE [...]

Answer Question   |  February 12, 2013  8:27 PM
SQL error messages, SQL statements
asked by:
25 pts.

Entry Level Vendor Neutral SQL Certification
Hello, Can anyone recommend an entry level vendor neutral SQL certification? I am looking for a cert that is focused on SQL coding rather than learning a specific database. I want to get into database programming and show that I know the basics such as normalization, querying, joins, etc. Thanks for your help.

Answer Question   |  December 18, 2012  2:54 PM
SQL, SQL certifications
asked by:
5 pts.

Changing web server can access back office app through local host but not when it is on DMZ
We have a Windows 2003 web server, a SQL database, and a Sonic Wall. The existing web server is to be replaced. We can see and log into our back office application on the new server when we are looking at local host but when we put it into the DMZ we cannot log into [...]

Answer Question   |  November 19, 2012  11:04 AM
DMZ, SQL Database, Windows Web Server 2003
asked by:
15 pts.

SQL query
I have 3 columns: development no,city, status for stamp (this column is set by 0,1,2). I want to write a query that specifies percentage of stamps per city; for example percentage of stamps with 1 in city x, percentage of stamps with 2 in city x, percentage of stamps with 1 in city y….and so [...]

Answer Question   |  November 18, 2012  10:36 AM
SQL 2008, SQL Server 2008
asked by:
5 pts.

Supression by date and field data
I am trying to suppress a text field within a section by both field parameters being null and also by specific time frame. The formulas work independently just fine, but not when placed together. (isnull({DBA.POST})= false or isnull ({DBA.ANNUAL}) = false) and {DBA_DATE.Report_DATE} < DateTime (2012,11,04,00,00,00)

Answer Question   |  November 15, 2012  3:44 PM
SQL 2005, SQL 2005 Database
asked by:
15 pts.

Sharepoint 3.0 website no longer working after Windows updates installed
We have an Intranet site that was set up in SharePoint 3.0. Over the weekend windows updates were installed, specifically KB2687442. Now my Intranet site does not work. When I try and run the SharePoint Products and Technologies Configuration Wizard it fails at step 9 with the following error : Failed to upgrade SharePoint Products [...]

Answer Question   |  October 30, 2012  12:40 PM
SharePoint, SQL Express 2005, Windows Server 2003
asked by:
85 pts.

hyper-threading technology
What are the examples of processor architectures that have hyper-threading technology?

Answer Question   |  October 18, 2012  7:25 AM
RSS feed, RSScripter
asked by:
15 pts.

sql query of datediff between two columns
i am having one table in sql 2000 that is called (personal), in that table i am having two columns name date of birth(dob) and date of enrollment(doe). i want to write a query to get the actual difference between two date i.e like 10 years 03 months 22 days. Can somebody help me out [...]

Answer Question   |  October 12, 2012  5:01 PM
SQL 2000
asked by:
10 pts.

SQL SERVER
 The SQL Server mobile edition is supported on?

Answer Question   |  October 10, 2012  8:40 AM
SQL, SQL 2005 Database, SQL 2005 Database design
asked by:
10 pts.

Database
How to create a database of prison management system using SQL?

Answer Question   |  October 9, 2012  4:33 PM
SQL, SQL Database
asked by:
25 pts.

CR 11 connection to sql 6.5
I need too connect CR 11.5 to SQL 6.5. Which connection method do I use?

Answer Question   |  September 25, 2012  6:17 PM
SQL 6.5
asked by:
5 pts.

SQL table connectivity via odc
Can a user create a Microsoft .odc file from a SQL database (eg Visual Manufacturing, Dynamics, etc.) without a special tool? Looking to design refreshable Excel reports.

Answer Question   |  August 30, 2012  2:18 PM
Microsoft Excel, Microsoft odc, SQL Database
asked by:
5 pts.