SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• How to combine data from different tables using a query

  I have a set of tables that look like what I have shown below. Could you let me know how I can achi…

  SqlServerNinja

  2 replies

  11 years, 10 months ago

  By: mickyT

• Exec producing table out of scope

  Hi, I am generating some dynamic sql which I would like to run and return the data from, however wh…

  olibbhq

  4 replies

  11 years, 10 months ago

  By: Gail Shaw

• sp with one or more input parameters

  Hi, I've been tasked with creating a stored procedure which will be executed after a user has input…

  chris.baigent

  2 replies

  11 years, 10 months ago

  By: chris.baigent

• display order by like 1,2,3,4,5...............plz write quarie

  Examples of values I want to put in order houseno 3-13-1 3-13-3/a 3-13-3/b 3-13-2/a 3-13-4 3-13-6 3…

  shashianireddy

  38 replies

  11 years, 10 months ago

  By: ChrisM@home

• select only up to first '-' only

  I Have table like this...... House_no 6-1 6-1-2 6-1/2 6-1/78 6-12/5 6-3-124 ,hyderabad 6-3/2 6-3-19…

  shashianireddy

  2 replies

  11 years, 10 months ago

  By: ChrisM@home

• select quarie between houseno ..........

  i have table like below House_No 4-12-1000 4-12-55/b 4-12-1456/b/c 4-12-12 4-12-1398 4-12-23 4-12-9…

  shashianireddy

  7 replies

  11 years, 10 months ago

  By: ChrisM@home

• what is the use of Over Clause

  I would like to know when and how to use over clause in sql 20012 with proper example.

  sej2008

  3 replies

  11 years, 10 months ago

  By: Alan Burstein

• sql query to find the difference in values from previous month

  I have my sql tables and query as shown below : CREATE TABLE #ABC([Year] INT, [Month] INT, Stores I…

  SqlServerNinja

  3 replies

  11 years, 10 months ago

  By: Dwain Camps

• display columns with no data

  Newbie..sorry, posted this somewhere else, but couldn't find it. Trying to get the PSI Outcome, Exp…

  boehnc

  2 replies

  11 years, 10 months ago

  By: John Mitchell-245523

• error with stored procedure

  when i execute the SP with data parameters USE [ABC] GO DECLARE@return_value int EXEC@return_valu…

  Dooooooooooo

  5 replies

  11 years, 10 months ago

  By: x

• Set based super challenge

  Please read the attached txt file. The challenge is to summarize the data per patient but only as /…

  lotusnotes

  13 replies

  11 years, 10 months ago

  By: ChrisM@Work

• Best options for this scenarion

  Hi, I have two dynamic pivot tables that I need to join. The problem I'm running into is that at ex…

  sqldriver

  7 replies

  11 years, 10 months ago

  By: sqldriver

• Splitting column values iin multiple columns and assigning it to a row

  How do I write a query using the split function for the following requirement I have a table in the…

  prabha.venkatachalam

  2 replies

  11 years, 10 months ago

  By: Dwain Camps

• differences in rounding / converting strings

  Hi all, first of all: I know some best practices and work-arounds when working with float numbers, …

  Arthur Kirchner

  2 replies

  11 years, 10 months ago

  By: Arthur Kirchner

• Merge - Pros and cons

  Hi there, Please any one help me out to understand what is MERGE ? and when to use it? Also explain…

  vignesh.ms

  6 replies

  11 years, 10 months ago

  By: Dwain Camps