T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Replacing a string when the value is found in a table

  Hi guys, I'm trying to create a function where I can pass a string value that will be used for sea…

  Jani Lane

  4 replies

  12 years, 11 months ago

  By: kapil_kk

• A Pivot, but not exactly.

  I have a table that could look like the following: ID FK_ID Value 1 100 …

  TheGreenShepherd

  4 replies

  12 years, 11 months ago

  By: TheGreenShepherd

• Making Query SQL 2000 compatable

  I have a query i wrote for 2008 to get the top 3 salesPeople per territory by their total sales. It…

  winston Smith

  3 replies

  12 years, 11 months ago

  By: ScottPletcher

• 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

  12 years, 11 months 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

  12 years, 11 months 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

  12 years, 11 months 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

  12 years, 11 months 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

  12 years, 11 months 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

  12 years, 11 months 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

  12 years, 11 months 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

  12 years, 11 months 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

  12 years, 11 months 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

  12 years, 11 months 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

  12 years, 11 months 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

  12 years, 11 months ago

  By: MMartin1