SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Re-ordering a Sequence

  Hello, I have a table where users enter action steps. The SEQ column indicates the step # (step 1,…

  adam-639168

  24 replies

  9 years, 7 months ago

  By: Sergiy

• Big Transaction Log

  Good estimates Evenings , Had previously expressed my concern , I have a database that size is huge…

  angelreynosog

  4 replies

  9 years, 7 months ago

  By: Sue_H

• How to add "DTL" to each record for flatfile destination in ssis

  Hi, I have requirement where i need to add "DTL" to each record to a flatfile destination in SSIS. …

  samreddy824

  4 replies

  9 years, 7 months ago

  By: samreddy824

• SQL Not returning the same as it does when embedded in a SSRS Report

  I am hoping someone can help me? I have been tasked with updating a report but for some reason when…

  David Ellams

  1 replies

  9 years, 7 months ago

  By: SoHelpMeCodd

• Find out the shift Time

  I have a main table where I need to map the Time part of Open Time (a date time field) with a shift…

  ashok.theagarajan

  4 replies

  9 years, 7 months ago

  By: Ed Wagner

• Real time working challange for Transpose data

  Hi Friends , Actually this task is doning for avoid duplication of model_trim column. we should br…

  Anand BI Developer

  2 replies

  9 years, 7 months ago

  By: Anand BI Developer

• Why won't this dynamic sql create my table?

  Hello all I am simply stumped on this very simple task and just can't get it to work at all, I have…

  pnr8uk

  2 replies

  9 years, 7 months ago

  By: pnr8uk

• Timouts inside sql server

  Hi All, This is related to timeout troubleshooting inside SQL Server. I have below scenario in my e…

  vsamantha35

  2 replies

  9 years, 7 months ago

  By: vsamantha35

• Concurrency Conflict

  Hi SQL Server 2012 db server receives insert/update calls from multiple application servers at exac…

  weekend_79

  6 replies

  9 years, 7 months ago

  By: Gail Shaw

• how to copy data from primary table and its dependencies from one id to another and then how could I remove primary table with its dependencies

  Hello, I have one table called A. A has dependencies on B. B has dependencies on c. C has dependenc…

  Virtual Reality

  3 replies

  9 years, 7 months ago

  By: Joe Celko

• SQL Pivot Assistance Needed

  Hello. I am in need of some assistance. I am trying to create a pivot view of data in SQL to repl…

  james.stanich

  8 replies

  9 years, 7 months ago

  By: Pierrot

• Sql script to check that each patient has both a diastolic and a systolic blood pressure for each given service date

  I have this simple query to extract the blood pressure measures (SERVICE_TYPE_CD in ('DP', 'SP') fr…

  pharmkittie

  6 replies

  9 years, 7 months ago

  By: pharmkittie

• Compute worked minutes group by hour

  Hi everybody, Starting from this table: [font="Courier New"]POSEmployee_IDNameDateWkTimeSta…

  deppy82

  2 replies

  9 years, 7 months ago

  By: Eirikur Eiriksson

• Handover file import to user

  Hi I have created an excel template which is populated with forecast data by a few users. Each mon…

  spin

  3 replies

  9 years, 7 months ago

  By: John Mitchell-245523

• String or binary would be truncated error.

  Hi friends , if i run this below query for column transpose purpose .., it will work well but some …

  Anand BI Developer

  9 replies

  9 years, 7 months ago

  By: Sergiy