SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• SQLServer2012 Locking

  I have a insert stored procedure that inserts data with the values passed as parameters to this pro…

  TSQLLearner2014

  11 replies

  11 years, 5 months ago

  By: Gail Shaw

• Fetch Next value ignoring nulls

  Hi, I'm trying to find the previous / next values of a field when it is having null values. I'm no…

  Anamika

  6 replies

  11 years, 5 months ago

  By: Anamika

• check that column has one and only one value and the value is the value I want

  Is there an elegant way to solve the question "I only want to show widgets that have a value "Y" an…

  Tobar

  15 replies

  11 years, 5 months ago

  By: Sachin Nandanwar

• Select query error

  Hi everyone. I have a query that does return results , but returns an error. This is the SQL statem…

  MickyD

  4 replies

  11 years, 5 months ago

  By: TheSQLGuru

• Return Count

  Hi all, I have a scenario in which I need to capture count of rows returned by execution of stored …

  kapil_kk

  14 replies

  11 years, 5 months ago

  By: Eugene Elutin

• Recursive query to explode a BOM

  Hi, I'm trying to use a recursive query to find path between assembly and parts. The BOM is similar…

  phpons

  1 replies

  11 years, 5 months ago

  By: sivaj2k

• Constraint question

  I've added an IsActive bit field to a slowly changing dimension, and I want to enforce the rule tha…

  TJ Heath

  4 replies

  11 years, 5 months ago

  By: TJ Heath

• Removal of Selected Indexes/Script Index Create for List of Indexes

  Hi all, I'm working to improve performance on a database I've inherited, and there are several thou…

  Replicant21

  5 replies

  11 years, 5 months ago

  By: ScottPletcher

• Trouble creating dynamic pivot table

  Hello there, I am having trouble figuring out why the following code throws an error: declare @…

  vecerda

  6 replies

  11 years, 5 months ago

  By: vecerda

• Derived tables vs Normal table joins

  Hello, I have been having a discussion with a colleague regarding different approaches to writing S…

  wilks

  11 replies

  11 years, 5 months ago

  By: wilks

• Grouping by percentage of time worked by person

  Hello all. At first I was going to use Excel to do this but I was thinking SQL server might be bet…

  david.john.gilligan

  5 replies

  11 years, 6 months ago

  By: david.john.gilligan

• CONVERT PLSQL TO TSQL

  HOW TO CONVERT THE BELOW FROM PLSQL TO TSQL YTD_Deprn2=DECODE(SUBSTR(Period_Name,-2),SUBSTR(:Date,-…

  STYLES

  7 replies

  11 years, 6 months ago

  By: mickyT

• Query Runs on Production and Not on Development SQL Server

  I have two servers: one production and one development. There is a third party query that runs on …

  michael.minarzick 97083

  10 replies

  11 years, 6 months ago

  By: Grant Fritchey

• help with Paid in Full updates to transaction table

  Hi I've been trying to solve this for hours and clearly could do with some help! I am basically tr…

  Ade_1

  12 replies

  11 years, 6 months ago

  By: Sean Lange

• Problem with SELECT with specific duplicates

  Hello I have question, how to make it works: I have table with four columns: ID_PLACE ID_ITEM DATE …

  indoctrine 49919

  1 replies

  11 years, 6 months ago

  By: Phil Parkin