SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Get Monthly Totals in SQL query

  Hi Guys, I have a Task table: TaskID Description StartDate EndDate PercentageComplete Then I have a…

  niteshrajgopal

  4 replies

  14 years, 11 months ago

  By: Johan Bijnens

• After virtualising SQL Server 2005, consistently getting aspnet_isapi.dll Deadlock Detected every day.

  Guys, I have a question regarding SQL/IIS deadlocks in our SharePoint environment. I believe it is …

  Conrad Goodman

  18 replies

  14 years, 11 months ago

  By: Pam Brisjar

• Select Records For Any Month

  Hi All, I've dates stored in my Table MyDate ------------------------------------ 2011-03-03 12:17:…

  Ashwin9

  6 replies

  14 years, 11 months ago

  By: Evil Kraig F

• Not Sorting in Ascending Order (sql server 2005)

  Hello, We have a program written in Visual Dataflex however despite the index showing in SQL 2005 a…

  kevin 21261

  10 replies

  14 years, 11 months ago

  By: rsingh.sql

• How to use the try catch block in Function?

  Hi I am trying write a function in that function i am use the try catch block, when i am complie th…

  Swamy Magam

  9 replies

  14 years, 11 months ago

  By: mp3killa 9680

• Provider cannot be found.It may not be properly installed.

  Hi, i m using sql express 2005. At log in time following error occurred. An error occurred. Descri…

  steasyvat

  1 replies

  14 years, 11 months ago

  By: Sean Lange

• Batch updates with Trigger

  I am running a batch update on a table having a trigger defined. This trigger executes a stored pro…

  Anam Verma

  6 replies

  14 years, 11 months ago

  By: John Mitchell-245523

• How to find out Not Exists Value from comma separated IDs with single SQL ?

  Example: 1,2,3,16 database value 1 2 3 4 5 6 14 15 I want 16 as output Is it possible to find out …

  Shubhajyoti Ghosh

  2 replies

  14 years, 11 months ago

  By: Shubhajyoti Ghosh

• Huge Database and there is no referential integrity maintained

  Hi Gurus, I have a database with 3800 tables and because of huge number we decided not use referent…

  vidubhushan 49100

  14 replies

  14 years, 11 months ago

  By: Ninja's_RGR'us

• More fun with the OUTPUT clause, using a subquery, joins, et al ... Possible?

  What I started with was a procedure that does an INSERT, then assigns @@IDENTITY to a variable (dan…

  krushkoder

  5 replies

  14 years, 11 months ago

  By: krushkoder

• I need a book

  Our company makes software and rolls it out to clients that manage there own machines. I am lookin…

  JKSQL

  2 replies

  14 years, 11 months ago

  By: JKSQL

• Stored Procedure Hangs when called from an application

  A customer using our software experienced a problem that turned out to be caused by a SQL 2005 stor…

  StripedCat

  4 replies

  14 years, 11 months ago

  By: tfifield

• Numeric(p,s) datatype in TSQL

  Numeric datatype in TSQL: http://msdn.microsoft.com/en-us/library/ms187746.aspx According to the de…

  rsingh.sql

  3 replies

  14 years, 11 months ago

  By: rsingh.sql

• Using Functions as Parameters in Stored Procedure Calls

  Hi, If I execute: SELECT DATEADD(m,-6,GETDATE()) it returns 2010-10-25 15:23:30.637 But if I use th…

  DoubleEx

  4 replies

  14 years, 11 months ago

  By: GSquared

• Linked server Return only 2 ROWS!!!

  I have SOLIDDB as a linked server in SQL. When I query, however it only returns the first two rows.…

  Brody Kilpatrick

  3 replies

  14 years, 11 months ago

  By: davida1974