SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• SQL Query to find number of changes in ParamValue column per Paramaterid

  How do I sql script to get the number of changes happened (False To True & True - False) per Pa…

  kvishu83

  2 replies

  8 years, 9 months ago

  By: kvishu83

• Add A Column And Create A Non Clustered Index on a Table

  Good Morning Guys, I would like to ask if it is possible to Add A New Column on an Existing Table a…

  Stylez

  4 replies

  8 years, 9 months ago

  By: Stylez

• UPDATE IF NULL ELSE DO NOTHING

  Hello Team,I need to update a column of a table if it's null and do nothing if it's not null, not s…

  Michael_O

  3 replies

  8 years, 9 months ago

  By: sgmunson

• Create CSV file using xp_cmdshell

  Good day all, I am trying to run a script that will, using xp_cmdshell, create a CSV file. When I d…

  Manie Verster

  8 replies

  8 years, 9 months ago

  By: Manie

• Adding an identity column & ensuring it is ordered by existing date column

  I have a table with a CreatedDate column. I want to add an identity column and have the ints in ord…

  Sioban Krzywicki

  3 replies

  8 years, 9 months ago

  By: TheSQLGuru

• case whens using date functions

  I have tried the code below to flag certain customers upon the 'case whens' being validated.  …

  ExhibitA

  2 replies

  8 years, 9 months ago

  By: sgmunson

• export dynamic sql to a sql file to be read and executed on another sql machine

  Hello everyone, I am trying to find a way to use a dynamic sql i created, once its ran on one SQL s…

  Siten0308

  5 replies

  8 years, 9 months ago

  By: Siten0308

• How can I see queries that never completed (but might have taken significant resources)?

  Am I correct in thinking that sys.dm_exec_query_stats only includes queries that completed sucessfu…

  Tim Walker.

  3 replies

  8 years, 9 months ago

  By: Tim Walker.

• Count Difference for Every 15 Min

  Hi,  When I run the query using mulitple joins on Fact table and Dimension Table,  my Out…

  Sangeeth Raj

  9 replies

  8 years, 9 months ago

  By: Sangeeth Raj

• t-sql 2012 update statement

  In  t-sql 2012 prior to an update statement, I have a count of records which is 5039. In the U…

  wendy elizabeth

  6 replies

  8 years, 9 months ago

  By: Jeff Moden

• Need Some Urgent Help in converting the 24 hour date format to grouping with 0-23 range

  Hi Friends need some help here. I am having a table with order date(yyyy-mm-dd) order time (hr:min:…

  Ravi Teja

  11 replies

  8 years, 9 months ago

  By: sgmunson

• charindex issue

  ID = APP4005673452-45580 select SUBSTRING('APP4005673452-45580,CHARINDEX('-','APP4005673452-45580,…

  mcfarlandparkway

  6 replies

  8 years, 9 months ago

  By: ScottPletcher

• Help with SQL query

  Disclaimer: New to SQL please be patient. So: Table A:Contains list of customers that have rec…

  ExhibitA

  5 replies

  8 years, 9 months ago

  By: Thom A

• Unable to drop Primary key constraint from Filestream table

  I have a large filestream table and i want to partition that table on multiple drives, for this pur…

  zafar-458126

  1 replies

  8 years, 9 months ago

  By: WolfgangE

• Identify gaps in date in employee table

  T-SQL gurus, I'm trying to audit our EmployeeHistory table to see if there's gaps for EmployeeIDs i…

  ken.trock

  3 replies

  8 years, 9 months ago

  By: ken.trock