SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• select problem

    hello i have 2 table   declare @t table (id int ,name char(10)) declare @y table (id i…

  natigsqlserver

  6 replies

  5 years, 11 months ago

  By: Thom A

• Minor code change will it make a difference.

    Please let me know your thoughts on the below. Updated a small portion of the code. Just wan…

  sizal0234

  6 replies

  5 years, 11 months ago

  By: Andrew P

• SENDING THE RESULTS OF A SELECT STATEMENT FROM A #TEMP TABLE WITH Sp_Send_dbMail

  what are the best ways one can send data from a temp table through email using the SQL Email Client…

  JALLY

  2 replies

  5 years, 11 months ago

  By: Sumathi

• Need help on ssrs report parameters or expression

  Hi, I have created an SSRS report that renders a table from my DB. I have created a multi-value tex…

  Dee Dee-422077

  3 replies

  5 years, 11 months ago

  By: Sumathi

• Script multiple queries

  Is it possible to script multiple queries?  I need to transfer about 30 queries from one server to …

  Jackie Lowery

  11 replies

  5 years, 11 months ago

  By: Jonathan AC Roberts

• Need help query for current row and previous row

  Hye, I've table and data as following, CREATE TABLE [dbo].[WeightStory]( [Idx] [int] IDENTITY(1,1)…

  Adelia

  9 replies

  5 years, 12 months ago

  By: inkosi_dba_dev

• Finding out mismatch between time lines.

  CREATE TABLE #Source ( PlanId BIGINT, StartDate DATE, EndDate DATE ) GO CREATE TABLE #Destination (…

  koti.raavi

  4 replies

  5 years, 12 months ago

  By: drew.allen

• Question on triggers

  Hi, I have, as most triggers are, a single row trigger; that is it will only update one row, and th…

  itmasterw 60042

  8 replies

  5 years, 12 months ago

  By: itmasterw 60042

• Help avoiding long IF statements

  All, I have 3 variables (called Medals) that hold 1 of 5 values.  I have a 4th variable (called ove…

  Mark Eckeard

  5 replies

  6 years ago

  By: John Mitchell-245523

• transactions(Try, commit and rollback)

  Ignore post This topic was modified 6 years ago by mcfarlandparkway.

  mcfarlandparkway

  3 replies

  6 years ago

  By: Phil Parkin

• Replacing ALL

  */So, this is part of the create SP. Sample structure is CREATE SP ( @Column1, @Column2, ----- -- )…

  sizal0234

  1 replies

  6 years ago

  By: drew.allen

• Importing File in SQL Server (Having Header and Footer and no delimiters)

  Dears, I have a flat file exported from an application which has no delimiters and have header and …

  Rehan Ahmad

  4 replies

  6 years ago

  By: Jeffrey Williams

• create an MS-Access FE with a SQL Server BE without ODBC

  I need to create a set of basic view, insert, update SPs without using ODBC. I have a basic start o…

  DaveBriCam

  2 replies

  6 years ago

  By: DaveBriCam

• Greater-Than Empty String Comparison Yielding Unexpected Results

  I'm not sure when, but years ago as a BASIC programmer, I picked up the habit of checking to see if…

  David Lafayette

  4 replies

  6 years ago

  By: David Lafayette

• Table Function becomes slow

  Hi folks, I have a 2012 sql and it works very fast, one of the most used queries is a table functio…

  balestragerman

  13 replies

  6 years ago

  By: ScottPletcher