SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• How to find the first recurring character of a string.

  I have a query that finds the first recurring character in a string. For eg : if @str = 'ABCCDA' t…

  TheCTEGuy

  46 replies

  8 years ago

  By: Sergiy

• tsql requirement

  Hi All, Need some help in tsql.I want to have a new generated column (i.e. Txnid), for every 1..6 …

  vsamantha35

  2 replies

  8 years ago

  By: vsamantha35

• problem with group by query

  I have a query that performs an average on a particular column but its giving me unexpected results…

  solus

  2 replies

  8 years ago

  By: MMartin1

• Export to CSV using bulk copies data, can't write to local

  Table in my db should be exported to csv file via bcp query. I managed to export it on the Server s…

  dejanbltamamovic

  2 replies

  8 years ago

  By: Thom A

• problem with script not getting correct values

  I have two tables one table have lists of tasks and the second table have list of spares which are …

  Nomvula

  4 replies

  8 years ago

  By: Thom A

• SQL - How to replace certain repeated values with null

  I'm trying to null the values for BOMSEQ_0, CPNITMREF_0, YREF_0 and TEXTE_0 from both parts when th…

  matthew.lingard

  2 replies

  8 years ago

  By: matthew.lingard

• CTE - Cursor - Try Catch

  Hi,I am not able figure out how to catch the data conversion error in the select statement. can you…

  rxm119528

  12 replies

  8 years ago

  By: Jeff Moden

• Need help in improving performance of a stored proc which invokes multiple scalar functions on the resultset

  I have stored proc which fetches a lot of data and the performance is really bad. The problem is th…

  atulnathr

  14 replies

  8 years ago

  By: atulnathr

• a sub query filter

  is it possible to dynamically find the row containing the largest numeric value to return only one …

  BRP

  3 replies

  8 years ago

  By: BRP

• PURGING DATA

  HI All, I have an assignment, to Purging data, with conditions:1. Keep the full data 6 months (keep…

  Deny_Christian

  17 replies

  8 years ago

  By: MMartin1

• CLR to write to the Windows Event Log

  I have a requirement to write an error to the Windows Event Log when the number of rows in a table …

  giles.clapham

  9 replies

  8 years ago

  By: Jeff Moden

• Return Code for an If Statement

  Hello,  I am writing a Stored Procedure and would like to return an error code for a web appli…

  rjjh78

  4 replies

  8 years ago

  By: Jeff Moden

• Backups

  Hi, Guys i have a one question. I have a db where backup is 50 gb.Is it possible to backup only dat…

  iseedeadpeople

  5 replies

  8 years ago

  By: jasona.work

• How to get updated datetime from updated records

  I have one main table tbl_con and one more Audit tbl_Aud_con. tbl_con has trigger(AFTER) when …

  Gaja

  1 replies

  8 years ago

  By: Phil Parkin

• Removing Time from Date when adding to Gridview

  I am trying to run a SELECT statement and post the results to a Gridview in C#.  Everything wo…

  Matt.Altman

  8 replies

  8 years ago

  By: Matt.Altman