SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Effective T-SQL for Median

  Is this an effective way to find median? CREATE TABLE #T (i TINYINT); GO INSERT INTO #T SELECT ABS…

  dkschill

  13 replies

  12 years, 2 months ago

  By: TheSQLGuru

• Odd performance query behavior on very large 40 TB partitioned table in distributed view, maybe it's tipping?

  First a bit of background. I recently started a job with a somewhat complicated setup for a 50 TB …

  jallmond

  16 replies

  12 years, 2 months ago

  By: Stefan_G

• More efficient way to perform a lookup?

  I've spent a fair bit of time searching, but can't seem to find a succinct answer...is there a more…

  ravi_k

  7 replies

  12 years, 2 months ago

  By: Stefan_G

• Global Variable

  Hi, I would like to create a global variable that I can reference multiple times and here is the sc…

  Broccoli

  15 replies

  12 years, 2 months ago

  By: Eugene Elutin

• Fiscal Week in TSQL

  Hi there, I have the following script - SELECTDATEPART(WW, JOB.created_date) AS [Created Calend…

  TSQL Tryer

  8 replies

  12 years, 2 months ago

  By: SwePeso

• Convert DATEDIFF to Decimal and Help with another DATEDIFF (Excluding weekends)

  Hi there, As always thanks in advance with your help on my questions. I really appreaciate it. I h…

  TSQL Tryer

  6 replies

  12 years, 2 months ago

  By: TSQL Tryer

• Why doesn't the substring work?

  I have a stored procedure which is supposed to check if a part of a datatype text field (Textdescri…

  marc.eilander 13301

  14 replies

  12 years, 2 months ago

  By: marc.eilander 13301

• why should we use schemabinding with views?

  CREATE VIEW Sales.OrderTotalsByYear WITH SCHEMABINDING AS SELECT YEAR(O.orderdate) AS orderyear, SU…

  shad.saleem41

  8 replies

  12 years, 2 months ago

  By: Eugene Elutin

• Can you suggest some rewriting or indexes on this query...

  Hi All, Here is one more query for you people to check and optimize. It is taking 1-1.5 mins in exe…

  T.Ashish

  7 replies

  12 years, 2 months ago

  By: Erland Sommarskog

• how to use opendatasource for exec sp with output parameter

  hello all. I wanna execute sp with output parameter by use opendatasource.i use this script for it:…

  elham_azizi_62

  1 replies

  12 years, 2 months ago

  By: Erland Sommarskog

• Concatenation

  i have a column abc_col1 in table A when i do a ("Select abc_col1 from A") i get the results as 'S…

  koolme_85

  8 replies

  12 years, 2 months ago

  By: Jeff Moden

• Skipping transaction...or...rolling back just one

  Hello, I have sql code set up like this: set xact_abort on declare @ErrorMessage nvarchar(4000) de…

  Deki

  4 replies

  12 years, 2 months ago

  By: Erland Sommarskog

• Case Sensitivity in sp_describe_undeclared_parameters

  We recently upgraded one of our databases to 2012 Compatibility Mode, and are now getting an error …

  Chris Downing

  7 replies

  12 years, 2 months ago

  By: HowardW

• CTE and totals for an Accouting plan

  Hi guys, I have a simple database with 2 tables. Here are the structures: CREATE TABLE [dbo].[Ac…

  Mauricio_

  3 replies

  12 years, 2 months ago

  By: Jeff Moden

• using the format() command

  Anyone point me to the documentation, or explain why you would expect these results? DECLARE @d DAT…

  Tobar

  3 replies

  12 years, 2 months ago

  By: Tobar