SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Stored Procedure - not sure how to join another table into the select statement

  I have another issue (I feel like I am taking this forum over) and need help. I have a stored proce…

  vecerda

  1 replies

  11 years, 11 months ago

  By: Jim Mackenzie

• Trying to incorporate RANK or NTILE with LEAD function

  My scenario is as follows: We have accounts that pay for a particular "premium" service. It's ent…

  SoCal_DBD

  5 replies

  11 years, 11 months ago

  By: SoCal_DBD

• SEPERATING NUMERIC & ALPHABETICAL VALUES FROM STRING

  Hi there, I need to split NUMERIC & ALPHABETICAL values from string. for eg :- 1234heaven56-…

  balasubramaniyam.sc

  3 replies

  11 years, 11 months ago

  By: Mike Dougherty-384281

• Obtaining a comma delimited list for each group in the output of a Group By query

  Hi, I'd like to ask how you would get the OUTPUT below from the TABLE below: TABLE: id categor…

  rsryanstephen

  3 replies

  11 years, 11 months ago

  By: David Burrows

• Cursor Help

  Thanks, this topic is Delete

  rocky_498

  9 replies

  11 years, 11 months ago

  By: Jeff Moden

• Incremental load

  Hi, We need to implement incremental load in database. A sample scenario is, there is a view (INCOM…

  Jim1234

  1 replies

  11 years, 11 months ago

  By: Jim Mackenzie

• Purge Process Help

  Hi all, I am attempting to do a rather simple purge task on a very large table. This task will nee…

  PrettyDBA

  3 replies

  11 years, 11 months ago

  By: Sean Lange

• SLICING DATA IN A TABLE

  I have a table composed as the following: VendorNbr varchar(15), CCOde varchar(1), PayDate numeric(…

  Nilssond

  4 replies

  11 years, 11 months ago

  By: Dwain Camps

• SQL Help needed...

  Have the following data in the table. Declare @tblRawData as table ( WorkItemId int, WorkItemDescr…

  s-sql

  10 replies

  11 years, 11 months ago

  By: ChrisM@home

• DateAdd from Max DateValue Column

  Hey Everyone, I am trying to generate a @StartDate and @EndDate. The @StartDate would be the 1st o…

  Rank1_nj

  2 replies

  11 years, 11 months ago

  By: Rank1_nj

• insert (xml dml) error

  from http://technet.microsoft.com/en-us/library/ms175466.aspx USE AdventureWorks2012; GO DECLARE …

  mssqlnoob

  2 replies

  11 years, 11 months ago

  By: Alan Burstein

• T-SQL Help

  Hi, CREATE TABLE #TempTable ( [GROUP] VARCHAR(100), [Status] Varchar(10), CreateDate Datetime…

  PSB

  28 replies

  11 years, 11 months ago

  By: Dwain Camps

• Insert row with values from previous row if does not exist

  Hi, CREATE TABLE #MyTable ( Teams VARCHAR(10), StartDate DATETIME, Count INT ) INSERT INTO #MyTa…

  PSB

  3 replies

  11 years, 11 months ago

  By: PSB

• Stored Procedure to remove all records that don't have max FileID

  I have a SQL 2012 database that has 10 tables. One of the tables is populated by manual import from…

  vecerda

  6 replies

  11 years, 11 months ago

  By: vecerda

• Get Next Id with a MERGE

  Hi, I have a table with a field called SeqId which is not an identity nor a sequence but a kind …

  Mauricio_

  2 replies

  11 years, 11 months ago

  By: Mauricio_