SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• search the value of a field as a substring of another field.

  Hi all, I have the following query: Select mx.vserie, mx.vfolio from data1 mx inner join data2 my…

  mig28mx

  2 replies

  6 years, 3 months ago

  By: Jeff Moden

• Adding another table to a query but only wanting the top 1 for each record

  I currently have query that gives me the results i needs BUT i am needing to add a new table/column…

  roy.tollison

  7 replies

  6 years, 4 months ago

  By: Jonathan AC Roberts

• Concatenating to a string

  I am trying to concatenate values into one string value and what i have so far is progress, but I w…

  DaveBriCam

  7 replies

  6 years, 4 months ago

  By: GaryV

• Quick query help

  Hi All, Need a quick query help. From sysaltfiles , I want to extract the characters excluding the …

  vsamantha35

  2 replies

  6 years, 4 months ago

  By: vsamantha35

• How to update a Tables with randum Null parameters

  Hi, I have a number of parameters (see below ) that come into a Stored procedure. In the applicatio…

  itmasterw 60042

  18 replies

  6 years, 4 months ago

  By: Jeffrey Williams

• Query not contained in either an aggregate function or the GROUP BY clause.

  Msg 8120, Level 16, State 1, Line 2 Column 'TimeReporting.dbo.TimeData.ID' is invalid in the select…

  stephen.aa

  3 replies

  6 years, 4 months ago

  By: ScottPletcher

• How to get datediff between two different columns and rows

  The temp table represents a physician's schedule. I need to find available time slots for 30 and 45…

  NineIron

  2 replies

  6 years, 4 months ago

  By: ChrisM@Work

• input character string does not follow style 112, either change the input ch

  Hi, I'm getting an obscure issue when when I run this SQL statement SELECT  TOP 1 S_Date from tbl_n…

  EamonSQL

  2 replies

  6 years, 4 months ago

  By: frederico_fonseca

• View Dependencies

  I have SQL Server 2012 and running the following query. THe results do not include all dependencies…

  tinausa

  6 replies

  6 years, 4 months ago

  By: jonathan.crawford

• Verify Server online status using sql server query

  Team I have populated list of ServerName from the sql server query. I would like to add a column st…

  Rock

  22 replies

  6 years, 5 months ago

  By: Mr. Brian Gale

• concate string and order by in display

  Hello, I need one logical help to develop one logic, below is dll CREATE TABLE #X1 ( ID VARCHAR(…

  yogi123

  1 replies

  6 years, 5 months ago

  By: Sue_H

• finding Stored Procedure that use a specific table outside database?

  Hi I use a DB that is used mainly for creating views and tables for another "data" db. A table has …

  jbalbo

  12 replies

  6 years, 5 months ago

  By: Grant Fritchey

• update query is running very slow

  HI All, I am new to sql tuning. I have this below update statement which is taking more than an 1 h…

  bobrooney.81

  20 replies

  6 years, 5 months ago

  By: bobrooney.81

• EST to IST

  I need to run a job in DB at every day morning 12:05 AM IST on daily basis. However, the DB instanc…

  Rock

  5 replies

  6 years, 5 months ago

  By: Thom A

• Unused index causing longer select performance problems?

  Just watched this video by Pinal Dave, he is saying that an unused index can cause poor performance…

  Jonathan AC Roberts

  8 replies

  6 years, 5 months ago

  By: Martin Smith-178018