T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Trigger update

  Hi I have come up with this ALTER TRIGGER Trigger6 ON dbo.ReceiveOrder FOR UPDATE AS UPDATE Con…

  james.murphy

  3 replies

  14 years, 9 months ago

  By: toddasd

• COunt difference

  Hi For me count 207 rows when i use SELECT sysobjects.Name , sysindexes.Rows FROM sysob…

  tripri

  6 replies

  14 years, 9 months ago

  By: steveb.

• Alter Index Script for all the user databases.

  I have a Script for Re-Org Indexes on all user databases. Its like this USE [DB1] GO ALTER INDEX [I…

  Minnesota - Viking

  3 replies

  14 years, 9 months ago

  By: Suresh B.

• Tricky Select statement

  I need to select all rows from a table that has the same data in column 1 but based on if specific …

  npeters 86796

  5 replies

  14 years, 9 months ago

  By: The Dixie Flatline

• PLz help to fix the error

  Asked by amedexitt in MS SQL Server Tags: 0x80040155, error, failed, package, ssis Hi There: I'm tr…

  sqlmaverick

  1 replies

  14 years, 9 months ago

  By: PaulB-TheOneAndOnly

• need MasterId from comma seperated column values

  select * into #test1 from ( select 1 ID, 'Dog, Cat' Animal, 'Pet' TypeOfAnimal union select 2, 'Tig…

  sudhanva

  3 replies

  14 years, 9 months ago

  By: Orlando Colamatteo

• Why does this sql not return an error on execution?

  Hi, Why does this sql below not return an 'Invalid column' error when executed? Is it a bug or by d…

  j.a.c

  2 replies

  14 years, 9 months ago

  By: j.a.c

• FOR XML Query

  Hi Folks, Need some quick help here. I have a query that returns a single column. I need to prese…

  DB Dude

  6 replies

  14 years, 9 months ago

  By: DB Dude

• Help with query

  I am having trouble getting a query worked out. I have a table that has 2 columns, item and code. …

  vmon

  1 replies

  14 years, 9 months ago

  By: The Dixie Flatline

• Split a field with duplicate seperators

  Hi, I have the following data in a field. RNL00:123456-3:1 i need to extract the last character fol…

  LoosinMaMind

  10 replies

  14 years, 9 months ago

  By: LoosinMaMind

• How to avoid convert function in the where clause???

  I am trying to fix the performance of an application. they had several queries where they used func…

  chandan_jha18

  27 replies

  14 years, 9 months ago

  By: chandan_jha18

• Return the tokens matched in addition to the rows with a full text search query

  I am working on a SQL Server 2008R2 query that leverages full text searching to find the appropriat…

  michael.wanke

  2 replies

  14 years, 9 months ago

  By: michael.wanke

• Converting Oracle SQL statements to SQL 2008

  Oracle SQL: SELECT (NVL(v1.non_credit,0) - NVL(v2.credit,0)) settle_amt from (SELECT sum((trans_a…

  Patti Johnson

  11 replies

  14 years, 9 months ago

  By: Patti Johnson

• How to Compare Month\date

  Hi All, i have below requirement, we are checking only month and date. If the FYME is < or = pay…

  sambireddy chirra

  5 replies

  14 years, 9 months ago

  By: kramaswamy

• Need help with store proc.....that great

  Hi, I need to write a store proc to move the data from table1 to table2. Both tables are in differe…

  sqlmaverick

  2 replies

  14 years, 9 months ago

  By: GSquared