SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• To T-SQL or not to T-SQL?

  Hi, I have about 300mb of text files. Each one is named like XXXXXX_XXX.txt, where the 6 character …

  sqldriver

  23 replies

  11 years, 10 months ago

  By: sqldriver

• trouble with attempt to determine growth of DB

  Hi all I am having a bit of trouble with the following, I have a table for tracking DB growth and a…

  Sl33py

  1 replies

  11 years, 10 months ago

  By: Gazareth

• Finding duplicate records

  Hello all, I am trying to build a select statement that will 1). find records where a duplicate fi…

  kwoznica

  3 replies

  11 years, 10 months ago

  By: Dwain Camps

• Select a part of text from the xml

  I have an xml stored in a coulum of a table and I use the following query to extract an xml element…

  SqlServerNinja

  1 replies

  11 years, 10 months ago

  By: Luis Cazares

• Grouping by pairs, order agnostic

  I'm guessing there's probably a simple and elegant way to accomplish this in T-SQL, just not sure h…

  SQL_Bob

  11 replies

  11 years, 10 months ago

  By: Dwain Camps

• Audit table design

  Hello all, I am building the backend of a web application and came across a scenario for the audit…

  kwoznica

  2 replies

  11 years, 10 months ago

  By: Jeff Moden

• SQL Server Stored Procedure are argument for Select where value IN Statement

  I have a stored procedure that ends with Select columnname from tablename order by ordercolumn We …

  jerryw 5810

  11 replies

  11 years, 10 months ago

  By: Luis Cazares

• maintenance plan skips to run

  I have created a job through maintenance plan scheduled to run everyday. It skipped to run on the 1…

  atulyan.aries

  2 replies

  11 years, 10 months ago

  By: SQLRNNR

• SQL for adding flags depending on criteria

  I have a data output with many rows. In order to group things with flags, I do this in excel using…

  macdca

  17 replies

  11 years, 10 months ago

  By: TomThomson

• regarding replace function

  hi all i have column in table which contains tabs and " i want replace with space i am using repalc…

  mpradeep23

  13 replies

  11 years, 10 months ago

  By: TheSQLGuru

• T-sql help

  HI, I have these SEELECT statments. I do have the data in the table CheckNumbers_DM_DeleteAfter_…

  movvap

  9 replies

  11 years, 10 months ago

  By: Umer Akram

• While Lop in Place of Cursor

  Hi All, I have a table called Table1 where I have five fields like Tableid, Processigndate, Amount,…

  niladri.primalink

  4 replies

  11 years, 10 months ago

  By: Jeff Moden

• XML into SQL TABLES

  I have a database that contains one column and inside column thes data listed below, I want to inse…

  Maique

  2 replies

  11 years, 10 months ago

  By: Maique

• Sub-Query Help for an update statement

  I am trying to Write an update string for individual partID's. I wrote this query below but it isn…

  Dieselbf2

  5 replies

  11 years, 10 months ago

  By: Dieselbf2

• Need some advice on increasing performance of a stored procedure

  I have a stored procedure that is timing out. I have added indexes but it still isn't working as it…

  dndaughtery

  7 replies

  11 years, 10 months ago

  By: TheSQLGuru