SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• 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

  7 years, 9 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

  7 years, 9 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

  7 years, 9 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

  7 years, 9 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

  7 years, 9 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

  7 years, 9 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

  7 years, 9 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

  7 years, 9 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

  7 years, 9 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

  7 years, 9 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

  7 years, 9 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

  7 years, 9 months ago

  By: noel.moore

• space issue in display

  hi , I I have 2 column, column1 and column2. I need to concat this 2 column with column1 should hav…

  coool_sweet

  2 replies

  7 years, 9 months ago

  By: drew.allen

• How to query with this date format ?

  Hi , I have to query a column with this date format : 16-Nov-2017 00:000. The 00.00 refers to time…

  corgi_77

  8 replies

  7 years, 9 months ago

  By: ChrisM@Work

• Automate LogSHipping for multiple databases

  I need to set up log shipping for about 100 databases. Log backup would occur ever 4 hours and woul…

  desiboy102493

  29 replies

  7 years, 9 months ago

  By: barsuk