SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• How to check back months data depend on a column value condition

  CREATE TABLE #MyTemp(  YearCol INT ,  MonthCol INT ,  RegionName VARCHAR(200) , …

  asita

  3 replies

  8 years ago

  By: sgmunson

• Determining the Years, Months, Weeks and Days between two dates

  Hi Everyone, After reading on this topic and being advised to use DateDiff I wrote a Function that …

  jaco 85886

  8 replies

  8 years ago

  By: ScottPletcher

• What permissions do you need to run jobs via SQL Agent?

  I've googled my issue all weekend, but can't seem to solve the problem So basically, I have a query…

  cristian 26986

  8 replies

  8 years ago

  By: dmbaker

• Separating multiple Comma columns (or other delimaters)

  Hi all, We have data in this format (slightly simplified): ID      &n…

  danielfountain

  1 replies

  8 years ago

  By: Ed Wagner

• How to optimiz this slect statement please

  Hello Good Morning, How to optimize this code please advise.... SELECT CASECASE WHENWHEN UPPE…

  asita

  4 replies

  8 years ago

  By: asita

• Question on Backups

  Hi,I am a little new to this, but I have been trying to find a good explanation of the different ba…

  itmasterw 60042

  2 replies

  8 years ago

  By: itmasterw 60042

• SQL SERVER PEFORMANCE ISSUE

  I am importing (transferring) records from one server to another server : TABLE A (SERVER 1) -> …

  jkramprakash

  7 replies

  8 years ago

  By: Joe Torre

• Query no longer using Indexed View

  Afternoon, I wonder if someone can offer any suggestions I haven't thought of on the below. I have …

  sqlalix

  3 replies

  8 years ago

  By: sqlalix

• Syntax error

  CREATE PROCEDURE [dbo].[usp_test]ASSET NOCOUNT ONBEGIN BEGIN TRY  DECLARE @First_Par…

  MrXspektra

  5 replies

  8 years ago

  By: Sergiy

• Performance of Select Into vs Insert

  Hey guys, I have a sproc where Im using select into to load a staging table used for creating flat …

  dndaughtery

  4 replies

  8 years ago

  By: Jeff Moden

• Need help to write SQL Query to pull data

  Hi, I need help to write a SQL query to pull data as per where clause given below. I have database…

  tapinderaujla

  3 replies

  8 years ago

  By: Luis Cazares

• Update Trigger

  Hello all, I have a table:CREATE TABLE [dbo].[udLaborTracking](    [Co] NOT NUL…

  Ken at work

  11 replies

  8 years ago

  By: Ken at work

• RUN a stored procedure or function for every SQL session automatically

  Is there a way to run a stored procedure or a function for every new sql session automatically.This…

  skb 44459

  3 replies

  8 years ago

  By: sgmunson

• Table Valued Function causing performance issue

  Hi,I have a table valued function which is causing serious performance issue when call it from…

  ermuditsirohi

  8 replies

  8 years ago

  By: Lynn Pettis

• taking very long time to execute

  I have a table with following stats:443114382 rows, reserved 45511728 kb, 680616 kb index size and …

  saptek9

  18 replies

  8 years ago

  By: sgmunson