SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Need help with backup statement for a SQL Server 6.5 instance

  Hi all: Yes-your eyes are not failing you-my client has a SQL 6.5 instance for databases that have …

  Tim Cullen

  3 replies

  11 years, 5 months ago

  By: Rudyx - the Doctor

• Database log file is full?

  Hi, I am receiving the below message however when going into my database properties and going into …

  cstrati

  1 replies

  11 years, 5 months ago

  By: Grant Fritchey

• Group Column Based On Anouther column

  I have Table Like this t_id w_id t_codew_name 358553680A1100EVM Method Project 35856…

  kna114

  1 replies

  11 years, 5 months ago

  By: ChrisM@Work

• Splitting time span into multiple entries

  Looking for assistance in returning multiple entries from a time span. I have a date, start-time, …

  Janet Barnett

  8 replies

  11 years, 5 months ago

  By: Eirikur Eiriksson

• Stored Procedure Performance

  I was wondering if anyone knows of a way to speed this stored procedure up some, there are no pk or…

  cbrammer1219

  53 replies

  11 years, 5 months ago

  By: wBob

• Compress table timelines

  Here is data I am working with: CREATE TABLE HISTORY(CUSTOMER VARCHAR(10), PLANNBR VARCHAR(10), SUB…

  Nilssond

  5 replies

  11 years, 5 months ago

  By: sgmunson

• storing FOR XML EXPLICIT results to tmptable

  SQL 2012R2 Std I have a sql statement to retrieve data in XML format. I have to use EXPLICIT becau…

  cfmx

  3 replies

  11 years, 5 months ago

  By: sgmunson

• SP to compare records

  I have a table that have different groups in it, All the records that belong to one Group have the …

  MaggieW

  2 replies

  11 years, 5 months ago

  By: MaggieW

• Odd issues - alter procedure not changing procedure

  I'm trying to change references to a fully qualified object to a semi qualified in a stored procedu…

  Jeff Shurak

  7 replies

  11 years, 5 months ago

  By: Jeff Shurak

• Can't get rowcount to return to calling stored procedure

  SQL Server 2012 Standard SP 1. Stored procedure A calls another stored procedure B. Rowcount is set…

  Nicole Garris

  2 replies

  11 years, 5 months ago

  By: Nicole Garris

• Maximum Tenancy Ref

  Hi there, I have the following script - SELECTDISTINCTLOC.[place-ref] AS 'Place Ref' ,PL…

  TSQL Tryer

  5 replies

  11 years, 5 months ago

  By: TSQL Tryer

• Audit problem, enable audit issue.

  Hi everyone. I hope this is in the correct category and the correct way to represent my problem. I'…

  (inactive)frysdisken

  1 replies

  11 years, 5 months ago

  By: (inactive)frysdisken

• Exit Code 1073741571

  I have an SSIS process that is misbehaving. Here is the edited error code: Selected row details: D…

  jarid.lawson

  7 replies

  11 years, 5 months ago

  By: Eirikur Eiriksson

• Purging data from Master and 5 child tables

  Hi All, I have 6 tables which are very huge in row count and records needs to deleted which are old…

  Mac1986

  21 replies

  11 years, 5 months ago

  By: Jonathan AC Roberts

• Analytical Help - Customer Lifetime Value

  Hi all, I have been given the job to create a query that will help show the lifetime value of custo…

  scottsanpedro

  4 replies

  11 years, 5 months ago

  By: scottsanpedro