SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• T-Sql help

  Hi, I need to update ProductAmt field when ProductAmts are same and different using two use cases g…

  PSB

  7 replies

  10 years, 10 months ago

  By: PSB

• t-sql 2012 can logic to not be a cte

  I would like to know how to change the logic for a cte in t-sql 2012 to not be a cte. The reason is…

  wendy elizabeth

  3 replies

  10 years, 10 months ago

  By: Robert Klimes

• Unique records

  Hi Team, I have a 'admins' table with below records groupname -------------- TNR Unify TJB…

  Minnu

  3 replies

  10 years, 10 months ago

  By: Dwain Camps

• t-sql 2012 update column in stored procedure

  In a t-sql 2012 stored procedure, I would like to know if my solution to solve the problem is corr…

  wendy elizabeth

  5 replies

  10 years, 10 months ago

  By: wendy elizabeth

• Need help to convert below mentioned stored procedure into user defined function..Please revert me back ASAP..Itz urgent

  --<ScriptOptions statementTerminator=";"/> CREATE PROCEDURE DB2TAB.MILLING_POSN_LIMITS (IN P_…

  choudharyneeti11

  3 replies

  10 years, 10 months ago

  By: ScottPletcher

• Compare a table with physical path

  Hi Team, i have a table with two columns id | filepath -------------------------------------------…

  Minnu

  3 replies

  10 years, 10 months ago

  By: serg-52

• Optimisation of SELECT query

  We have been trying to improve the performance of a particular SELECT query in our client's databas…

  zoggling

  2 replies

  10 years, 10 months ago

  By: Grant Fritchey

• sp_rename Issue, I wasn't aware of

  I came across an issue, I'd like to share with you concerning sp_Rename. (I know there are lots and…

  JohnyRotten

  8 replies

  10 years, 10 months ago

  By: JohnyRotten

• How to quickly update/insert 3M records in a large table?

  Dear all, Our system runs a SQL Server 2012 DB, it has a table (table_a) which has over 10M records…

  George Wei

  12 replies

  10 years, 10 months ago

  By: George Wei

• Design Question to minimize blocking

  I am trying to come up with some tuning recommendations for a design pattern I have seen in several…

  tim_harkin

  3 replies

  10 years, 10 months ago

  By: MadAdmin

• Fetch Physical filenames in SQL Database

  Hi Team, I have a folder with 1000 text(.txt) files in it. I want to insert the filenames into a ta…

  Minnu

  4 replies

  10 years, 10 months ago

  By: Minnu

• Update Quantities over multiple records

  I have two tables that can be created with sample data using the DDL at the bottom of this post. W…

  skilly2

  5 replies

  10 years, 10 months ago

  By: Dwain Camps

• pivot rows and columns in the same query

  I currently have data stored in a temporary table and I would like to transpose the data into a bet…

  kscott-851323

  2 replies

  10 years, 10 months ago

  By: brad.mason5

• Execution plan using views, but store procedure does not list or use that view at all

  This is driving me crazy! I'm troubleshooting a performance issue on a store procedure that has no…

  sql-lover

  4 replies

  10 years, 10 months ago

  By: Grant Fritchey

• Tricky problem

  I have a rather tricky problem for you all to help me solve. I am on SQL Server 2012 and I have a t…

  dbodell

  4 replies

  10 years, 10 months ago

  By: dbodell