SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• selecting columns and rows from pivot table

  I have this table previously saved to the db from a pivot result baseyear__year1__count1__year2__co…

  barlet

  1 replies

  9 years ago

  By: Jeff Moden

• t-sql 2012 compare column to parameter value

  In an existing t-sql 2012 stored procedure, I want to add a new parameter called @newparam defined …

  dianerstein 8713

  3 replies

  9 years ago

  By: Ed Wagner

• Stored Procedure history

  Hi AllIs there anyway to get the stats (logical reads, physical reads, elapsed time etc) of the las…

  SQLSACT

  7 replies

  9 years ago

  By: SQLSACT

• Adding conditional logic, help wanted

  Hi all, I want to add a couple of features to my code,  to add a flag column and then add "If.…

  JaybeeSQL

  9 replies

  9 years ago

  By: JaybeeSQL

• History snapshot

  Hi, I've scenario  to show "as on status" similar to monthly snapshot. Below is the table wher…

  gugan_ta

  4 replies

  9 years ago

  By: shahm10

• SQL server 2012 - format change functionality

  I need to bulk insert an Excel file into my Sql server 2012 DB.Since I can be only able to bulk ins…

  divyashreenivasan

  2 replies

  9 years ago

  By: NorthernSoul

• Is my avoidance of UPDATE/DELETE CASCADE on foreign key relationships valid?

  Our database's employee table has the “Username” column as its primary key – this matches their Act…

  Andrew P

  3 replies

  9 years ago

  By: Andrew P

• Need to keep a value in a column static when another column receives a value

  I want to keep a value in my column to remain the same value when a value in another column changes…

  Zososql

  5 replies

  9 years ago

  By: caffeinated

• t-sql 2012 split and locate unique messages

  In a t-sql 2012 database, I am suppose to count the number of times each 'canned' message is used f…

  dianerstein 8713

  2 replies

  9 years ago

  By: Ed Wagner

• Check multiple condition in sql query

  Hi All, I have a table in which customer profile details such as name, address, dob etc are stored.…

  devesh.hassani

  5 replies

  9 years, 1 months ago

  By: jcelko212 32090

• Highest value supported by 2 of 3 columns

  Consider a table consisting of an ID number and 3 columns of scores (Score1, Score2, Score3).  …

  ArcticEd32

  6 replies

  9 years, 1 months ago

  By: ArcticEd32

• Commercial Index Analysis Tool

  I'm looking for a tool that can look at all of the indexes on a database and make solid recommendat…

  Indianrock

  2 replies

  9 years, 1 months ago

  By: Grant Fritchey

• t-sql 2012 parse out multiple values in one field that is varchar(1200)

  In a t-sql 2012 database, I am suppose to count the number of times each 'canned' message is used f…

  wendy elizabeth

  12 replies

  9 years, 1 months ago

  By: Jeff Moden

• What does the $ mean in this calculation?

  I have a stored procedure that has a calculation the looks like this: [Total Minutes] = SUM(CONVERT…

  jerry-621596

  2 replies

  9 years, 1 months ago

  By: Gail Shaw

• Creating a temp table with dynamic SQL

  This is a weird one. We were sure we had it working before we changed the sizes of the data types, …

  Brandie Tarvin

  19 replies

  9 years, 1 months ago

  By: Brandie Tarvin