SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Nulls and the CASE statement

  Dear DBAs I have a database which includes values such as:Main entrance In Main exit out Main entra…

  hurricaneDBA

  14 replies

  8 years ago

  By: Phil Parkin

• How can this query be created?

  Friends, I have few records like this. **empNum  SlNo  CODE 4001 1 SRM 4002 2 SRD…

  Mandan

  5 replies

  8 years ago

  By: Thom A

• Report on table size growth

  Hi all, I  have a  table  that has the below columns: Capture_DateDB_NameSchema_Nam…

  shahgols

  1 replies

  8 years ago

  By: Sue_H

• Foreign keys disappear following replication

  I have a merge replication configuration. The publication database has a number of tables…

  Pete Bishop

  4 replies

  8 years ago

  By: Pete Bishop

• for xml path and STUFF missing the first character

  Hi I have SELECT --CheckDate,stuff((  SELECT DISTINCT ',' + ProcessName  FROM [database]…

  hoseam

  1 replies

  8 years ago

  By: Eirikur Eiriksson

• Substring Question

  Hi,I trying to extract the value from a field until a special character   eg: firstname.lastna…

  gjoelson 29755

  16 replies

  8 years ago

  By: Alan Burstein

• Pivot - Very challenging queries?

  Hello Experts, I have a table with the following data: FieldName FieldValue RecordStatus C…

  Naveen J V

  4 replies

  8 years ago

  By: Umer Akram

• Need Help with T-SQL Query (Grouping Columns)

  Hi All,I need a bit of help with my query below. select distinct  vc.Name as Hostname,  …

  Ricky Valencia

  3 replies

  8 years ago

  By: Umer Akram

• Extra Statistics

  I have a table with 50 columns, 15 indexes and 100+ statistics.  I thought statistics were for…

  mike 57299

  1 replies

  8 years ago

  By: Gail Shaw

• Bulk load architecture

  Hello SQL Guys,I am working on a project where in a file location I will be getting daily files lik…

  sqlenthu 89358

  27 replies

  8 years ago

  By: Jeff Moden

• Log Shipping and replication Maintenance

  Hi, Please help on below issues I have registered my all server in CMS. Some of servers config…

  annamsiva.dba

  1 replies

  8 years, 1 months ago

  By: Steve Jones - SSC Editor

• Compare 2 rows using tsql code

  Hi All, A questions which is there with me a long long time. Comparing 2 rows in a table. How can …

  vsamantha35

  18 replies

  8 years, 1 months ago

  By: vsamantha35

• create table in mutiple schemas

  hi, i need to create single table in nearly 50 schemas.can anyone provide automation script for this

  Arjun SreeVastsva

  2 replies

  8 years, 1 months ago

  By: SQLPirate

• SSIS : "The value could not be converted because of a potential loss of data.".

  Dear all, I have a data conversion task and I am getting the following error message: while conver…

  river1

  6 replies

  8 years, 1 months ago

  By: sgmunson

• Need help on extracting to XML format - Solved

  Hi, I have the following table: CREATE TABLE dbo.TimeTable (  WorkDate date,  EmpID int,&…

  dcw8888

  3 replies

  8 years, 1 months ago

  By: TheCTEGuy