T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• XACT_ABORT with recursive stored proc

  Hi, we use XACT_ABORT to rolback if statements failed. I have a scenario where I have a stored proc…

  thbaig

  1 replies

  12 years, 10 months ago

  By: Orlando Colamatteo

• Derived field help

  Hi My problem is I have a view named Forecast with data in that looks like this: RowID Register…

  Canazei65

  10 replies

  12 years, 10 months ago

  By: Canazei65

• Or clause in an OUTER join killing performance

  One of our developers sprung this on me and I have been trying to rethink it...because that OR clau…

  Studdy05

  2 replies

  12 years, 10 months ago

  By: Studdy05

• creating a view to include fields which are NULL

  Our webiste has several contact forms which all go into the same table. We therefore have to create…

  mrichardson 57577

  3 replies

  12 years, 10 months ago

  By: Phil Parkin

• Update multiple column NULL values

  Hi guys, I have one object which present 26 columns and in that object there are almost 1000+ rows …

  Sagar Sawant

  7 replies

  12 years, 10 months ago

  By: John Esraelo-498130

• Building an SQL statement

  I am trying to build my where section on the fly... going to place this inside of a stored proc tha…

  dwilliscp

  6 replies

  12 years, 10 months ago

  By: laurie-789651

• Case Statement Problem

  Can someone please help me with this stored procedure. SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER O…

  schauhan13

  7 replies

  12 years, 10 months ago

  By: schauhan13

• DELETE using INNER JOIN

  if exists (select * from tempdb.dbo.sysobjects o where o.xtype in ('U') and o.id = object_id(N'te…

  JMI

  20 replies

  12 years, 10 months ago

  By: sidhu.miku

• Update records with Count() function

  Hi all, My SQL 'Table1' needs an update to a single column 'STCount'. The update needs to be applie…

  DerbyNeal

  2 replies

  12 years, 10 months ago

  By: ChrisM@Work

• Logshipping database

  Hi Everybody, In our envirnoment we had logshipping database which is in suspect mode. when i res…

  shrishasqldba

  1 replies

  12 years, 10 months ago

  By: Ant-Green

• Removing tags stored in a ntext field

  Hello everyone I have a table with an ntext field that contains many tags of different types. I w…

  jshahan

  12 replies

  12 years, 10 months ago

  By: jshahan

• Code runs in Query Analyzer... but not as a job

  A developer showed me a very small sql server t-sql script he wrote (5 SQL lines). It loads informa…

  rummings

  7 replies

  12 years, 10 months ago

  By: cphite

• I want to delete those data from tables Orders and customers which is not selecting in below join

  Hi, In my case I want to delete those data from tables Orders and customers which is not selecting …

  forsqlserver

  24 replies

  12 years, 10 months ago

  By: Lynn Pettis

• Insert into SELECT ...., @@rowcount = ?

  Hello everyone, I am running a statement: INSERT INTO LinkedServer.DBName.dbo.TableName (col1, col2…

  touchmeknot

  3 replies

  12 years, 10 months ago

  By: Matt Miller (4)

• Need expected result set

  I am currently having below table and sample rows. CREATE TABLE ORDERS (Year int, Month int, ORDER…

  rhythmk

  3 replies

  12 years, 10 months ago

  By: rhythmk