SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• XML ordering column in pivot

  l after inserting data to a table , i am facing difficulty to retrieve data as pivot.  declare…

  mxy

  5 replies

  9 years ago

  By: Thom A

• SELECT & UPDATE statements resulting in different counts??

  I'm trying to perform a simple update to a field, but many of the records I intended to update, wer…

  Goalie35

  3 replies

  9 years ago

  By: Gail Shaw

• Dynamic SQL Query Not Fetching Records based on where Not In condition

  Hello All ... Hope You all are Good .. Actually i am facing problem while working on dynamic sql wi…

  sunilchand

  13 replies

  9 years ago

  By: Lynn Pettis

• Next row begins

  Ok so what I am wanting to do is fill in rows with information that is missing from a file. I read …

  cbrammer1219

  18 replies

  9 years ago

  By: cbrammer1219

• Accidentally updated all records

  I have a small table in Dev (contains 38 rows) and I ran an update statement but forgot the where c…

  NewBornDBA2017

  4 replies

  9 years ago

  By: NewBornDBA2017

• Windowing function - partition by .. finding the right partition

  Hi, I am trying to get a row_number windowing function to work the way I hope it could work .. Usin…

  bleroy

  2 replies

  9 years ago

  By: bleroy

• Basic Trigger Amendment

  Hi folks, Please can you advise me on how to log an old value in a audit table via a trigger. I cur…

  DSC123

  5 replies

  9 years ago

  By: DSC123

• How to get top and bottom rows from where condition

  Hi, Create Table Test(Id int,name varchar(80)) Insert into Test Select 1, 'A' union AllSelect 2, 'B…

  Sangeeth Raj

  13 replies

  9 years ago

  By: Sangeeth Raj

• time - missing colon :

  i have received a legacy data files from vendor time values are sent without semicolon , can you he…

  mxy

  7 replies

  9 years ago

  By: Jeff Moden

• dynamic table creation with set of columns

  Hi , I have a list of records that are actually list of columns and table name that are coming from…

  pnpsql

  1 replies

  9 years ago

  By: sgmunson

• SQL mail

  i have a table  test , i need to send an email in HTML format provided in attachment.CREATE TA…

  mxy

  4 replies

  9 years ago

  By: mxy

• How to better join my queries and prevent usage of functions

  Hello, I have this structure and these datas :For now, I use sub-queries, like this :Select dem2.Id…

  team.bernard

  5 replies

  9 years ago

  By: drew.allen

• Case Statement Help

  CREATE TABLE #INPUT(ADDRESS_1 VARCHAR(200),IS_PO_BOX BIT) INSERT INTO #INPUT Values ('PO BOX 123',…

  koti.raavi

  4 replies

  9 years ago

  By: jcelko212 32090

• Stored procedure is a lot slower than standard query

  Hi all I've got a query that runs (outside a stored procedure) in around 8 seconds to return 45609 …

  richardmgreen1

  11 replies

  9 years ago

  By: richardmgreen1

• update column based on max date for each employee

  Kinl provide the update query for update column TeamId based on max date for each employee Sce…

  Shanmuga Raj

  22 replies

  9 years ago

  By: Jeff Moden