SQL Server 2005 General Discussion

• Topics

  Started by

  Posts

  Last post

• Help with UPDATE

  I need to convert the SELECT statement below, to an UPDATE statement to populate the 3 values in th…

  krushkoder

  7 replies

  15 years ago

  By: Johan Bijnens

• Covering Index for a view.

  Ok, I'm no DBA and use indexs in a limited capacity. However I recently introduced a view that is c…

  daninmanchester

  9 replies

  15 years ago

  By: daninmanchester

• SQL Server Conditional Join

  I am facing the following problem. I want to make a join between two tables (lets say A, B). A Dea…

  hector__21

  14 replies

  15 years ago

  By: hector__21

• Delete all data in a partition?

  Hi, This may be a simple question, because I'm new to partitioning. I have a huge table that is par…

  pacman2007

  3 replies

  15 years ago

  By: pacman2007

• Cannot Create Script

  I have a user who is a dbo for a particular database and is trying to use the right click "Script D…

  Roger Bourne

  4 replies

  15 years ago

  By: dokcheng

• Insert random numbers into a column

  I have a table, one of the columns is empty. I want to insert a random number into each row of the …

  henryvuong1000

  13 replies

  15 years ago

  By: Jeff Moden

• Rollback percentage is still 0?

  I have an update query (updates a db on another server) that only ran for a couple of minutes, but …

  SkyBox

  3 replies

  15 years ago

  By: David Benoit

• Row to Column - Phone Numbers

  I am trying to do a query that is way over my head. I am trying to get phone numbers for student c…

  dixons

  2 replies

  15 years ago

  By: Orlando Colamatteo

• Row to Column - Phone Numbers

  I am trying to do a query that is way over my head. I am trying to get phone numbers for student c…

  dixons

  1 replies

  15 years ago

  By: WayneS

• using CTE in an update query

  With a lot of help from Lynn and Jeff, I created a CTE that calculates levels in a hierarchy of cou…

  pietlinden

  2 replies

  15 years ago

  By: pietlinden

• Insert data into a table from another table

  I have two tables as follow: Table: Addresses AddressIDAddress1 Address2 1123 West St …

  henryvuong1000

  3 replies

  15 years ago

  By: UMG Developer

• Problem with linked server

  Hi, I'm using linked server to SSAS that running on same machine. usually the linked server is work…

  kupy

  5 replies

  15 years ago

  By: Gangadhara MS

• SQL Mail

  In my maintenance plain I have a notification set-up to tell the operator the job is ended. The em…

  kd11

  10 replies

  15 years ago

  By: Brandie Tarvin

• ASP/ Express 5/ Win 2003 connection problem

  Hi I can’t seem to connect from a local or a remote web page via a connection string to an MS-SQL E…

  hugh-670144

  2 replies

  15 years ago

  By: hugh-670144

• ISDATE difference from client and server

  Hi, Can anyone help out me please. If I run select isdate('27/1/2011') from my local install of SQL…

  Stuart Davies

  13 replies

  15 years ago

  By: Michael Valentine Jones