T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Get Latest Revision of Attribute Based on Date

  Hi all, First real post here although an avid reader of some of the posts. Mainly a DBA but started…

  UncleFredo

  3 replies

  13 years ago

  By: UncleFredo

• Update Column after Alter Table ADD column

  hi, I just came across an error, the cause of which is unknown to me. why would a TSQL : ----------…

  _rohit_

  3 replies

  13 years ago

  By: rajat.bet

• sql count

  I have a table like the following: Name Time1 Time2 Time3 leo 06:03 0615 08:13…

  leostrut

  2 replies

  13 years ago

  By: Cadavre

• update record from another record in same table

  Hi, I'm looking for the best way to update pkid 1 = pkid 2 update testTable set a.fname = b.fname f…

  Marcus Farrugia

  3 replies

  13 years ago

  By: OTF

• Converting particular set of Rows as Columns

  Converting one row as one Column is possible using Pivot. But is there any way to convert particula…

  GGadde

  4 replies

  13 years ago

  By: GGadde

• How to pass where condition as parameter of stored procedure

  How to pass where condition as parameter of stored procedure

  sidharthgs6

  4 replies

  13 years ago

  By: Gail Shaw

• Hot to Get Cumulative Total..

  Hi Friends... I Having Table For The Following Structure.. Create Table EmpProcessDetail ( EmpId …

  sarwaanmca

  2 replies

  13 years ago

  By: sarwaanmca

• Trying to improve the vIew performance

  I have which im looking to optimize ... I have tried whatever i could think like Creating indexes, …

  meetvini.reddy

  1 replies

  13 years ago

  By: Sean Lange

• XML Question (?)

  Hi, Let's say I have the following table with just 1 record: SELECT Field1, Field2, Field3 FROM tbl…

  btio_3000

  5 replies

  13 years ago

  By: btio_3000

• Combine date from two different date ranges in one dataset

  Hello all, I have the following dataset that I am using: select HourOfTheDay ,sum(NumberOfOrdersI…

  robert.wiglesworth

  2 replies

  13 years ago

  By: robert.wiglesworth

• problem with join T-Sql

  i have customer table and it have 1 foreign key from other table in it then i have service table th…

  vahid.arr

  7 replies

  13 years ago

  By: MMartin1

• Comparing figures based on relative date

  Hi All I'm having trouble working out a solution to the following issue: I have a table containing …

  Paul Munter

  19 replies

  13 years ago

  By: MMartin1

• Top 2 On Child Table

  I have two tables, one Master, one Detail. I'm trying to build a query to get the top 2 products by…

  TcW_1978

  2 replies

  13 years ago

  By: TcW_1978

• Add 2 values from 1 table

  Morning all Good someone offer the best way to do this. I want to add 2 values from 1 table. Exampl…

  MickyD

  4 replies

  13 years ago

  By: MickyD

• T-SQL Greatest function workarounds - timing tests

  EDIT: About four posts down is an expanded test script that if you get the chance to run for timing…

  Evil Kraig F

  15 replies

  13 years ago

  By: Mark Cowne