T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Trying to Use Substring(charindex) to remove start of a string

  Looking at a trace table and trying to remove all the "erroneous" bits in a string e.g the declare…

  simon_s

  8 replies

  11 years, 6 months ago

  By: simon_s

• How to use sp_send_dbmail to send email to some list of data

  This is my table and a few data, IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID…

  Little Nick

  3 replies

  11 years, 6 months ago

  By: Shawn Melton

• Need to Copy a Master Record and its detail records

  Hi all, I have been asked to give the users the ability to copy a set of records within the databas…

  mmaynard 31214

  4 replies

  11 years, 7 months ago

  By: mmaynard 31214

• SSRS Expression Issue

  Hello All, I'm having an issue with adding parameters to the report with the below statement. When …

  SSRS Newbie

  9 replies

  11 years, 7 months ago

  By: SSRS Newbie

• Determine which pattern comes first in a string<!-- 864 --><!-- 864 -->

  Offhand, what's the best way to do this? DelimitedSplit8k and PatternSplitLoop seem to have potent…

  sqldriver

  19 replies

  11 years, 7 months ago

  By: sqldriver

• Need help to using PATINDEX

  My 2 tables and data as following, CREATE TABLE [dbo].[u_CV]( [CVID] [int] NOT NULL, [nme] [nvar…

  Qira

  3 replies

  11 years, 7 months ago

  By: Eirikur Eiriksson

• Generate script for view dependencies of user defined table types ?

  Hi All, can you please provide the T-SQL script for the following request ? Generate script for vie…

  kbhanu15

  2 replies

  11 years, 7 months ago

  By: kbhanu15

• Matching the value after using STUFF

  This is my code, table and result, declare @t_JobNoticeID table (cvid int, JobNoticeID int) insert…

  Qira

  5 replies

  11 years, 7 months ago

  By: Eirikur Eiriksson

• Query Help

  Hi All Experts, I am a newbie in SQL Server and would like your help on the following query. Please…

  JackTimber

  21 replies

  11 years, 7 months ago

  By: Eirikur Eiriksson

• Rolling Max Value

  Hi SSC, I've got a problem I'm trying to solve as efficiently as possible. I've attached simplified…

  Xedni

  13 replies

  11 years, 7 months ago

  By: Dwain Camps

• Need help on pattern matching

  My 2 table and data as following, CREATE TABLE [dbo].[u_CV]( [CVID] [int] NOT NULL, [nme] [nvarch…

  Qira

  1 replies

  11 years, 7 months ago

  By: Dwain Camps

• Need help on Update statment with where condition

  I've table and data as follow, CREATE TABLE [dbo].[x_Score]( [idx] [int] IDENTITY(1,1) NOT NULL, …

  Qira

  10 replies

  11 years, 7 months ago

  By: LutzM

• Get First day previous quarter from today's date

  Hello All, How do I get first day of last month of previous quarter from today's date? I know my qu…

  SSRS Newbie

  2 replies

  11 years, 7 months ago

  By: SSRS Newbie

• Scalar UDF versus Inline UDF

  Hello, Running SQL 2008 R2 Enterprise. I am aware of the fundamental difference between how a scala…

  jallmond

  8 replies

  11 years, 7 months ago

  By: Lynn Pettis

• Difference between INFORMATION_SCHEMA.COLUMNS and sys.columns

  Hello, if I want to get a list of column names which is better to use INFORMATION_SCHEMA.COLUMNS or…

  djj

  11 replies

  11 years, 7 months ago

  By: ScottPletcher