SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• need help for sql query

  hi all , i need to addition to column which i given below. SELECT CASE WHEN UPPER(f.newact) = 'N' T…

  rajnidas.y

  3 replies

  11 years, 4 months ago

  By: Phil Parkin

• select statement

  hi, I need help to write a select statement that take the upper table and select the lower table. t…

  shaftut

  3 replies

  11 years, 5 months ago

  By: Daniel Matthee

• Find Changed Rows (and the row prior to the changes)

  Thank you for reading. I have a table (represented by #Events) that holds modifications made to an…

  michael.minarzick 97083

  4 replies

  11 years, 5 months ago

  By: ScottPletcher

• Update is Slow in SQL server 2014

  Hi, Updating a statement takes 120 millisecond in SQL server 2000 Updating the same statement takes…

  yuvipoy

  6 replies

  11 years, 5 months ago

  By: Eirikur Eiriksson

• Assigning a "Group ID" based on consecutive Values

  Hi Guys, I have an interesting problem I am trying to solve without using cursors... I have a data …

  Tony.Valenti

  2 replies

  11 years, 5 months ago

  By: Tony.Valenti

• Synonym Help

  I have a linked server called DOA_FANS on my SQL 2012 that connects to an Oracle server/database. …

  mcopa

  1 replies

  11 years, 5 months ago

  By: mcopa

• CLR vs. c# Console App

  I need to write a process to get file size in kb and record count in a file. I was planning on writ…

  Snargables

  1 replies

  11 years, 5 months ago

  By: Eirikur Eiriksson

• XML Query Help row with no data

  declare @address table ( AddressID int, AddressType varchar(12), Address1 varchar(20), Address2 var…

  inayatkhan

  6 replies

  11 years, 5 months ago

  By: Eirikur Eiriksson

• sp_send_dbmail question

  I have this: EXEC msdb.dbo.sp_send_dbmail @profile_name = 'DBA_Mail', @recipients = 'paresh…

  Paresh Motiwala

  3 replies

  11 years, 5 months ago

  By: Eirikur Eiriksson

• Exporting Data from MDS 2012 entity to SQL 2012 database table

  Hi All, How to export data from MDS 2012 entity to SQL 2012 user database table ? Inputs are welco…

  karthik M

  6 replies

  11 years, 5 months ago

  By: Koen Verbeeck

• Error Msg 102, Level 15, State 1, Procedure

  Can anyone help me. I use a script which run in 2008 without error. But in 2012 i got this error: …

  ms.sql

  4 replies

  11 years, 5 months ago

  By: ms.sql

• how to move data from one table to another table

  i have a table attendance_details in both database DB1 and DB2, i need to move 01/7/14 and 02/7/14…

  neethu payal

  4 replies

  11 years, 5 months ago

  By: Koen Verbeeck

• Calculate EndDate From Subsequent StartDate

  Here is sample data I am working with: Create table cattimelines (categoryID int, EffectiveDate dat…

  Nilssond

  3 replies

  11 years, 5 months ago

  By: Luis Cazares

• TSQL Script help for new user

  Hi all, I'm hoping someone can help as I'm clueless 🙂 I'm looking for some TSQL script that filters…

  jonathan_blac15

  7 replies

  11 years, 5 months ago

  By: autoexcrement

• Issue With Producing Running Total Column In Select Clause

  I want to create the following scenario. I have a table that stores employees working on projects a…

  kingankit2006

  2 replies

  11 years, 5 months ago

  By: kingankit2006