SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Query to see value matching values from two columns

  The situation is I have a table that stores my server names and their node names (all two node) in …

  Stamey

  2 replies

  8 years, 6 months ago

  By: Stamey

• Insert new row into a table, but move the old row to an archive table. Trigger or SSIS? Table partitioning?

  Hello,Basically the the subject line says it all.  I have been tasked with populating an empty…

  Duran

  7 replies

  8 years, 6 months ago

  By: Ken McKelvey

• THROW won't continue a while loop

  I decided to try THROW instead of RAISERROR but it doesn't seem to be designed to allow something l…

  Indianrock

  3 replies

  8 years, 6 months ago

  By: Indianrock

• Extracting Episode Start and End Dates From Multiple Assignments

  Hello, We have a Staff/Program Assignment that captures to whom and what program a particular patie…

  adam-639168

  7 replies

  8 years, 6 months ago

  By: ChrisM@Work

• Filed with Return Carridges

  Hi There,  I have a field in my database table called ADDRESSFORMAT1,The LodgeStreetTownPostco…

  TSQL Tryer

  2 replies

  8 years, 6 months ago

  By: sgmunson

• Querying Postcodes gracefully

  Recently I've been getting an influx of requests asking me if I can find clients on our system that…

  Thom A

  13 replies

  8 years, 6 months ago

  By: Thom A

• records repeat based on condition in sql server

  I have a question in SQL Server. Table : emp CREATE TABLE [dbo].[emp](  [id] [int] NULL, …

  asrinu13

  3 replies

  8 years, 6 months ago

  By: Eirikur Eiriksson

• How to build a field name in a select statement

  I'm about to build aselect statement as a string and execute it so I can create the column namesfro…

  BRP

  8 replies

  8 years, 6 months ago

  By: BRP

• A transport-level error has occurred in local VPN connection, But not in RDP.

  Hello Experts, I am trying to alter a sp in a remote server connected from a local server (through …

  C.K.Shaiju

  13 replies

  8 years, 6 months ago

  By: ez4321

• Need to reduce pain in my eyes, i.e. to find out which values are different in 2 tables ( out of 155 column(s) , both tables with identical DDL and same # of rows

  I have 2 tables. same structure. 14.2 million rows in each. 155 columns, 120 of which are varchars.…

  VoldemarG

  6 replies

  8 years, 6 months ago

  By: Thomas Rushton

• How to calculate cents for employees

  I have a case where the total amount is divided by number of employees.( EMployees belongs to US an…

  mcfarlandparkway

  5 replies

  8 years, 6 months ago

  By: Phil Parkin

• How to flatten a normalised hierarchy table?

  I have an OrgChart table that looks something like this: PositionCode PositionName ParentCode …

  j.gale1

  2 replies

  8 years, 6 months ago

  By: Jeff Moden

• Automatically Adding New Databases to Availability Group

  All, Here's a bit of code I just put on a StackOverflow answer, so people might find useful. It aut…

  Steve Gray-464702

  6 replies

  8 years, 6 months ago

  By: SQL_Hunt

• CASE, CONVERT NULL to 'Unknown' in a column with a datatype of int.

  Hello,I have a column, and the data type is int, but there are some NULL's in there, and as I am re…

  Duran

  5 replies

  8 years, 6 months ago

  By: Duran

• Do you need an order by when selecting TOP N from a clustered index?

  Lets say you have a table with 2 columns, the first, an identity primary key column, the second a f…

  rob.lewis 86087

  10 replies

  8 years, 6 months ago

  By: TheSQLGuru