SQL Server 2005 -I want duration from the condition below- without cursor would be preferred
I have the following table: CREATE TABLE [dbo].[DurationCalc]( [Id] [int] IDENTITY(1,1) NOT NULL, [ContractId] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Status] [nchar](1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ModDate] [smalldatetime] NULL ) ON [PRIMARY] And the following are the records INSERT INTO Tabletest1 values (5,’O',’2009-01-01 00:00:00.000′) INSERT INTO Tabletest1 values (5,’C',’2009-01-02 00:00:00.000′) INSERT INTO Tabletest1 values (5,’S',’2009-01-04 00:00:00.000′) INSERT INTO [...]

Answer Question   |  June 10, 2009  12:20 PM
SQL Server 2005, SQL Server Condition

AD Domain Admin permissions to SQL
Can a Domain Admin grant himself permissions to a SQL database? Or, put another way, can a Domain Admin make himself equivalent to the SA account?

Answer Question   |  June 9, 2009  5:58 PM
Active Directory, Active Directory Administration, Active Directory Permissions, SQL Permissions

SQL 2005 Password
If you move a sql 2000 database to sql 2005 which admin password does it have now.

Answer Question   |  June 6, 2009  3:12 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Database, SQL migration, SQL passwords

Oracle SP syntax issues
We have a linked server from SQL to Oracle and successfully ran Oracle stored procedures from SQL to insert data. I am attempting to run a different SP that returns data but can’t seem to get the syntax correct. My call includes a couple of date fields as parameters and a cursor is returned. Are [...]

Answer Question   |  June 5, 2009  2:42 PM
Oracle, Oracle stored procedures, SQL Server, Syntax errors

VB.NET – Can’t insert data into database.
I used insert command it worked successfully that ur data has updated.But it is not showing in the database Plz look in the below code and tell me where iam wrong Imports System Imports System.Collections Imports System.Data Imports System.IO Imports System.Xml.Serialization Imports System.Windows.Forms Imports System.Data.SqlClient Public Class SAdmission Shared WithEvents con As SqlConnection Shared Sub [...]

Answer Question   |  June 11, 2009  10:40 AM
SQL Server 2005, VB.NET, Visual Basic .NET

Visa and SQL compatibility issues
Do you have any solutions for the compatibility issues I am having with Microsoft Vista and SQL server Data Engine?

Answer Question   |  June 9, 2009  8:08 PM
SQL Server, SQL Server Compatibility, SQL Server Data Engine, Vista, Vista compatibility

SQL2005 SP3
Hi, I recently applied Service Pack 3 to SQL2005 64 bit and my server performance has been very slow since. The statistics have been updated on my databases, but that has not made a difference. Has anyone else experienced such behaviour post SP3 install? Thanks, Lakshmi

Answer Question   |  June 4, 2009  3:46 PM
SQL 2005, SQL 2005 Service pack 3, SQL 2005 SP3, SQL performance

Enterprise Manager problem
Any nvarchar column content is shown as <binary> when using table browsing or view from enterprise manager in SQL Server 2000.

Answer Question   |  June 4, 2009  12:37 PM
SQL Server 2000, SQL Server Enterprise Manager

Executing Oracle stored procedure from SQL server
Using a linked server I can’t seem to execute an Oracle SP from SQL. The Oracle SP requires 5 parameters and returns a cursor to a record set. The error I get suggests a syntax issue. OLE DB provider “MSDAORA” for linked server “PASSRPT” returned message “Syntax error in {resultset…} ODBC Escape.”. Do I need [...]

Answer Question   |  June 4, 2009  7:42 PM
Oracle, Oracle stored procedures, SQL Server

connetion failed ,this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL
I enabled remote connections in sql server 2005 configuration and services but also it giving same plz help iam trying this from three days

Answer Question   |  June 4, 2009  12:05 PM
SQL Server 2005, SQL Server Remote Connections

Leak rate trigger
If I have a cell that has >=50 AND another that has >=15 then I want the cell with this formula to read YES, if either of the two cells are not >= those numbers then the cell should read NO.

Answer Question   |  June 3, 2009  9:49 PM
Conditional expressions, Crystal Reports, Formula Workshop

remove password from SSIS package
How can I remove the password from a password protected SSIS package? I need to access its source code, but as soon as I try to open it I get the window: Enter Password. I don’t know the password. This package was created by an employee who left the company a couple of years ago.

Answer Question   |  June 2, 2009  4:05 PM
SSIS, SSIS Package, SSIS Passwords

SQL 2005 Password
I inherited SQL 2005 server from a previous employee and the SA password is currently stored and saved in the GUI. This has allowed me to do my job up until now. I have what I think to be the password but I am unsure if it is correct. I am afraid to remove the [...]

Answer Question   |  December 17, 2009  3:21 PM
SQL Server 2005, SQL Server Passwords

login failed
when i start debugging project,sql connection will be closed,before that it will be open .Iam using sql which comes along with vb.net 2005.Iam using sqlconnetion in login form also there its not giving error when i used sql connetion code in another form its giving error login failed .iam tried up of this error.plz help

Answer Question   |  June 2, 2009  12:31 PM
SQL, SQL Debugging, VB.NET, VB.NET 2005

SQLDUMPER library
Hello: I keep getting at startup: SQLDUMPER library failed initialization. Your installation is either corrupt or has been tampered with. Please uninstall then re-run setup to correct this problem.” I am not even sure what program to uninstall and re-run. I know I do not have any SQL programs that I installed so if I [...]

Answer Question   |  June 1, 2009  6:42 PM
SQLDUMPER, Windows XP, Windows XP Professional

runScript() returning null
Hello to all of the participants. This is my first blog. This is a program to execute .sql file which contains bunch of sql statements. I have used iBatis package it’s compling and executing with out any mistakes, but resulting nothing. I have tried in both 2.3 and 2.0 release also. Can any one make [...]

Answer Question   |  June 1, 2009  1:13 PM
iBATIS, SQL scripts, SQL statement

query for join
i have 2 tables unittypes,rules unittypes has unitid and description unitid description A1 description1 A2 description2 A3 description3 rules has id unitid 1 A1,A2 2 A1,A3 i am trying to get it to get a resultset like 1 description1,description2 2 description1,description3 the sql i wrote was select r.unitid ,(select distinct description from unittypes where unittypes.unitid [...]

Answer Question   |  June 4, 2009  12:50 PM
JOIN statement, SQL Server Query, SQL Server tables

Optimize the query in sql server
CREATE VIEW [dbo].[vwResults] AS SELECT r.ResultsPK, b.PersonID, dbo.ltcPerson.FirstName, dbo.ltcPerson.LastName, dbo.ltcPerson.PersonFriendlyID, b.DateCreated, b.FormName, r.FieldName, r.ValueString, r.ValueNumber, r.ValueDate, r.ValueTextInt, r.ValueBit, b.UserID, b.BatchID, b.ParentID, r.Active, CASE WHEN b.ParentID = 0 THEN 0 ELSE 1 END AS IsChildRecord, CAST(b.PersonID AS varchar(4)) AS PersonIDStr FROM dbo.ltcBatch b INNER JOIN dbo.ltcResults r ON b.BatchID = r.BatchID INNER JOIN dbo.ltcPerson ON b.PersonID [...]

Answer Question   |  June 3, 2009  12:35 PM
SQL Server 2000, SQL Server Query, SQL Server query optimization

Alter SQL table
hi i have a set of data number | code 1 | abc 2 |ff 3 |aa 3 |bb 4 |cc 5 |dd 5 |ee and i’m wondering if there is a way to convert this data so it looks like number | code1 |code2 1 | abc |null 2 |ff |null 3 |aa |bb [...]

Answer Question   |  May 29, 2009  11:21 AM
SQL, SQL tables

How to make VB6 and SQL Server 2000 multiuser and client-server?
how to make vb6 and sql server 2000 multiuser and client server??i use adodc for connection please tell me the source code. thx

Answer Question   |  May 28, 2009  7:49 AM
ADODC, Client/Server, Multiuser, SQL Server 2000, VB 6, Visual Basic 6