T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Help Needed in dynamic sql

  Hi, below is my sample query declare @Query nvarchar(max) DECLARE @Names VARCHAR(8000) Declare @tab…

  KGJ-Dev

  10 replies

  10 years, 6 months ago

  By: ScottPletcher

• Need help on sql query

  Hello , I have a table like this in sql server 20018 ID | COLA | COLB | COLC | ---------------…

  dprasannain

  7 replies

  10 years, 6 months ago

  By: Luis Cazares

• One to Many relationship in Join performance issue

  Hi Friends, I have one query which is taking huge time to execute. below is a query used in source …

  Re1

  2 replies

  10 years, 6 months ago

  By: Ed Wagner

• Prevent Stored Procedure using bad execution plan

  Hi All, I have a scenario where my stored procedure which usually takes 5-6 min on average to execu…

  sam 55243

  10 replies

  10 years, 6 months ago

  By: Gail Shaw

• Data collection

  I have a servernames table with list of servers. SERVERNAMES_TABLE ABCD EFGH IJKL MNOP QRST UVQX YZ…

  mysscacc

  10 replies

  10 years, 6 months ago

  By: John Mitchell-245523

• Not able to insert data in table

  Hi, I have a table having 166 cols, and 7380000 records many indexes. index space 13 GB, Disk space…

  KcV

  10 replies

  10 years, 6 months ago

  By: MMartin1

• Rename a network file using xp_cmdshell

  Please help. I'd like to rename a network file by adding date to the file name. My script likes thi…

  joemai

  10 replies

  10 years, 7 months ago

  By: MMartin1

• How to Script all Triggers from DB into Text File?

  [font="Verdana"]:unsure: How to script triggers only and getting output in text files as same as SS…

  Abrar Ahmad_

  4 replies

  10 years, 7 months ago

  By: Brandie Tarvin

• Read 1st line of a file in t-sql

  I'm writing a script-running routine in t-sql. Long story. Yes, it has to be t-sql. So I have the f…

  robin.pryor

  2 replies

  10 years, 7 months ago

  By: Brandie Tarvin

• Get count of last consecutive rows with 0 value

  I have following data create table TestTable (id smallint identity (1,1), Score smallint ) GO INS…

  Atif

  2 replies

  10 years, 7 months ago

  By: Luis Cazares

• which way should I write JOIN Query ?

  HI, I have question for using 'joins' in sql server. i just want to know that which way would be be…

  KcV

  3 replies

  10 years, 7 months ago

  By: joeroshan

• Need help on Dynamic T-SQL

  I've 3 Tables as follow, CREATE TABLE [dbo].[crpt_Comparison_Operator]( [idx] [int] IDENTITY(1,1)…

  Qira

  8 replies

  10 years, 7 months ago

  By: serg-52

• After insert,Update,Delete Trigger needs to insert into same table trigger is running on

  Ok, SQL Server 2008. Problem as follows... I have a table of rates which must have the date range o…

  Charlottecb

  7 replies

  10 years, 7 months ago

  By: Sean Lange

• Need to remove a "group by" function from this SQL statement

  This statement was written by another person. It is not calculating the correct value. I want to …

  randyetheridge

  5 replies

  10 years, 7 months ago

  By: sgmunson

• Table design question

  Hi, Below my sample table schema, Create table Company (CompanyId int primary key identity(1,1),C…

  KGJ-Dev

  2 replies

  10 years, 7 months ago

  By: KGJ-Dev