SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Restricted LEFT JOIN

  I have a situation where I need to identify all appropriate records in my main table and only appro…

  Aaron N. Cutshall

  16 replies

  11 years ago

  By: ChrisM@Work

• New column in Existing table and uploading data

  Need to change the datatype of existing column which has huge data. I'm performing below steps 1. C…

  khushbu

  11 replies

  11 years ago

  By: khushbu

• how to create a dynamic update statement based on return values in a select statement.

  Ok I have a query "SELECT ColumnNames FROM tbl1" let's say the values returned are "age,sex,race". …

  JP10

  4 replies

  11 years ago

  By: JP10

• group by part of string

  Hey First time here, but have been enjoying the articles for some time now on this site. But got a …

  x 45204

  9 replies

  11 years ago

  By: Dohsan

• Read dynamic XML

  I have the xml which is dynamically created and we are not sure how to read it. for eg the below xm…

  vineetbhargav

  5 replies

  11 years ago

  By: vineetbhargav

• DATE as dynamic table name

  I am trying to select data from table that have YYMM as table names, they are formatted table1410,t…

  cbrammer1219

  1 replies

  11 years ago

  By: Stephanie Giovannini

• Running Totals

  I wonder if someone could help me calculate a running total. I am converting this from an existing …

  NumptySpence

  8 replies

  11 years ago

  By: DonlSimpson

• How to Loop the unmatched rows data from two tables in sqlserver 2012

  Hi All, I need solution on below issue which became painful in my current project , Please suggest …

  saikumar.mca2007

  1 replies

  11 years ago

  By: Koen Verbeeck

• Correlated Subquery?

  Hi all I came across the following T-SQL query in an article I was reading. Can someone please expl…

  SQLSACT

  8 replies

  11 years ago

  By: ScottPletcher

• CHOOSE() a RAND() vowel not working???

  On my SQL Server 2012 SP2 installation, The following expression always returns an integer between…

  mtlsql

  26 replies

  11 years ago

  By: Eirikur Eiriksson

• Dynamic Query

  I am trying to do this I have researched many site stackoverflow, here, social.technet.microsoft.c…

  cbrammer1219

  11 replies

  11 years ago

  By: ChrisM@Work

• Pattern matching (positive across records, negative within a field)

  Hi Guys, I am doing some analysis on our customer base and their payment profiles. I have generate…

  aaron.reese

  10 replies

  11 years ago

  By: Dwain Camps

• Query inside of a SQL report - look?

  Ok so I took over for a previous DBA. He wrote SQL reports for a phone system to pull data. Probl…

  jcosley

  7 replies

  11 years ago

  By: jcosley

• Comparing Bits and Ints

  No doubt this will prompt cries of "Who cares?" from some. To you, I apologise in advance 🙂 Imagine…

  Phil Parkin

  13 replies

  11 years ago

  By: Dwain Camps

• Query

  I have a query like : SELECT DISTINCT C1.containerCode ,C1.containerName, (SELECT C1.containerCode …

  VSSGeorge

  6 replies

  11 years ago

  By: ScottPletcher