SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Need Suggestions on Best way to Query Data

  Greetings,I have a table that has 2 columns, TransTableDetail_Trans_To and TransTable_Description. …

  SilhouetteBS

  9 replies

  9 years ago

  By: Mr. Brian Gale

• Create Auto Insert Script - 500k records to load data into sql server

  Hi, I would like to Create Auto Insert Script - 500k records to load data into sql server for my te…

  poratips

  6 replies

  9 years ago

  By: J Livingston SQL

• Query to show units in use on each day for past 12 months

  Hi, I need to be able to create a query which shows the number of our products that were in use on …

  dcaulton73

  4 replies

  9 years ago

  By: Jeff Moden

• Converting varchar to datetime T-SQL.

  Hello, I have 2 column first column in this Format YYYYMMDD and second column as HHMM i want one co…

  sks_989

  4 replies

  9 years ago

  By: sks_989

• Use or abuse of full text searching

  What are the issues when full text CONTAINS statements are used with parameters like these against …

  Indianrock

  2 replies

  9 years ago

  By: Indianrock

• Best practice for simple concurrency challenge

  To setup the question, please start with this table: CREATE TABLE [dbo].[Test1](   …

  rice.tx

  5 replies

  9 years ago

  By: rice.tx

• Nested loops estimated rows equal 1

  Why do I have one estimated row in the nested loop node 2 while correlated seek and scan each has a…

  Peter Shilovich

  10 replies

  9 years ago

  By: Peter Shilovich

• xml

  i have a following xml and expected o/p is given below. save xml as test.xml in your local , i have…

  mxy

  1 replies

  9 years ago

  By: Eirikur Eiriksson

• Another Heap Question for Rotating Data

  I have a table that keeps track of current inventory, the location and qty: INVENTORY--------------…

  josh-1127203

  2 replies

  9 years ago

  By: ScottPletcher

• Show result values based on paramter value

  I have a Stored Procedure with paramter @percentageI need to show the result ( records) based on tw…

  komal145

  1 replies

  9 years ago

  By: Joe Torre

• Rolling 6 Months

  I have a table:   Date                    Va…

  wenger.noah

  8 replies

  9 years ago

  By: wenger.noah

• Help with query

  Hi All, I have a Background checks table and I am trying to find all the employee's (EMPLOY_REF col…

  maxlezious

  4 replies

  9 years ago

  By: maxlezious

• Converting subquery to regular JOIN

  I am trying to eliminate the highlighted code below from this... SELECT i.bill_cust_id,   …

  TheSQL_fan

  3 replies

  9 years ago

  By: TheSQL_fan

• Where to put the Group By clause?

  I want to group the units by tenants, but when I put Group By tenant.scode after the where clause I…

  mitchellk.williams

  3 replies

  9 years ago

  By: Thomas Rushton

• Heap vs Clustered Wildcard Search

  I am working on converting a heap table to a clustered table by adding a primary key to the identit…

  josh-1127203

  36 replies

  9 years ago

  By: whenriksen