T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 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, 10 months ago

  By: Evil Kraig F

• OVER PARTITION BY

  Hey guys, I am having trouble with this OVER PARTITION BY... Here is some sample code to test on: C…

  asm1212

  8 replies

  13 years, 10 months ago

  By: Lynn Pettis

• Asterisk in varchar field

  I'm attempting to store a string of SQL in a varchar field. I want to include the '*'. The purpose …

  lduvall

  6 replies

  13 years, 10 months ago

  By: lduvall

• comma in SQL

  I just found out we have a sql script to create a table. CREATE TABLE [dbo].[DayList]( [DateID] […

  sqlfriend

  21 replies

  13 years, 10 months ago

  By: GSquared

• Update One Table With Values From Other Table

  Hi, I have 2 tables as Table1( Date, Product, Qty ). The data in that table is Date Pro…

  Shadab Shah

  5 replies

  13 years, 10 months ago

  By: Ant-Green