SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• How to select top 10 records from 2 distinct groups

  Hey there - I am looking to create a query that will help me pull the top 10 records from two disti…

  IBeDatMan

  17 replies

  10 years ago

  By: DesNorton

• SQL Profiler "not like" textdata filter not working

  I am trying to set up a trace that will not display certain RPC's or SP's When I set up the TextDat…

  tshad

  3 replies

  10 years ago

  By: tshad

• Ghostscript to auto print reporting services report

  I downloaded ghostscript and ghostview. I am trying to print a reporting services report after it g…

  georgeg 69122

  3 replies

  10 years ago

  By: georgeg 69122

• multiple rows in where clause to filter employee with more skills

  Hi, I have a table for employees with skills in different Levels. In the UI you can choose numerous…

  Sue-651097

  2 replies

  10 years ago

  By: Sue-651097

• Sequential Table insertion hierarchy

  I have to add data in tables for a fresh empty database, Don't know the structure but found Foreign…

  shamshad.ali

  2 replies

  10 years ago

  By: Lowell

• Date difference finder

  I am trying to finding date difference between today's date and given date in the table.Some rows h…

  sachitmaskey

  1 replies

  10 years ago

  By: tony28

• I want to automate my database compression , can anyone provide me the T sql code...

  I have few databases in my environment which is 2 TB and 1 TB data and we have partitioned the few …

  prem.m38

  12 replies

  10 years ago

  By: Igor Micev

• Merge 2 identical table based on timestamp and column values

  I have two identical tables with same columns. Only values are different. Both tables will get upda…

  Helpseeker

  11 replies

  10 years ago

  By: serg-52

• How to calculate a timeline and avoid using cursor

  Hi I'm trying figure out how to build a timeline solution without the cursor? Scenario: There is t…

  michal.lisinski

  8 replies

  10 years ago

  By: michal.lisinski

• How to get recursive CTE at least 3000 times faster?

  This heavily recursive CTE is the engine room of my application. It may have to work on 4 columns o…

  samuel.johnson

  6 replies

  10 years ago

  By: Jeff Moden

• Merege statement giving performance issue

  Hi Champs, I have a Merge statement which has both insert and update . But source table is quite …

  ravi@sql

  3 replies

  10 years ago

  By: xsevensinzx

• How to get active records for each date in SQL

  I have a table like below ID FID MDate Active -------------------------- 1 1 2009-05-25 …

  Akshit T Shah

  7 replies

  10 years ago

  By: tony28

• execution of function with tvp - read only

  ..

  gxdatareal

  7 replies

  10 years ago

  By: Sean Lange

• select 1000 records from one table into another in a different server (linked server)

  I need to transfer only top 1000 records from a table on one server to another table on another ser…

  aditi.shirke

  1 replies

  10 years ago

  By: tony28

• Records temporarily "disappear" during update?

  I have designed a multithreaded ETL system that utilizes a few tables on SQL Server (2012) for cont…

  bantrim

  5 replies

  10 years ago

  By: Hugo Kornelis