Update duplicate records
Before change: CLAIM_ID CR/RE Internal TAT 11061488 Rebill 27 11061488 Credit 11061488 Credit 11062027 Rebill 34 11062027 Rebill 11071404 Credit 12 11071404 Credit After change : CLAIM_ID CR/RE Internal TAT 11061488 Rebill 11061488 Credit 27 11061488 Credit 11062027 Rebill 34 11062027 Rebill 11071404 Credit 12 11071404 Credit condition : if Credit – Credit [...]
Answer Question
| November 26, 2012 12:20 PM
SQL Server 2008, SQL Server 2008 64-bit
Before change: CLAIM_ID CR/RE Internal TAT 11061488 Rebill 27 11061488 Credit 11061488 Credit 11062027 Rebill 34 11062027 Rebill 11071404 Credit 12 11071404 Credit After change : CLAIM_ID CR/RE Internal TAT 11061488 Rebill 11061488 Credit 27 11061488 Credit 11062027 Rebill 34 11062027 Rebill 11071404 Credit 12 11071404 Credit condition : if Credit – Credit [...]
Answer Question
| November 26, 2012 12:20 PM
SQL Server 2008, SQL Server 2008 64-bit
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
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
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
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
Debug
How to debug an SQL Stored Procedure?
Answer Question
| November 16, 2012 1:14 PM
SQL, SQL procedure
How to debug an SQL Stored Procedure?
Answer Question
| November 16, 2012 1:14 PM
SQL, SQL procedure
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
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
SQL Authenticated user change his/her own password
We have an Access application that leverages ODBC DSN to link to SQL Server 2008 database. SQL Authenticated logins and passwords have been created for each user on the SQL Server, these logins have been granted access to the SQL Server database. When creating the logins: Enforce password policy, Enforce password expiration and User must [...]
Answer Question
| November 12, 2012 7:57 PM
SQL Server, SQL Server database
We have an Access application that leverages ODBC DSN to link to SQL Server 2008 database. SQL Authenticated logins and passwords have been created for each user on the SQL Server, these logins have been granted access to the SQL Server database. When creating the logins: Enforce password policy, Enforce password expiration and User must [...]
Answer Question
| November 12, 2012 7:57 PM
SQL Server, SQL Server database
Can any one post IKM online test questions (SQL Server 2008) please?
IKM online test questions SQL Server 2008.
Answer Question
| November 8, 2012 11:03 PM
SQL Server 2008
IKM online test questions SQL Server 2008.
Answer Question
| November 8, 2012 11:03 PM
SQL Server 2008
SQL or T-SQL
This question related to this thread: http://itknowledgeexchange.techtarget.com/itanswers/difference-between-sql-and-t-sqlmicrosoft-sql-server-2000/ So if I want to study SQL server, should I first study SQL and then T-SQL or just dive right in to T-SQL.
Answer Question
| November 8, 2012 10:13 PM
SQL Server, T-SQL
This question related to this thread: http://itknowledgeexchange.techtarget.com/itanswers/difference-between-sql-and-t-sqlmicrosoft-sql-server-2000/ So if I want to study SQL server, should I first study SQL and then T-SQL or just dive right in to T-SQL.
Answer Question
| November 8, 2012 10:13 PM
SQL Server, T-SQL
Concatonating year using date parameter with extract function
I have a date parameter :ASOFDATE being entered as such: 01/01/2008. I would like the following to print out in my columns: 2008-09. The code I am using to attempt getting this is as follows: to_char(extract(year FROM to_date(:ASOFDATE, ‘DD-MM-YYYY’))) || ‘-’ || substr(extract(year FROM to_date(:ASOFDATE , ‘DD-MM-YYYY’) + 365), 3,2) The information that prints in [...]
Answer Question
| November 7, 2012 6:46 PM
SQL Server Query
I have a date parameter :ASOFDATE being entered as such: 01/01/2008. I would like the following to print out in my columns: 2008-09. The code I am using to attempt getting this is as follows: to_char(extract(year FROM to_date(:ASOFDATE, ‘DD-MM-YYYY’))) || ‘-’ || substr(extract(year FROM to_date(:ASOFDATE , ‘DD-MM-YYYY’) + 365), 3,2) The information that prints in [...]
Answer Question
| November 7, 2012 6:46 PM
SQL Server Query
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
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
mdm.udpValidateModel can be run twice with no side effect.
I am new to MDS, client give me the mdm.udpValidateModel SP with @username etc. parameter. i don’t know i parsed first time or executed. I again executed. will there will be any side effect . please guide me urgently. urgent. SET @User_ID = (SELECT ID FROM mdm.tblUser u WHERE u.UserName = @UserName ) SET @Version_ID [...]
Answer Question
| October 29, 2012 11:38 AM
SQL Server 2008 R2
I am new to MDS, client give me the mdm.udpValidateModel SP with @username etc. parameter. i don’t know i parsed first time or executed. I again executed. will there will be any side effect . please guide me urgently. urgent. SET @User_ID = (SELECT ID FROM mdm.tblUser u WHERE u.UserName = @UserName ) SET @Version_ID [...]
Answer Question
| October 29, 2012 11:38 AM
SQL Server 2008 R2
SQL Select Stmt
Need to create a sql stmt to find all the people who work on exactly the same projects and same hours as Smith.
Answer Question
| October 26, 2012 1:56 AM
SQL Select
Need to create a sql stmt to find all the people who work on exactly the same projects and same hours as Smith.
Answer Question
| October 26, 2012 1:56 AM
SQL Select
System i Navigator Run SQL Script block CL commands
Hello. The run sql script in System i Navigator allows me to run CL commands. How can i block this? Thx in advance.
Answer Question
| October 19, 2012 11:53 AM
CL command, IBM, iNavigator, Sql Script
Hello. The run sql script in System i Navigator allows me to run CL commands. How can i block this? Thx in advance.
Answer Question
| October 19, 2012 11:53 AM
CL command, IBM, iNavigator, Sql Script
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
What are the examples of processor architectures that have hyper-threading technology?
Answer Question
| October 18, 2012 7:25 AM
RSS feed, RSScripter
SQL Server TempDB
How do I clear data from TempDB?
Answer Question
| October 17, 2012 7:59 AM
SQL Server, TempDB
How do I clear data from TempDB?
Answer Question
| October 17, 2012 7:59 AM
SQL Server, TempDB
How to insert data from SQL procedure
How can I insert data from SQL procedure. I am using cursor.
Answer Question
| October 16, 2012 8:42 AM
AS/400, SQL procedure
How can I insert data from SQL procedure. I am using cursor.
Answer Question
| October 16, 2012 8:42 AM
AS/400, SQL procedure
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
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
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
The SQL Server mobile edition is supported on?
Answer Question
| October 10, 2012 8:40 AM
SQL, SQL 2005 Database, SQL 2005 Database design
Database
How to create a database of prison management system using SQL?
Answer Question
| October 9, 2012 4:33 PM
SQL, SQL Database
How to create a database of prison management system using SQL?
Answer Question
| October 9, 2012 4:33 PM
SQL, SQL Database
Sql Query
I have save data with special character (Enter Mark) in DB. But when I query the table and copy & paste result in excel then (Enter Mark) character does not come. I have refreshed the DB server due to some technical problem. Before reset it was working properly. But not now. plz help.
Answer Question
| October 3, 2012 1:37 PM
SQL Server
I have save data with special character (Enter Mark) in DB. But when I query the table and copy & paste result in excel then (Enter Mark) character does not come. I have refreshed the DB server due to some technical problem. Before reset it was working properly. But not now. plz help.
Answer Question
| October 3, 2012 1:37 PM
SQL Server
