T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• merging intervals with identical data

  I'm having issues building a cte sql statement for merging intervals and I would greatly appreciate…

  N_Muller

  3 replies

  11 years, 8 months ago

  By: N_Muller

• Isolating a list with pattern search

  Hi, I'm trying to pull up a report of restored databases from our bug tracking software to audit an…

  sqldriver

  6 replies

  11 years, 8 months ago

  By: sqldriver

• String occurrence count with Cross apply

  Hi All, See sample data below. I'm trying to count the number of occurrences of strings stored in t…

  kiril.lazarov.77

  10 replies

  11 years, 8 months ago

  By: kiril.lazarov.77

• Search Special characters

  Hi All, I am using SQL Server 2008. In one of my table, one column has values like "MFY RLHH CSQÉ"…

  Mahesh Bote

  2 replies

  11 years, 8 months ago

  By: Eirikur Eiriksson

• RTRIM not removing trailing spaces

  Hi guys, I am loading a dimension using a distinct query. There are duplicates coming through and t…

  Ian C0ckcroft

  4 replies

  11 years, 8 months ago

  By: Ian C0ckcroft

• Insert text in a text field

  Hi, i would appreciate suggest the SQL sentence, thanks CREATE TABLE [dbo].[instructions]( [site_n…

  cphspain

  3 replies

  11 years, 8 months ago

  By: Eirikur Eiriksson

• After Insert or Update Trigger

  I currently have a AFTER UPDATE trigger that looks at a specific column being updated. It works gre…

  bpowers

  2 replies

  11 years, 8 months ago

  By: bpowers

• how to use substring and charindex to extract desired string

  Hi, All I have a column that contains the follwoing string I need to compare. ek/df/cv/ ek/df/cv/f …

  MaggieW

  9 replies

  11 years, 8 months ago

  By: MaggieW

• I need to Update a column with AutoNumber

  Hi, I need to update a column with AutoNumber which is depending on some other column. the output s…

  CherrySqlserver

  3 replies

  11 years, 8 months ago

  By: Kingston Dhasian

• How to calculate total sum of these table

  Hi Friends i ve the table like create table accutn_det ( fs_locn char(50), fs_accno varchar(100…

  raghuldrag

  13 replies

  11 years, 8 months ago

  By: David Burrows

• How to implement the following query

  Hi everyone, First of all, I would like to say thanks for your time reading this and I hope you cou…

  mai.quangvinh

  4 replies

  11 years, 8 months ago

  By: sgmunson

• Returning multiple TOP records?

  Ok all, here is my setup: I have the following tables - tblPerson - holds basic person data. tblPer…

  kpwimberger

  9 replies

  11 years, 8 months ago

  By: sgmunson

• Not sure how to write this query without cursors and/or dynamic sql

  I have a couple of tables that look like this: CREATE TABLE Colors ( Id INT NOT NULL, ColorName VA…

  TheGreenShepherd

  12 replies

  11 years, 8 months ago

  By: sgmunson

• Resources for tuning large workloads

  Hi, It seems that a lot of the performance tuning books and articles I read assume up front that da…

  sqldriver

  9 replies

  11 years, 8 months ago

  By: ScottPletcher

• Filtered index with IS NULL predicate

  Hello everyone. I believe query optimizer can leverage the predicate used to define the filtered in…

  baoshan sheng

  33 replies

  11 years, 8 months ago

  By: ScottPletcher