SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• How to append 'Go' clause to 10k lines of code?

  I have 10k indexes I need to rebuild and each time the script reaches an error it stops all further…

  smitty-1088185

  3 replies

  11 years ago

  By: k_biniyam

• LOGSHIPPING IN SQL 2012 ,WANT TO SHRINK LOG FILES

  Hi, We are configured the logshipping around 80 gb database.log file growth up to 60 gb .want to sh…

  pradeep.k 50453

  1 replies

  11 years ago

  By: Perry Whittle

• Team Scdule with Round Robin

  Hi to all i have to schedule 10 team within expected date range Like 01/01/2015 to 10/01/2015 (dd/m…

  Chirag#

  1 replies

  11 years ago

  By: ChrisM@Work

• MERGE UPDATE INSERT not working as hoped

  edit: sorry this is happening in SQL Server 2008 R2, but it will also apply here. I have need to in…

  KoldCoffee

  2 replies

  11 years, 1 months ago

  By: KoldCoffee

• T-SQL Script for Integer values

  I'm looking for a script that identifies max values used in a table for all smallints, ints and big…

  d.carpenter

  3 replies

  11 years, 1 months ago

  By: Eirikur Eiriksson

• Truncate MS Access Table from Visual Studio using SQL code

  I am building a Visual Sudio process that will Truncate and load data to an Access database (2010) …

  Howard C. BAchtel-438731

  2 replies

  11 years, 1 months ago

  By: Howard C. BAchtel-438731

• Cast Real to Money

  When I cast Real to Money it makes some changes to the number DECLARE @i REAL = 989500000.00; SELE…

  farax_x

  2 replies

  11 years, 1 months ago

  By: farax_x

• How to merge multiple rows into one row

  I have a table that looks like this ... idtype_codephone_num 11111-111-1111 12222-222-2222…

  Russ1of5

  2 replies

  11 years, 1 months ago

  By: Russ1of5

• Pivot with a twist

  CREATE TABLE [dbo].[Mytable]( [RegYear] [varchar](12) NOT NULL, [StudentUID] [int] NOT NULL, [Qu…

  kevin_nikolai

  2 replies

  11 years, 1 months ago

  By: serg-52

• How to format unformated phone numbers Please...,

  Hello Good Evening, i have a phone number table which has single column in it with different style …

  asita

  19 replies

  11 years, 1 months ago

  By: DonlSimpson

• Filter Results?

  Hi Trying to build a list of order numbers based on stock availability. The data looks something li…

  marc.heidemann

  1 replies

  11 years, 1 months ago

  By: marc.heidemann

• Get Row value as Column Header

  Hi, I have two tables namely lu_parameter and tbl_param_values. The lu_parameter table consists of …

  karthik82.vk

  9 replies

  11 years, 1 months ago

  By: karthik82.vk

• reset running total to x amount

  Hi Can anybody help me please? I need to calculate running total which resets when reached to 16, a…

  faisal_xyz

  4 replies

  11 years, 1 months ago

  By: Dwain Camps

• SQL Membership provider

  I am trying to fill a Gridview utilizing the built in aspnet_Membership_FindUsersByName stored proc…

  rwheway

  2 replies

  11 years, 1 months ago

  By: rwheway

• Get ID from look up table based on value passed to function

  Hi, I have a requirement regarding a color combination data. I have a lookup table that holds a col…

  karthik82.vk

  2 replies

  11 years, 1 months ago

  By: karthik82.vk