T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Adding/subtracting columns to get total

  here is my line of sql (Vehicle.value + Vehicle.Extras_Value + Vehicle.Expenses + Vehicle.Another_T…

  thomasrichardson2000

  4 replies

  13 years, 9 months ago

  By: thomasrichardson2000

• any ideas on how to spead up this query?

  As the title says select id , count(distinct company) as CompanyCount , count(distinct district…

  erics44

  4 replies

  13 years, 9 months ago

  By: Lynn Pettis

• convert row to column in plsql

  hi friends i ve created on table create table rab(deptno number(33), job varchar(22)); insert in…

  raghuldrag

  6 replies

  13 years, 9 months ago

  By: Ant-Green

• read the current row and previous row & calculate difference reporting values over

  I am trying to write a script to read the current row and previous row per device and work out the …

  scott_lotus

  18 replies

  13 years, 9 months ago

  By: scott_lotus

• Update using more than one table

  Hi, I have 2 table as A(totalmarks, maths, english, class1) and there is another table B(class2) No…

  Shadab Shah

  2 replies

  13 years, 9 months ago

  By: Shadab Shah

• Filer on Period for Active Versions only.

  Hi, I have a scenario where I have a version table that holds multiple versions. One or more versio…

  Michael Tocik

  8 replies

  13 years, 9 months ago

  By: vinu512

• t-sql in sql 2000

  Can someone assist me on the t-sql. This is my current data: ID role unit nam…

  mtz676

  1 replies

  13 years, 9 months ago

  By: Lynn Pettis

• Insert records into one table form other table

  Hi friends, I have a situation where i need tocreate table and insert records into…

  komal145

  4 replies

  13 years, 9 months ago

  By: rVadim

• INSERT with ordered select

  I am trying to optimise a script for performing DELETES in a DW staging table. DELETES are not logg…

  Rasmus Remmer Bielidt

  4 replies

  13 years, 9 months ago

  By: Jason-299789

• "UPDATE" Is Not Updating Correctly

  I am executing the SQL Statements on SQL Server 2008 (SSMS). What am I missing? (I'm sure it's me, …

  EdA ROC

  9 replies

  13 years, 9 months ago

  By: EdA ROC

• Geography datatype problem in updation

  Hi I have a location table SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO…

  SQL006

  12 replies

  13 years, 9 months ago

  By: SQL006

• What is meant by set based programming?

  Hi all, I have come across various section on this website where it is mention that SQL Server is a…

  Shadab Shah

  34 replies

  13 years, 9 months ago

  By: Jason-299789

• Yet another rows to column question (sorry)

  Hi, I have read Jeff Moden's series on converting rows to columns but can't see how to do what I ne…

  Ulysses_Infinity

  7 replies

  13 years, 9 months ago

  By: Ulysses_Infinity

• When and where should i use left join or right join ?

  Hi I am newbie in the T-SQL Programming. Please anyone can explain to me when and where i should us…

  Jay Pete

  5 replies

  13 years, 9 months ago

  By: Dwain Camps

• Retrieve records with (more than one row of same type)

  For example I create some fake data about database files and retrieve only the databases with more …

  smallmoney

  7 replies

  13 years, 9 months ago

  By: Evil Kraig F