SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Query to increment an alpha character suffix

  Need some help from the TSQL gurus. The situation is that given data in the column a table, data in…

  lbrigham

  11 replies

  8 years, 5 months ago

  By: drew.allen

• Enter maximum value on the basis of 2 independent tables.

  Hi Folks, I stuck in a puzzle, please suggest a way to resolve this.  I have 2 below Tabl…

  anujkumar.mca

  8 replies

  8 years, 5 months ago

  By: darius.england

• Convert UTC time to local time

  I have table with column of datetime, for example : 2017-03-27 22:30:23.000 I want to convert …

  wanttolearn1

  3 replies

  8 years, 5 months ago

  By: Eirikur Eiriksson

• Possibly a dumb question about precedence in a where clause using 'OR'

  I have a rather complicated query that has been working as expected but we were thrown a scenario w…

  sp_harris_03

  8 replies

  8 years, 5 months ago

  By: Matt Miller (4)

• Query to retreive records does not match Frontend values

  Hi everyone,  I am using the Query shown below to retrieve records. The value obtained in the …

  IQ1

  4 replies

  8 years, 5 months ago

  By: IQ1

• Data Collector being blocked by user query

  I've a strange situation, where the Data Collector is being blocked by a long running user query. T…

  Leo.Miller

  1 replies

  8 years, 5 months ago

  By: sgmunson

• Need to get consecutive duplicate rows

  I need a query that can get me (the ID of) consecutive duplicate rows, where I am grouping on some …

  pfefferl

  29 replies

  8 years, 5 months ago

  By: Jeff Moden

• Convert Bigint time to datetime

  Hi, How to convert bigint time to datetime (CST) Declare @MyBigIntTime BIGINT =1397750400000 Thanks…

  PSB

  27 replies

  8 years, 5 months ago

  By: webrunner

• Allocating Support Calls evenly to Customer Service agents

  I have been searching forums to get the second part of my query right but to no avail, any help wou…

  Stix83

  5 replies

  8 years, 5 months ago

  By: pietlinden

• Performance Considerations :: Lookup vs Join

  Dear All I have a requirement as below. May I seek your views choosing between Lookup vs Join optio…

  etl2016

  2 replies

  8 years, 5 months ago

  By: Gail Shaw

• Average a column value based on depth interval

  I have a drill hole table that looks like the table below - DataSet Hole_ID De…

  reid_joseph

  4 replies

  8 years, 5 months ago

  By: Eirikur Eiriksson

• Two tables that they have foreign keys pointing to each other

  Hi,I have an unusual problem in that I have to remove records from two tables that they have foreig…

  EamonSQL

  8 replies

  8 years, 5 months ago

  By: RonKyle

• How to distinct values and adding row numbers while keeping original order?

  How can i get a distinct list of the lcc_codes below removing null lcc_codes and with a row number …

  Jackie Lowery

  3 replies

  8 years, 5 months ago

  By: Luis Cazares

• SqlException :- incorrect syntax near the keyword as,incorrect syntax near t2

  Hi All,I'm trying to run this code in my asp.net app below but getting error SqlException…

  Patrick.I

  5 replies

  8 years, 5 months ago

  By: Patrick.I

• Setting a Flag when a set of conditions meet

  I am trying to set a Flag if a number of conditions in an IIF statement are meet; after calculating…

  noel.moore

  4 replies

  8 years, 5 months ago

  By: noel.moore