SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Challenge with trigger to send email, including attached file. @query needs variables...

  The below code works as it is today. The problem is that I want to attach an email with the last 25…

  Trelin

  10 replies

  10 years, 12 months ago

  By: Trelin

• write a query to get count of all fields named LX where x is a number

  for example in a table with this fields "field1, L1,L3,L100" field2 the count is 3 it would be bett…

  fabriziodb

  6 replies

  11 years ago

  By: Jeff Moden

• Capture sql statement from missing join predicate event

  Hi All, After monitoring using SQL profiler, i found that Missing join predicate event is happening…

  nadersam

  3 replies

  11 years ago

  By: nadersam

• Sending Email from SQL thru store procedure

  Dear Expert, I have below code to send email in HTML table format with help of store procedure. fro…

  atul.jadhav

  6 replies

  11 years ago

  By: Koen Verbeeck

• Just an idea ...

  I've been working with some wide and unfamiliar tables recently. Scanning and finding column names …

  Phil Parkin

  15 replies

  11 years ago

  By: DonlSimpson

• parse a string every 6 letters

  Hi I need help in a query...How to parse a string to equal length substrings in SQL I am getting a …

  sql_learner29

  2 replies

  11 years ago

  By: Luis Cazares

• How to optimize the below query?

  Table Dept has two columns (did(int) , dname(varchar)). Table emp has five columns (eid(int), mid(i…

  toraghubiz

  6 replies

  11 years ago

  By: ChrisM@home

• set variables

  Hi how can i put multiple values in the variables. for eg: Declare @w_man as varchar set @w_man = …

  PiyaKaGhar

  5 replies

  11 years ago

  By: jphillips 46546

• Help With Select Query

  I Have 2 Different Table As Follows Table 1 - Person With Columns PersonID,PersonGrp,PersonName 1,'…

  Jay Sapani

  19 replies

  11 years ago

  By: serg-52

• I need help with a query to count how many sessions are active and remain active per hour.

  Hello, I am new to the forum. I hope there is someone who has run into this before. I have a table …

  gene 15505

  5 replies

  11 years ago

  By: Dwain Camps

• Write a loop on result of first query inside a Stored Procedure

  Hi All, I am having a limited knowledge in SQL. Let me explain my scenario in detail. I have to wri…

  girish.nehte-1109699

  2 replies

  11 years ago

  By: TheSQLGuru

• Optimizing Stored Procedure to go Parallel.

  I have a stored procedure that calls several views that rely on each other. In the past these views…

  pkapas

  11 replies

  11 years ago

  By: TheSQLGuru

• Parsing XML that does not quite fit normal XML standards.

  Hello All, I have an application that stores xml data in an unusal manor. Basically a SQL Key colu…

  AronsonAa

  3 replies

  11 years ago

  By: AronsonAa

• Help me to tune this query in a better way

  Hi, I am struggling a bit to reduce the execution time for the below query. kindly help me to tune …

  prabhu.st

  13 replies

  11 years ago

  By: prabhu.st

• Is there a better way to query a hierarchy table?

  Hi, I have a table named 'DepartmentItem' which is designed with hierarchy structure. The colum…

  johnsql-193053

  2 replies

  11 years ago

  By: Dwain Camps