sql Reporting services – report name
I have a report that runs nightly for daily invoices. It runs everyday using a subscription and places the report in a shared folder. It’s called “Daily Invoice Report”. How do I get the the Report Name “Daily Invoice Report” to also include the date that the report is for. This date is a parameter [...]

Answer Question   |  October 8, 2010  2:10 PM
SQL 2005 Database design, SQL 2005 Reporting Services, SQL Reports

Getting error when i am trying to insert the record in QTEMP file trough QSH DB2 command
i am trying to insert the record in QTEMP file trough QSH DB2 command but getting an error that file not found in QTEMP eventhough file is available in QTEMP. if i am giving my local libary instead of QTEMP then its working perfectly.

Answer Question   |  July 5, 2011  6:27 AM
DB2, Qshell, QTEMP Library, SQL procedure

Web based application not uploaded ON SERVER sometimes
We are having the Web based software which is uploaded on our server on technology of front end: PHP & backend: MS SQL Server 2005. Some times this application can not uploaded, so plz give the solution to solve this problem. Actually this application is developed by third party and they update this application remotely [...]

Answer Question   |  July 14, 2010  7:44 AM
Network applications management, Networking services, PHP, SQL Server 2005, Web application development, Web based Applications

‘convert as/400 dates ’0001-01-01′ to SQL Server 2000′
How do I convert ISO dates of ’0001-01-01′ to SQL Server 2000 Datetime format?

Answer Question   |  July 5, 2010  6:04 PM
AS/400 date format, SQL Server 2000 administration, sql server 2000 datetime data type

Join for merging records
I’m trying to figure out what the best type of join I could use in TSQL for merging records in about 6 tables where there is a match. So I have 6 different tables where there are many matching records. So I figured that I would use a left join in my first join, keep [...]

Answer Question   |  July 12, 2010  12:08 PM
JOIN statement, SQL Server 2005 Express, SQL Server 2005 merge replication, SQL tables

ORACLE-TRIGGERS
Hello, im going to create a trigger(insert or update) for a tableA, when it fires inserted or updated columns are should be insert or update into another table say tableB, one column(Processed_time) in tableB where its value will be by subtrcting two columns in tableA(response_time,Submission_time) all are timestamp type how to update(Processed_time) in tableB by [...]

Answer Question   |  July 1, 2010  11:46 AM
Oracle PL/SQL, Oracle SQL Developer, Oracle triggers, SQL Trigger

SQL Server 2008 query To Find Columns with incorrect information
This is difficult to expalain so i will try and give you an example Record                  Surname               Age            Town 1                          Smith                    50             SMITH AB 2                          Jones                     45             Leeds 3                          Patel                      38             PATEL AR What someone has done is put in the wrong data in town name and instead used details that we put in a different field. What i [...]

Answer Question   |  July 1, 2010  11:09 AM
SQL Data Set, SQL Database, SQL Query, SQL Server 2008

clarification of the terms FRS vs SRS
I’m often confuse with the term FRS and SRS – are there the same or if there’s a diiference, can u please highlight what are the diffrences? Do we have to have both for software development projects or either one is good enough?

Answer Question   |  July 1, 2010  10:13 AM
FRS, Networking Terminology, SRS 2000

How to keep date format when creating Index on a Table
I have used CREATE TABLE to create a PF which contain a DATE field. And then use CREATE INDEX to create a LF with data selections. However, when I check the DATE field, I find that, in the PF, its Date Format is *ISO; but in the LF, its Date Format has been changed to [...]

Answer Question   |  July 2, 2010  3:06 AM
SQL Database Indexing, sql indexes, SQL statements, SQL tables

I’m interested in creating a web form that will deposit information into a SQL Server database.
I’m interested in creating a web form that will deposit information into a SQL Server database. What’s the best way to do this and what software exists to accomplish this? I have experience creating Access forms that connect to a SQL Server back end.

Answer Question   |  July 1, 2010  12:12 PM
Forms Design, SQL Forms, SQL Server 2005, SQL Server 2005 Database, T/SQL

