SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Using DelimitedSplit8K

  Hi there, I've got an audit table which by using DelimitedSplit8K I am able to show the before and…

  TSQL Tryer

  25 replies

  10 years, 10 months ago

  By: Jason-299789

• Need SQL query for this scenario

  Hi All, I have a table like below: Claim Number|Status ============= 100 | 1 100 …

  SG007

  6 replies

  10 years, 10 months ago

  By: Luis Cazares

• Removing / Deleting Data from 2 tables

  Hi there, I have found a bunch of duplicate records in our housing database that ideally I need to…

  TSQL Tryer

  2 replies

  10 years, 10 months ago

  By: ZZartin

• Finding Lowest Level Descendants in Hierarchy

  I've got a fairly large hierarchy table and I'm trying to put together a query to find the lowest l…

  SQLvis

  1 replies

  10 years, 10 months ago

  By: SQLvis

• SQl Query to Calculate No of Days from LastDate and PreviousDate

  Hi All, Below is a table which holds the rent updates done for properties at any point of time. Li…

  jaggy99

  3 replies

  10 years, 10 months ago

  By: andyscott

• Convert Varchar to Time

  I need my code to add the varchar CPUTM field + varchar CPUZIPTIM field which both has time values …

  bmanning20

  2 replies

  10 years, 10 months ago

  By: ScottPletcher

• Filter based on the count of value

  Hi All, I have the table below and want to show the prop_code if the rent_review_date count is less…

  jaggy99

  6 replies

  10 years, 10 months ago

  By: milos.radivojevic

• Nested Dateadd function for Date range.... any ideas?

  .j

  shalaran

  2 replies

  10 years, 10 months ago

  By: Jeff Moden

• can anyone provide me real time scenarios where you build stored procedures, triggers, cursors?

  can anyone provide me real time scenarios where you build stored procedures, triggers, cursors? Al…

  t.mounika01

  17 replies

  10 years, 10 months ago

  By: Jeff Moden

• Dynamic query on db table names

  I have query which is used to dynamically insert value but not working. we are trying to get all ta…

  scottichrosaviakosmos

  1 replies

  10 years, 10 months ago

  By: DouglasH

• SQL and C# integration.

  Apologies if it is a silly question, Oracle allows Java to be integrated. Is it possible to integra…

  BOR15K

  4 replies

  10 years, 10 months ago

  By: Sean Lange

• Backups Question - why do logs grow so big?

  Hi there, On my SQL server I have a number of customer databases that are backupped every night. It…

  Raymond van Laake

  4 replies

  10 years, 10 months ago

  By: Raymond van Laake

• Using Merge statement Output records to rebuild table on specific date

  I have a table which is updated daily using a MERGE statement. As records are insert, updated and …

  Joseph Miano

  2 replies

  10 years, 10 months ago

  By: Dwain Camps

• Create table from rows of a different table

  Hi to every ones, I am new to this forum and to SQL world. I need your help to find a solution for …

  rolinoberto

  12 replies

  10 years, 10 months ago

  By: rolinoberto

• How to use direct select and insert or load to speedup the process instead of cursur

  Hi friends, I have stored procedure .In SP i am using cursur to load data from Parent to several ch…

  arunnrj87

  3 replies

  10 years, 10 months ago

  By: spaghettidba