T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• 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

  9 years, 9 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

  9 years, 9 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

  9 years, 9 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

  9 years, 10 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

  9 years, 10 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

  9 years, 10 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

  9 years, 10 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

  9 years, 10 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

  9 years, 10 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

  9 years, 10 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

  9 years, 10 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

  9 years, 10 months ago

  By: KGJ-Dev

• return results ignoring nulls

  I am joining 3 tables in SQL. There should always be a AccountID for ProductID1, but not necessari…

  Erin.

  6 replies

  9 years, 10 months ago

  By: Erin.

• Stuck with a unique JOIN scenario

  I have a scenario where I need to return values in a very unique way given the schema that is in pl…

  Steven Aiello

  5 replies

  9 years, 10 months ago

  By: Steven Aiello

• summing alpha columns

  Wanting to do something like: Select * from tbl having cast(isnull(Column1,0) as int) + cast(isnull…

  fmarler

  8 replies

  9 years, 10 months ago

  By: Luis Cazares