SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Deleting Millions of Rows from Multiple Tables

  We need to archive data from our production database. The data to be archived is driven by a campai…

  homebrew01

  32 replies

  17 years ago

  By: manolomalaga

• Get Column Values as Row val

  User Table UserID UserName 1 Kumar FeedbackQA -Table FeedbackQAId Qusetions …

  suresh.s-895438

  1 replies

  17 years ago

  By: arun.sas

• Creating a filegroup

  Works: ------ ALTER DATABASE CCBS ADD FILEGROUP [1111] Does Not Work: --------------- declare @file…

  Vinoo

  2 replies

  17 years ago

  By: Johan Bijnens

• CREATING DYNAMIC TEMPORARY TABLE

  HI friends I have a requirement of creating temporary table dynamically inside a stored procedure .…

  msreddyn

  2 replies

  17 years ago

  By: msreddyn

• Problem with sum( ) over (partion by)

  CMP Ref# |Item No.|Ordered Qty| Remaining Open| Received|Sum itemquantity|Needed 610551 ****121910 …

  slins4ever

  19 replies

  17 years ago

  By: slins4ever

• Help me in istalling SS2005 Developer version:unsure:

  Hi, I am installing the SQL Server 2005 developer edition on my machine. Among the installation ste…

  Talha

  5 replies

  17 years ago

  By: Gift Peddie

• Calling Reporting Service from Window Application

  I am using SQL Server Reporting Service 2008. I want to call reporting service from my window appli…

  Si Thu

  7 replies

  17 years ago

  By: Luke L

• Help required to create a stored procedure to get other sqlserver data

  Hi All, I have a requirement of writing a stored procedure which gets me the data of all the sqlser…

  Hassans

  3 replies

  17 years ago

  By: John H Marsh

• DTSX Packages run remotely via Scheduled Tasks

  I am in the process of changing over from MSSQL 2000 to MSSQL 2005. As part of this upgrade I have …

  Kendo-771548

  6 replies

  17 years ago

  By: Kendo-771548

• Double quotations in Bulk insert - csv file

  Hello! I have a simple csv-file that I want to import into a table. I have some code and the file …

  Clark Bones

  2 replies

  17 years ago

  By: Jeff Moden

• Using Functions or Stored Procedures or Views or ????

  I've recently joined a company where it seems like they make excessive use of functions (table, sca…

  debrasmith

  6 replies

  17 years ago

  By: Jeff Moden

• how to display only one row of a duplicated id

  Hi, I have a table that stores courses and the courses are duplicated in there so the course id's a…

  sc-w

  3 replies

  17 years ago

  By: sc-w

• cancel the 'triggering' operation

  hello how can i cancel the operation that triggered.. a trigger in some cases? say i have an after …

  laailalalaa

  1 replies

  17 years ago

  By: Lynn Pettis

• Suppression of Column Heading Text when executing store procedures

  I wish to use 'Results to File' option when executing a stored procedure and for the resultant data…

  PeterR-1037872

  3 replies

  17 years ago

  By: PeterR-1037872

• Multiple COUNT(*) in SELECT

  I am using SQL Server 2005 and I need to figure out how to get multiple Count(*) results from one S…

  rconway-574047

  2 replies

  17 years ago

  By: rconway-574047