SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Where can I find the list of values for event_data (XML) files in SQL?

  Got following query: SELECT event_data.value('(event/data/value)[4]', 'bigint') AS cpu_time, --d…

  sql-lover

  2 replies

  11 years ago

  By: Eirikur Eiriksson

• How to capture CPU and Memory usage for a stored Procedure

  I have around 100 packages (all [packages run at same time) each package calls a stored Procedure …

  SQL_Buddy99

  2 replies

  11 years ago

  By: Bhushan Kulkarni

• Design vehicle and its parts database in SQL server

  Hello All, I have to create a database with the data including the information about the cars, part…

  SQL Prog

  9 replies

  11 years ago

  By: Michael Valentine Jones

• @HR

  I'm trying to get up to speed on sp_OACreate and related OLE objects. I see the variable @HR used i…

  robert.t.wu

  2 replies

  11 years ago

  By: robert.t.wu

• Performance problem when joining to a view.

  Hi, I have a simple query that joins a largeish fact table (3 million rows) to a view that returns …

  Daniel Forrester 123

  10 replies

  11 years ago

  By: Daniel Forrester 123

• Missing Months in a GROUP BY statement

  I am trying to get a count by product, month, year even if there are is no record for that particul…

  TheComedian

  7 replies

  11 years ago

  By: pietlinden

• using charindex

  Hi everyone i want split the data this below format.. 1.Split the RR ("PL:TW RR:1.8%,PL:TX RR:0.9%"…

  ashokputta9

  2 replies

  11 years ago

  By: Dwain Camps

• Rank on repeating groups of bit field

  Lets say I have some data where a bit value changes over time and I want to rank it by the repeatin…

  Jim Shaffer

  3 replies

  11 years ago

  By: ChrisM@Work

• what else can you search for instead of col1 = '' or col1 = ' ' or col1 is null?

  I have a column that is empty, but when I search for that column with col1 = '' or col1 = ' ' or co…

  JP10

  11 replies

  11 years ago

  By: Jeff Moden

• Tipping point for a numbers table vs inline tally

  Hello, At what number of rows do you consider the tally table method to perform less efficiently th…

  sqldriver

  18 replies

  11 years ago

  By: Jeff Moden

• sp_send_dbmail does NOT download the image in outlook

  Outlook says 'to prevent your privacy outlook prevented the image download' I don'y want users to r…

  niladri_chatterjee

  4 replies

  11 years ago

  By: george.lewycky

• DATE cONVERT

  I have a date filed - an example of what it pulls back is - 2013-05-10 08:15:24.000 I want it to j…

  TSQL Tryer

  9 replies

  11 years ago

  By: Jeff Moden

• How to get a consecutive count based on the first value

  Hello all. I was asked for a very interesting report today that has been driving me nuts all morni…

  FarNorthDBA

  11 replies

  11 years ago

  By: Luis Cazares

• How to insert one to many valued parameters from a stored procedure into a table

  Hi, I have a SP with Parameters as: R_ID P1 P2 P3 P4 P5 I need to insert into a table as below: R_I…

  gayesh

  2 replies

  11 years ago

  By: gayesh

• Lowest Child in recusive query

  Hi, I have following input: CREATE TABLE #tree ( Childid varchar(20), Parentid varchar(20) ) INSERT…

  edberg16

  12 replies

  11 years ago

  By: Sean Lange