SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• SELECT COUNT(*) vs DMVs to get row count

  Is this an accurate way to get row count? SELECT t.name table_name, s.name schema_name, p.rows …

  sql-lover

  39 replies

  2 months, 4 weeks ago

  By: Srinivas Merugu

• convert to date

  I have a field called DueDates in table where they stored a Date value as Char(10) . mm/dd/yy How c…

  Bruin

  8 replies

  4 months, 4 weeks ago

  By: Bruin

• xp_cmdshell after a password change

  I have a windows login that is part of sysadmin, that is trying to run a stored procedure that incl…

  bmahony993

  5 replies

  5 months, 1 week ago

  By: schwegler

• Fill in missing hours for each VisitID during the day

  create table #T ( VisitID varchar(30), ER_Date date, HR int ) insert into #T(VisitID, ER_Date, HR)…

  NineIron

  12 replies

  5 months, 1 week ago

  By: NineIron

• Group records during capture

  I have a table which is being written to by another application. A few things of note I can't alter…

  Bruin

  6 replies

  5 months, 2 weeks ago

  By: Jeffrey Williams

• How can I see a DEPENDENCY TREE for objects used inside SP1 Stored Proc, and for each object referenced further inside each object, etc.?

  --------------------------------------------------------------------------- NESTED DEPENDENCIES:&nb…

  VoldemarG

  10 replies

  5 months, 3 weeks ago

  By: Jeff Moden

• Script to list replicated views and function

  I use the following code to list replicated tables: SELECT Name FROM sys.views WHERE is_replicated…

  Welsh Corgi

  9 replies

  6 months, 3 weeks ago

  By: jjradha

• TSQL query - adapt Part2 to include Part1

  CREATE TABLE [dbo].[zA]( [InvoiceNo] [nvarchar](255) NULL, [Code] [nvarchar](255) NULL, [Date] [dat…

  kevinyl

  4 replies

  8 months, 1 week ago

  By: kevinyl

• UPDATE using table alias

  Hi Gang- I have some stored procedures that do updates using table aliases, like this: UPDATE Table…

  autoexcrement

  6 replies

  11 months, 1 week ago

  By: Pete Softown

• Adapt the query to 2012

  Hello I have a query that works as a loop but it is slow. How can I do this with a standard query? …

  meryemkurs072

  15 replies

  11 months, 4 weeks ago

  By: dale_berta

• Insert using table unput

  I have a table that I need to run off a different server\db and looking for the most efficient way …

  Bruin

  14 replies

  1 year, 1 month ago

  By: Bruin

• Pivot 1 row to multiple columns using T SQL

  Hello. I have data in a table that I want to pivot from 1 row to multiple columns. I only want the …

  genova11

  5 replies

  1 year, 2 months ago

  By: Jonathan AC Roberts

• row changes per hour by TagID

  I have a large table being written too every second with equipment (PLC) information. I need to fig…

  Bruin

  12 replies

  1 year, 2 months ago

  By: Bruin

• row changes per hour by TagID

  I have a large table being written too every second with equipment (PLC) information. I need to fig…

  Bruin

  2 replies

  1 year, 2 months ago

  By: Bruin

• Row_Number issue....

  Hi   I know I'm doing something wrong in my row_number logic, just not sure what.. My data loo…

  jbalbo

  5 replies

  1 year, 3 months ago

  By: ratbak