SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• sql 2005 - Rewite Update Statement

  How do I rewrite this update statement.. UPDATE dbo.Comm SET SumOfBalance = Bal.SumofBalance FRO…

  raym

  1 replies

  17 years, 2 months ago

  By: Ian Scarlett

• Error "file 'pffilestore.cpp', line 3356, function 'PFFileStore::HandleDataPageFault'"

  Does anyone know what the line 3356 pffilestore error means? I get this error when procesing a cub…

  GeeGee

  2 replies

  17 years, 2 months ago

  By: GeeGee

• Returning UniqueIdentifier From INSERT Stored Procedure

  I cannot return (output) the newly created uniqueidentifier from a stored procedure OUTPUT is alway…

  r.sacher

  1 replies

  17 years, 2 months ago

  By: Ian Scarlett

• The data types xml and varchar are incompatible in the equal to operator.

  Thanks in advance i am trying to update a table which contains xml type data field my query is as …

  anupamabr

  6 replies

  17 years, 2 months ago

  By: anupamabr

• Deleting a row is coming up with error in SQL 2005 using Visual Studio

  If anyone could help me out with the following error message, it would be appreciated. I have a 756…

  OP_HELP

  4 replies

  17 years, 2 months ago

  By: OP_HELP

• Remove Duplicate Row

  Hi, I am trying to finish this query below but i cant seem to remove the extra/duplicate rows that …

  tadhg88

  11 replies

  17 years, 2 months ago

  By: Jeff Moden

• I need a reality check re: compatibility level & locking

  This is purely theoretical as I don't have any solid information to base this on. We have a new mod…

  Wayne West

  3 replies

  17 years, 2 months ago

  By: Wayne West

• SQL Server Agent Automating jobs Dynamically

  Hi All, I have a query relating to automating jobs in sql server agent. A copy of our live financi…

  Abs-225476

  3 replies

  17 years, 2 months ago

  By: SQLBOT

• Need to created table with 2000 columns in sql server 2005

  Hi , In sql server 2005 i want create table with 2000 columns. Is it Possible in any way? Regards, …

  Sathiya priya

  10 replies

  17 years, 2 months ago

  By: Jerry Hung

• The xml data type cannot be compared or sorted, except when using the IS NULL operator.

  declare @CrossSell XML update dbo.ProductBase set CrossSell.modify('insert into (/CrossSell)[4a32…

  anupamabr

  3 replies

  17 years, 2 months ago

  By: anupamabr

• Convert rows into columns

  Hi, I have two Columns State and City. When I select them from table, it displays like …

  Shree-903371

  12 replies

  17 years, 2 months ago

  By: Shree-903371

• Cursors: Performance improvement requested

  I have table of raw data (1 million rows) in the following format CREATE TABLE [TKCSDB].[dbo].[Z_VP…

  skp_01702

  3 replies

  17 years, 2 months ago

  By: Matt Miller (4)

• SELECT queries

  Why is it necessary to sometimes include multiple tables in our SELECT queries?

  ITChief67

  5 replies

  17 years, 2 months ago

  By: ITChief67

• XML Mapping Problem

  I used this: http://support.microsoft.com/kb/316005 as a template for importing my xml data into a …

  dnlandes

  7 replies

  17 years, 2 months ago

  By: RBarryYoung

• Collation Conflict

  Can anyone help explain a way to resolve the error I receive from the following statement: --------…

  SQLbeginner

  11 replies

  17 years, 2 months ago

  By: homebrew01