Kerberos unconstrained delegation for MS SQL svc account
Can an MS SQL service account run non-SQL services if “trust this user for delegation to any service (Kerberos only) has been enabled?

Answer Question   |  August 26, 2010  2:11 AM
Kerberos, MSSQL, SQL Server permissions, SQL Server security

Sponsor Post: Cloud Migration Pros and Cons Live Chat Today
Today’s live chat from 1-3 pm EST provides an exclusive opportunity to get your cloud migration questions answered directly from industry experts. Get tips on how to improve your ability to recover in any type of loss or disaster while keeping your budget in check and gain insight into: Data protection requirements Cloud vs on-premises [...]

Answer Question   |  July 8, 2010  2:18 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Developement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

How can I write a SQL query to get the database name ?
How can I write a SQL query to get the DB name ? Usually we use SELECT DB_NAME() AS DataBaseName, but at that time teh DB is in use. If we didn;t write use [dbname][/dbname], is there any way to get the DB name ?

Answer Question   |  June 30, 2010  11:35 AM
Database name, SQL 2008, SQL Database, SQL Query

Linking users of Access 2003 to SQL Server 2008 database
We plan to go to SQL Server 2008. We need to link our Microsoft Access 2003 users to the databases created in SQL Server 2008. Will we be able to do this considering ODBCAD32 is what we use, and the databases we create will now be 64-bit?

Answer Question   |  June 28, 2010  8:03 PM
Access 2003, SQL Server 2008, SQL Server database, SQL Server Management, SQL Server Migration Assistant

Trimming Values with SQL Server Express 2005
I have a column whose values range from 10-15 characters and whose last 7 characters I would like to get rid of. Can someone please show me how to do this? I thought it would be RTRIM but that didn’t work for me. I can’t use LEFT or RIGHT before the column because the column [...]

Answer Question   |  June 29, 2010  6:40 PM
RTRIM, SQL Server Express 2005, SQL Server Functions, TRIM function

surf control reports will not work after I enabled drill downs
reports will not work after I enabled drill downs (v.2.6) Followed directions and enabled drill downs.  Now, reports and drill downs will not work after the day I reset the drill down.  Checked directions and no indication of making changes anywhere other that the configuration menu in surfcontrol UI.  Do I need to reset something [...]

Answer Question   |  June 28, 2010  4:28 PM
SQL Database, SurfControl, Windows 7 in 2010

SQL Server 2008 Code to find fields containing similar text
I want to find fields that may be the same in some parts but not 100% identical For example Field 1 Has the word “Smith” Field 2 has “Smith AB” in it Is there any code i can write to find these, without writing code for every single name I am using SQL server 2008 [...]

Answer Question   |  July 14, 2010  3:37 PM
SQL commands, SQL Fields, SQL Server 2008 administration, SQL Server development

Sponsor Post: Fear the Cloud? Migration Pros and Cons (on-demand chat from 6/29/2010)
Organizations need to able to quickly recover failed servers and their data in the event of an outage. Deploying a server recovery solution can save a company tens of thousands of dollars in lost productivity and lost business. This live chat on June 29th from 1-3 pm EST provides an exclusive opportunity to get your [...]

Answer Question   |  July 22, 2010  2:05 PM
AS/400, Channel, CIO, CRM, Database, DataCenter, datamangement, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP

Changing over to DR database from SQL 2005
I have set up log shipping from my production SQL2005 databases to my DR server and all seems to be working fine. On examing my DR databases they are all in (Restoring…) mode.  How do I now access my DR databases if/when my production system goes down?  There does not seem to be any obvious [...]

Answer Question   |  June 28, 2010  5:39 AM
Disaster Recovery Database, HP DL380, Restore Database, SQL 2005 Database, SQL Log Files

Log In then Output the Data of the Logged Person C# SQL 2005
I have a program that requires a user to input his/her IDNumber. If it doesnt exist the program will prompt to go to the NewRecord section. When the user input his IDNumber and he will be logged on to the real program. After doing the program and pressing the DONE Button. A messagebox will appear [...]

Answer Question   |  August 3, 2010  2:36 PM
C#, Programming, SQL 2005, sql 2005 Performance Issues, SQL Database