SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Querying a Supersession Two Column Table with Multiple Supersessions in both Columns

  Hi Guys, I'm fairly new to SQL and am just setting up a Windows 8 app using an Azure SQL server. Th…

  p.barwick

  21 replies

  11 years, 10 months ago

  By: Jeff Moden

• Linked Server Stored Procedures

  Is it possible to update stored procedures on my normal server when I am looking at it via a linked…

  ccmret

  1 replies

  11 years, 10 months ago

  By: SQLRNNR

• Strange Conversion Issue from varchar to Int

  I have the following table ( its an import from excel spreadsheet done through an application) I k…

  pamozer

  11 replies

  11 years, 10 months ago

  By: Luis Cazares

• using a user defined function in a view - need help

  Hi, I have a function that accespts a string and a delimeter returns the results in a temp table. I…

  movvap

  8 replies

  11 years, 10 months ago

  By: Luis Cazares

• sql case when statement

  Hi below is the scenario which I have currently in my query. I need to write this query without any…

  niha.736

  5 replies

  11 years, 10 months ago

  By: David McKinney

• INSERT..SELECT - CPU single core bottleneck

  Dear All, I'm using INSERT..SELECT to gather data from a complex query into a holding table, this h…

  greg.bull

  4 replies

  11 years, 10 months ago

  By: TheSQLGuru

• Query to get the CPU Usage,memory usage details of server

  Can someone help me in providing a query for fetching the data for CPU Usage, Memory usage, blockin…

  sharadkkw

  7 replies

  11 years, 10 months ago

  By: Jeff Moden

• How do I match values from a PIVOT?

  I'd like to get a extract table result, with a reference id primary key, showing the maximum dates …

  StarNamer

  4 replies

  11 years, 10 months ago

  By: Sean Lange

• Need to merge data from two tables

  Hi All, Please help me in Merging table : --------Dummy TABLE create table #Tbl1 (date1 date,WSH v…

  nikki_d

  2 replies

  11 years, 10 months ago

  By: nikki_d

• Please help me with this year(date) totals comparing to column values in same table

  Hello There Could you please help me here how to write condition for self table year records, such …

  asita

  9 replies

  11 years, 10 months ago

  By: asita

• group by column as sub header

  Hi, Thanks for your help in advance, much appreciated. I have a table which I would like to format …

  olibbhq

  12 replies

  11 years, 10 months ago

  By: Nevyn

• converting Year and Month varchar to date

  I have a table with Month , Year as varchar. I realized it was a big mistake. Since its getting too…

  SqlServerNinja

  3 replies

  11 years, 10 months ago

  By: jdr.suporte

• Difference between SUM(CASE...) and CASE WHEN ... THEN COUNT(*)

  Hi, I've been writing queries using SUM(CASE WHEN SomeVal = 'X' THEN 1 ELSE 0 END) And today loo…

  sqldriver

  2 replies

  11 years, 10 months ago

  By: sqldriver

• Extarct Words With Specific Format in SQL Column(text)

  hi I have Table like this clndr_idclndr_data 178(0||CalendarData()((0||DaysOfWeek()((0||1()())(0|…

  kna114

  4 replies

  11 years, 10 months ago

  By: mcx5000

• insertion in parallel

  Hello, I am trying to insert values in a single table with four columns from 4 different sources. i…

  SQLb2t

  3 replies

  11 years, 10 months ago

  By: Umer Akram