SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• How to call the cursur into Stored Stored procedure

  Hi Friends I am Using the Below mentioned Script to fetch the data from Flatfile table and i need t…

  arunnrj87

  1 replies

  11 years, 2 months ago

  By: Sean Lange

• Big O(1) in SQL 2012

  Hi, Big O(1) will be applied for Hash methods not for B-Tree. How to implement it in SQL 2012 ? is …

  karthik M

  9 replies

  11 years, 2 months ago

  By: karthik M

• Week wise query in Sqlserver

  Hi, I have a table with below format. PartMachineQtyStart DateEnd Date Part 1Machine 1465011…

  Raghunathan

  1 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Transpose Values from Rows to Columns based on Name and Shipment Type

  Hi, I am working on a sql data that has a list of product names, shipment type and the count of shi…

  karthik82.vk

  6 replies

  11 years, 2 months ago

  By: Eirikur Eiriksson

• Heap or clustered, What to do ...

  My question is about indexing strategy for the following scenario: I have a table where we cannot u…

  SeanNerd

  21 replies

  11 years, 2 months ago

  By: Jeff Moden

• Error creating temp table based on IF logic

  Hello, Was working on something I could deploy across my environment, which is a mix of 2008R2/2012…

  sqldriver

  23 replies

  11 years, 2 months ago

  By: sqldriver

• Simple Update Query from SQL Newbie

  I have a simple table called ADDRESS. AddressID..........Line1............................Line2 123…

  gcook 48147

  6 replies

  11 years, 2 months ago

  By: Jeff Moden

• SQL Data columns to Data Rows

  Hi All, Possibly a simple answer but it has been a long day and I cannot get it working. Any help w…

  aarionsql

  8 replies

  11 years, 2 months ago

  By: Jason-299789

• Convert rows into columns

  I have 5 columns in my database. 1 column is coming like a dynamic. I want to convert records from …

  hozefa_unwala 55218

  1 replies

  11 years, 2 months ago

  By: Luis Cazares

• Correlated Subquery - very slow performance when transitioned from SQL Server 2008 to SQL Server 2012

  Hi all, I am having hard time to get a query to work. Would really appreciate any help on this. It …

  O&O

  5 replies

  11 years, 2 months ago

  By: O&O

• CDC get all changes function error issue

  I have setup CDC on 50 tables and then in one SP I’m calling all cdc function like below issue is I…

  inayatkhan

  2 replies

  11 years, 2 months ago

  By: inayatkhan

• Exclude data

  I Have a problem with my sql I have this sql statement as doing sums in Customer based on the follo…

  mite

  5 replies

  11 years, 2 months ago

  By: Sean Lange

• Functions vs Stored Procs

  So I inherited this server that has a ton of UDF's written as simple select statements (at least on…

  ImYourDBA

  6 replies

  11 years, 2 months ago

  By: Grant Fritchey

• Recurrent Balance that resets when hitting a value

  Hello all, I have query that calculate a running balance, but I need to reset that balance when it …

  patricio.carpio

  4 replies

  11 years, 2 months ago

  By: Jeff Moden

• Return only the Count of Database's with backup older than 24 hours.

  I need only the count of databases that last fullbackup was older then 24 hours or null. and statu…

  Jeff Sims-413169

  2 replies

  11 years, 2 months ago

  By: Maddave