SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• t-sql 2012 coalesce

  In t-sql 2012 there is the coalesce statement being used twice in a where clause. I do not understa…

  wendy elizabeth

  1 replies

  10 years, 10 months ago

  By: Phil Parkin

• Pivot for Multiple Metrics by Year

  Hello Team - Is there a way to show multiple metrics in 1 SQL pivot operator. Basically, I have the…

  subahan_syed

  3 replies

  10 years, 10 months ago

  By: sqlsarah

• Nonclustered Indexes on Bit Flags

  Hi All I have a scenario where I have 3 columns and all 3 of them are used in the where clauses of…

  koustav_1982

  2 replies

  10 years, 10 months ago

  By: ScottPletcher

• CASE WHEN IN string spaces problem

  Good morning! To begin with I don't know for sure what version of SQL Server this code code is runn…

  jonathan.matt

  6 replies

  10 years, 10 months ago

  By: ScottPletcher

• conver from access to sql server

  PLEASE HELP TO CONVERT SQL ACCESS TO SQL SERVER PLEASE I HAVE THIS IN ACCESS BELLOW I NEED TO CONVE…

  draganl2000

  1 replies

  10 years, 10 months ago

  By: Kedazs

• Query for user access to application modules.

  I have to create a query that will be returning the users and the application modules they have acc…

  KnowledgeSeeker

  5 replies

  10 years, 10 months ago

  By: KnowledgeSeeker

• How to subtract a column from a query result and add the difference to another

  I have a query which provides the below result set: 1165 6 1,173.0013 9740 6 9820…

  pradeepparmar18

  5 replies

  10 years, 10 months ago

  By: Dwain Camps

• Compare dates between 2 different rows and columns

  I'm having problems figuring this out. Here is an example table: What I need to be able to find i…

  matzj

  14 replies

  10 years, 10 months ago

  By: Dwain Camps

• Help finding the SQL agent job status messages

  I am building a report in SSRS which will show the status of all the SQL agent jobs ran on a partic…

  rockstar283

  2 replies

  10 years, 10 months ago

  By: rockstar283

• Performance of the query

  one of my stored proc is taking long time to run. ihave used IN in my query which i replace with jo…

  coool_sweet

  2 replies

  10 years, 10 months ago

  By: Grant Fritchey

• Live data sync

  I am trying to create a table that would represent a workload for each shop. In order to do that I …

  ile

  1 replies

  10 years, 10 months ago

  By: fahey.jonathan

• Converting query output to HTML Format

  Hi, I am working on a code that will convert the query output into a html query output. That is the…

  karthik82.vk

  6 replies

  10 years, 10 months ago

  By: serg-52

• odd cast of exponential to float issue

  For whatever reason i'm unable to cast anything more thtan e-4 to a float which makes no sence. Am …

  Snargables

  9 replies

  10 years, 10 months ago

  By: Snargables

• Trigger for updates on a row using previous record value?

  Hi there, I am not sure if a trigger is the solution but I would like to try and illustrate my issu…

  Enjoy_SQL

  35 replies

  10 years, 10 months ago

  By: Enjoy_SQL

• Windows function version of the query if possible

  Hi All, Need one help in the following query using adventureworks database. Select s.businessentity…

  aslamnepanagar

  12 replies

  10 years, 10 months ago

  By: Snargables