SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• MIGRATION FROM SQL 2005 TO SQL 2012 (SP_MAKEWEBTASK)

  hi, we are going to migrate from sql 2005 to sql 2012 In testing we are facing issue in sp_makewe…

  pradeep.k 50453

  2 replies

  11 years, 10 months ago

  By: EdVassie

• trying to add third grouping set to return average aggregate

  Hi, i'm building a query to return metrics that will drive 3 seperate pivot tables showing 1. Total…

  KoldCoffee

  13 replies

  11 years, 10 months ago

  By: KoldCoffee

• finding break in sequence

  I need to be able to identify breaks in a sequence so I can evaluate the data more correctly. In t…

  aadkins 91421

  9 replies

  11 years, 10 months ago

  By: TheSQLGuru

• SQL Server 2012 Gotcha with Identity Column

  We just ran across a gotcha with our SQL Server 2008 R2 to SQL Server 2012 migration. One of the ap…

  shew

  14 replies

  11 years, 10 months ago

  By: Nevyn

• SQL Guru question: Pattern matching and data conversion

  I have a table ("MyData") with string columns that have nvarchar data that looks like this: ColA --…

  ericjorg

  8 replies

  11 years, 10 months ago

  By: Solomon Rutzky

• finding what table a user-created statistics is located

  I can easily find user created stat in a databaseSELECT * FROM DB.sys.stats WHERE user_created=1 Bu…

  SQL_Padre

  2 replies

  11 years, 10 months ago

  By: Lowell

• SQL Query

  SalesOrder SalesOrderIDItemIDSalesAmount 1101100 1104120 2101200 2103225 3101200 3102…

  nrajeshkumar

  8 replies

  11 years, 10 months ago

  By: Lempster

• Error message - aggregate function and group by clause

  Hi, I'm trying to write a query to select various columns from 3 tables. In the where clause I use …

  helmi

  8 replies

  11 years, 10 months ago

  By: Luis Cazares

• Increment query based off two tables

  Hello! I have two tables with this info: TABLE 1 COL1 COL2 COL3 AAA BBB CCC QQQ WWW EEE AAA SSS DDD…

  John215

  5 replies

  11 years, 10 months ago

  By: Dwain Camps

• Query Statement Help with data Type as Integers

  Is there a way to query all the columns in a database that have the data type as Integer

  Dieselbf2

  11 replies

  11 years, 10 months ago

  By: TheSQLGuru

• Subtotal help in recursive query

  Hi experts, i've following data in a recursive query: Par_IdIDABCDEFLevel Null02264600…

  LittleTony

  6 replies

  11 years, 10 months ago

  By: Hunchback

• Multiple CASE Statements in SQL Server 2012 Dev Ed

  Hello, How do I properly write a CASE statement for the following business logic: I want three of t…

  Sanjeev Jha-475652

  2 replies

  11 years, 10 months ago

  By: Russel Loski

• SEQUENCE Problems

  Hello. I've started using a SEQUENCE in a table instead of an identity. I seem to be experiencing p…

  David Lafayette

  5 replies

  11 years, 10 months ago

  By: anibaldavidacosta

• Filter Duplicates based on string

  CREATE TABLE #Names ( ID INT IDENTITY(1,1), NAME VARCHAR(100) ) INSERT INTO #Names VALUES ('S-SQLXX…

  PSB

  1 replies

  11 years, 10 months ago

  By: Luis Cazares

• Many to Many Recursive CTE

  Hi I have posted in this section because it is a 2012 database I am working against and could not …

  PugMaster

  8 replies

  11 years, 10 months ago

  By: KS