SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Adding Syntax for date range.....

  Below is the qry, now I have to sub queries pulling data they are both using the same date range, s…

  thomas.miller1

  1 replies

  6 years, 8 months ago

  By: ninjamy

• Find double byte character data

  I have a table which contains double byte character and single byte character records in the FORMAT…

  jkramprakash

  11 replies

  6 years, 8 months ago

  By: Eirikur Eiriksson

• SQL Blocking while Index job running

  I have one app which usually keep checking for some reminder stuff and if find it execute one store…

  RCRock

  2 replies

  6 years, 8 months ago

  By: Grant Fritchey

• Incremental load based on ID and Date

  I have a stage where data ported from one source and it needs to be loaded in detail table based on…

  koti.raavi

  4 replies

  6 years, 8 months ago

  By: drew.allen

• Question on grouping

  SELECT AUC.AUCTION_NAME_LONG, CASE WHEN A.CLIENT_ID_CODE LIKE ('TMC') …

  thomas.miller1

  15 replies

  6 years, 8 months ago

  By: ScottPletcher

• 2008 -> 2012 Performance Issues

  Ok very strange one this that is outside of my skill level unfortunately. We've got a fairly large …

  goksly

  4 replies

  6 years, 8 months ago

  By: ScottPletcher

• How Restore defunct filegroups from backup?

  HelloI have a sql server 2012 instance with a large database, it has 2 defunct file groups, which a…

  ricardo_chicas

  1 replies

  6 years, 8 months ago

  By: Steve Jones - SSC Editor

• Try Catch Best Practice for Large Stored Procedure

  Hi, I have inherited a 1600+ line stored procedure at my work that imports sales orders into our ER…

  tim.stutzman

  3 replies

  6 years, 8 months ago

  By: Jeff Moden

• How do I change a SELECT statement in a stored procedure based on the value of a variable?

  I've got a web page (.Net web forms) where a user can display sales invoices by date only or date a…

  Lorna-331036

  11 replies

  6 years, 8 months ago

  By: Jeff Moden

• Count of agents logged in during interval

  I could use some guidance on how to construct the following query. I need to derive a count of agen…

  rdsb_2170

  2 replies

  6 years, 8 months ago

  By: rdsb_2170

• Want to Create a User and Assign Permissions in Multiple Databases at once

  I have about 60 SQL Servers and I have an AD group that has Developers in it.  I'm trying to b…

  lmarkum

  4 replies

  6 years, 8 months ago

  By: lmarkum

• How can we map the user to named schema

  How can we map the user to named schema and without giving the schmea.tablename how can we access t…

  hidayath

  1 replies

  6 years, 8 months ago

  By: Chris Harshman

• after add field to query grouping is damage and show extra lines problem

  problem after add field dbo.trxtypeConfig.TrxArbName to query grouping is damage problem . thi…

  ahmed_elbarbary.2010

  2 replies

  6 years, 8 months ago

  By: ninjamy

• Add per column of months per client

  I have this table that should be adding up each column of the months, this is a dynamics pivot, whi…

  angelreynosog

  2 replies

  6 years, 8 months ago

  By: angelreynosog

• Converting Date and Time to Date

  I have a column that I need to display as date only.  Right now I get 2019-01-01 00:00:00 I ca…

  thomas.miller1

  10 replies

  6 years, 8 months ago

  By: Luis Cazares