T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• T-SQL help to convert rows to columns

  Hi, We have multiple dealers and multiple locations in our database.A table named dealer_location l…

  sangeethu

  7 replies

  15 years ago

  By: LutzM

• Help with Update query

  Hi, I need to update a column in a table by comparing its date column with another tables date rang…

  sap55

  4 replies

  15 years ago

  By: sap55

• dynamic query

  I have a stored procedure that contains one statement that may or may not be needed depending on a …

  Magy

  2 replies

  15 years ago

  By: WayneS

• Customize SQL server 2008 system error

  I am developing a certain system and I want to track the system error and customize it for client…

  assefam

  4 replies

  15 years ago

  By: assefam

• Update Seq

  Guys, I have following table in which I am trying to figure out a way to update the seq column as p…

  am-244616

  4 replies

  15 years ago

  By: Koen Verbeeck

• CPU fluctuation in SQL

  I have a database with millions of records contain NEWS, at this time I have about 800 online users…

  dr_csharp

  7 replies

  15 years ago

  By: Gail Shaw

• Table pivot

  I have a table that looks like: DECLARE @Params AS TABLE ( ParameterID NVARCHAR(8) NOT NULL, Par…

  ioani

  12 replies

  15 years ago

  By: Jeff Moden

• Selecting only oldest date in a 2 table join

  My first post here, not sure if this is the right forum but here goes.... I have the following quer…

  Johnnymac

  8 replies

  15 years ago

  By: Johnnymac

• Bulk Insert Problem

  Hi I have a text file having new records with random columns... say example... 1,LASTNAME,FIRSTNAM…

  nagarajan.santhan

  3 replies

  15 years ago

  By: steve-893342

• a question about trigger

  hi, I want to create a triger that will run all the time after after a new database that was create…

  Aviad C.

  6 replies

  15 years ago

  By: Markus Summer

• Compare columns of same table

  Hello, I gota table called sampletable, with columns country varchar(100),input_country varhcar(100…

  Deepthy

  1 replies

  15 years ago

  By: HowardW

• Is there a better way to do this

  Hey folks, wondering if there was a better / shorter way to do this. ALTER PROCEDURE [dbo].[Catalog…

  james.arceri

  1 replies

  15 years ago

  By: james.arceri

• drop and create temptable

  Hi I Want to write a storeprocedure for droping a temptable and then create it again would you pl…

  nazaninahmady_sh

  1 replies

  15 years ago

  By: ColdCoffee

• drop and create temptable

  Hi I Want to write a storeprocedure for droping a temptable and then create it again would you pl…

  nazaninahmady_sh

  1 replies

  15 years ago

  By: Gail Shaw

• drop and create temptable

  Hi i want to drop a temptable and then create it again

  nazaninahmady_sh

  2 replies

  15 years ago

  By: ColdCoffee