SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Bitwise Operator (pipe) in Update Statement

  I'm researching some long running queries and came across a query of this format: UPDATE t1 SET in…

  Samwell

  1 replies

  10 years, 6 months ago

  By: ScottPletcher

• udf with tally table runs slower than while loop

  Hi, I'm migrating electronic records from a legacy system and the new system has strict requirement…

  Josh Leane-155117

  12 replies

  10 years, 6 months ago

  By: Jeff Moden

• Stored Procedure runs fine on the Production Server and two Test Server but not on the replicated Server.

  I'm stumped. I have a Stored Procedure which needs to be moved to the Replication Database for Repo…

  Welsh Corgi

  13 replies

  10 years, 6 months ago

  By: Welsh Corgi

• duplicates of part.num to be summed and add another column called user

  There are 3 columns in the result set - part num, Qty and MO num. Each MO num has part numbers.So t…

  chindilog

  1 replies

  10 years, 7 months ago

  By: Ed Wagner

• Replace and Substring

  Here's my substring script: I want dob to be replaced with value of Date. So, how can I use replace…

  PJ_SQL

  4 replies

  10 years, 7 months ago

  By: PJ_SQL

• SET TABLE VARIABLE FROM FUNCTION CALL

  Guys - is there a better way to do this ? INSERT INTO @TESTTAB SELECT * FROM dbo.UTIL_TABLE_FROM_ST…

  mar.ko

  8 replies

  10 years, 7 months ago

  By: Bill Talada

• Designing Query

  Hi guys Just want to see if anyone else has a different take on a query I'm trying to clean up. Bas…

  mitzyturbo

  6 replies

  10 years, 7 months ago

  By: Luis Cazares

• Usage Query

  Hi, I have a table which gets updated with the usage figure every week. I was wondering if anyone …

  maxlezious

  8 replies

  10 years, 7 months ago

  By: maxlezious

• HOW TO USE LAG() FUNCTION

  CREATE TABLE dbo.SCHEDULES(SCHEDULEID VARCHAR(10), EFFECTIVE_DATE DATE, AMOUNT DECIMAL(4,3)) INSERT…

  Nilssond

  3 replies

  10 years, 7 months ago

  By: Nilssond

• Change Database within a Cursor

  Hi, I like to backup the stored procedures' code used in my databases. So I created this Script: …

  ratloser99 36160

  5 replies

  10 years, 7 months ago

  By: ratloser99 36160

• How to access loopback linked server?

  Hi, for building an autonomous transaction, I created a loopback server as described here: So my a…

  Tobias Kiemes

  1 replies

  10 years, 7 months ago

  By: Lowell

• Changes Needed

  Hi , below output I am getting jobs for last 14 days (Server,Job_Name,run_status,Step_Name,output_f…

  Arjun SreeVastsva

  6 replies

  10 years, 7 months ago

  By: Ed Wagner

• Help needed to remove unwanted P/L Transaction Lines

  Hi All, I am creating a report query that returns all unreconciled P/O lines. I am near completion …

  Pack_Star

  3 replies

  10 years, 7 months ago

  By: Sean Lange

• NORMALIZING A COLUMN CONTAINING LISTS

  CREATE TABLE CATEGORIES(CATEGORYID VARCHAR(10), CATEGORYLIST VARCHAR(200)) INSERT INTO CATEGORIES(C…

  Nilssond

  1 replies

  10 years, 7 months ago

  By: Luis Cazares

• Can't use >= with setInt

  Currently working with DECLARE @yr AS int; SET @yr = 2015; which is used in WHERE (YEAR(E…

  serviceaellis

  11 replies

  10 years, 7 months ago

  By: serviceaellis