T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• T-SQL Rename Multiple Tables

  I am looking to rename a lot of tables using a wildcard, for example, the table names are: OrderIte…

  forefj

  8 replies

  13 years ago

  By: forefj

• Add column with previous days results

  Hi, Please help me out with the below query. We are calculating Exposure column (Hilighted in the q…

  ArjunaReddy

  3 replies

  13 years ago

  By: Mansfield

• Pivot and grouping question

  I posted this on the general thread but this looks like the better forum: I have a table with struc…

  emiranda 59653

  2 replies

  13 years ago

  By: emiranda 59653

• Pratical Advantage of Heap

  Hi all experts, Is there any practical advantage of using Heap as a storage instead of clustered in…

  Shadab Shah

  3 replies

  13 years ago

  By: Eric M Russell

• Need help on creating Left outer Join

  Hi All, Need your help to create a Left Out join on 2 tables, which will be based on the Period Cod…

  sudhirnune

  4 replies

  13 years ago

  By: ChrisM@Work

• What is "cost"?

  When the Query Analizer estimates the cost of a query as 5.2837628, is that 5.2837628 of something…

  dan-572483

  3 replies

  13 years ago

  By: Grant Fritchey

• Distinct Query Help

  I HAVE DATA LIKE THIS ID DATE PID 69…

  rocky_498

  4 replies

  13 years ago

  By: Dwain Camps

• Find Serial number in sql string

  So i need to query Active directory and get all the computer based on certian OS type, no problem d…

  Stubby Bunny

  10 replies

  13 years ago

  By: Dwain Camps

• Max or Top 1 more efficient

  I have a table with a month value and year value both ints. I need two things, the latest date and …

  tshad

  4 replies

  13 years ago

  By: ScottPletcher

• Dynamic query providing wrong output

  I have a table data_profile_stats which contains all possible information about all the tables and …

  rockstar283

  5 replies

  13 years ago

  By: Lynn Pettis

• Set-Based Solution to this Problem?

  Hello there! I've got an interesting situation I'm handling at present; I've developed a means of …

  Andrew Kernodle

  6 replies

  13 years ago

  By: Lynn Pettis

• Merge Statement over a linked server

  Does anyone know a way of running a MERGE statement across 2 tables over a linked server? Getting t…

  cgauntlett

  13 replies

  13 years ago

  By: Eric M Russell

• incrementing

  I have this table with these info: IDint Firstorderint Secondorderint Thirdorderint sequence…

  phamm

  4 replies

  13 years ago

  By: Sean Lange

• Is it possible to run a query to return the members of a database User group?

  Is it possible to run a query to return the members of a database User group?

  dndaughtery

  1 replies

  13 years ago

  By: Adi Cohn-120898

• How To Sum...

  I Having Following Table Structure.... Create Table Adding (ID int identity(1,1),Result int,ActualR…

  sarwaanmca

  4 replies

  13 years ago

  By: sharky