SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Monthly running total, year to date running total, full running total on same row

  Hi! I've been using SQL for a few months, but am completely stumped by how to create a running tota…

  sophie.harper

  6 replies

  7 years, 5 months ago

  By: sgmunson

• Automated restore from disk - different content at MS pages

  Hi, i´m struggling with a script to restore a database from disk. I would like to write a SP with t…

  michael.molz

  2 replies

  7 years, 5 months ago

  By: michael.molz

• carving out bussiness hours.

  so i'm newish to SQL and SSRS but i'm working on a report that allows me to calculate average times…

  madmilitia

  20 replies

  7 years, 5 months ago

  By: DesNorton

• RTO AND RPO

  Hai all, kindly please help me..I want to know RTO and RPO timing on databases.what is the syntax?

  Deny_Christian

  2 replies

  7 years, 5 months ago

  By: Grant Fritchey

• Help needed on TSQL query: update using a self join

  Hi Experts, Need help on an update query. I want to take all status = 'IN' records qty values and …

  vsamantha35

  8 replies

  7 years, 5 months ago

  By: sgmunson

• Return last amount larger than 0

  Hi guys,I have a table of accounts by month.I need to return the last amount larger than 0e.gUnique…

  Ian C0ckcroft

  11 replies

  7 years, 5 months ago

  By: Eirikur Eiriksson

• Return All affected dbs in error

  SELECT   [DB]  FROM [LogNewTables] where Newtable > 0 and logDate > Datea…

  Super Cat

  7 replies

  7 years, 5 months ago

  By: Jeff Moden

• Fast ways to load data from SQL server to SQL server

  Hi I have a table in SQL server which has over 5 million records and around 12 columns and wis…

  george_at_sql

  17 replies

  7 years, 5 months ago

  By: Jeff Moden

• Comparing part of an address string, 2 columns.

  Hi, I would like to ask for help regarding how to do a partial string comparison of two address va…

  itortu

  1 replies

  7 years, 5 months ago

  By: sgmunson

• Looping code with multiple Updates performance drop off

  Hi all, first post be gentle. I have a few pieces of code which include Updates from temp tables, a…

  dweben

  3 replies

  7 years, 5 months ago

  By: Lynn Pettis

• Deadlock issue

  Hi All, Need some help in fixing the deadlock. Will an Intent exclusive (IX) lock can cause deadlo…

  vsamantha35

  7 replies

  7 years, 5 months ago

  By: vsamantha35

• Call Stored Procedure from a View / OPENROWSET Research

  We are running SQL Server 2012 on Windows 2008. I have read that some reasons for needing to c…

  HookSQLDBA7

  2 replies

  7 years, 5 months ago

  By: sgmunson

• Cross Apply not summing correctly

  I have a group of records that I can sort of get working  but the inner cross apply is doublin…

  tshad

  11 replies

  7 years, 5 months ago

  By: tshad

• Single value in selection with groups

  I am trying sum some columns and have a column that is different in each row but I only want one ro…

  tshad

  6 replies

  7 years, 5 months ago

  By: tshad

• Query Help

  Hi, I was tasked to address the following requirement. A table contains the weekly (last 12 weeks) …

  seismicbeat

  6 replies

  7 years, 5 months ago

  By: Chris Harshman