T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Get value for specified date.

  Hello, I have a value change log table. CREATE TABLE #LogTable ( CustomerID int , LogDate date…

  tona3743

  1 replies

  15 years ago

  By: manub22

• Running Total and then every 20

  Hello SQL Server Community, I am trying to come up with a sql statement that will return only the r…

  brad.mason5

  5 replies

  15 years ago

  By: LutzM

• Insert Statment

  Hi I am trying to do an insert into a table (employer) where I am grabbing a max date from another …

  nigelc

  2 replies

  15 years ago

  By: nigelc

• Trigger update

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

  james.murphy

  3 replies

  15 years ago

  By: toddasd

• COunt difference

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

  tripri

  6 replies

  15 years 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

  15 years 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

  15 years 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

  15 years 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

  15 years 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

  15 years 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

  15 years 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

  15 years 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

  15 years 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

  15 years 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

  15 years ago

  By: michael.wanke