T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How To Avoid The Duplicate Records....

  Hi Friends... I Having Table For The Following Structure.. create Table EmployeeDet (EmpID int,EmpN…

  sarwaanmca

  12 replies

  12 years, 11 months ago

  By: Jeff Moden

• No result set

  I have this query: declare @controlnumber varchar(13) set @controlnumber = '0210300000001' select *…

  phamm

  1 replies

  12 years, 11 months ago

  By: Lynn Pettis

• Stored Proc Novice Help

  Hi all, I'd be really grateful if someone could help me (probably something very basic I'm missing!…

  WWDMark

  2 replies

  12 years, 11 months ago

  By: WWDMark

• get max

  CREATE TABLE [dbo].[Table_A]( [id] [smallint] NULL, [name] [varchar](50) NULL ) ON [PRIMARY] GO C…

  sstacy7

  2 replies

  12 years, 11 months ago

  By: Kingston Dhasian

• Does a "Begin... End" in a While loop act as a transaction?

  Reading Lynns comments in this topic: http://www.sqlservercentral.com/Forums/Topic1447456-391-1.asp…

  jasona.work

  2 replies

  12 years, 11 months ago

  By: jasona.work

• output understanding for most memory reads?

  Hi.. Top procedures memory consumption per execution as below capture script SELECT TOP 100 * FROM …

  SQL Galaxy

  1 replies

  12 years, 11 months ago

  By: Mansfield

• Search data.

  Hi, I want to search student information depending upon the passing either values of firstname,last…

  abhas

  3 replies

  12 years, 11 months ago

  By: Sergiy

• Dynamic export to flat files by date

  Hello all, I am tasked with archiving some very large tables. There are about 30 tables that I need…

  SQL Wayne

  2 replies

  12 years, 11 months ago

  By: SQL Wayne

• Error when Cascade Update on child tables

  Hi There is a DB with 4 tables (3 master tables and one is detail which has daily information) Tabl…

  armm1388

  1 replies

  12 years, 11 months ago

  By: Lynn Pettis

• Insert statement error?

  Hi, what is wrong this code? pl. suggest create table databaseSize ( DatabaseName varchar (100), …

  SQL Galaxy

  1 replies

  12 years, 11 months ago

  By: Steve JP

• Recursion 100 has been exhausted

  Hi I have a query below and I get The maximum recursion 100 has been exhausted, how do I fix or go …

  hoseam

  6 replies

  12 years, 11 months ago

  By: Eric Nordlander

• Nested Stored Procedure does not work as expected

  I have 2 Stored Procedures Procedure A and Procedure B. Both Procedures have @year as parameter and…

  Nilesh-788004

  1 replies

  12 years, 11 months ago

  By: Sean Lange

• Recursive CTE

  Hi, I have a query below I'm doing recursive CTE. The logic behind it is, Client(John) can be linke…

  hoseam

  6 replies

  12 years, 11 months ago

  By: geoff5

• The maximum recursion 100 has been exhausted

  Hi I have this query below, CTE code. and I get this error: The statement terminated. The maximum r…

  hoseam

  2 replies

  12 years, 11 months ago

  By: David McKinney

• Urgent Help: Validating Updation of a column

  if OBJECT_ID('..test')>0 drop table test create table test (id int , name varchar(2) ); Go inser…

  Mr. Kapsicum

  5 replies

  12 years, 11 months ago

  By: Kingston Dhasian