SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Dynamic Lag Function

  Afternoon All, i am stumped on a lag function which i need some advice/guidance on how i could solv…

  waxb18

  5 replies

  10 years ago

  By: Sachin Nandanwar

• Dump data from .txt file into SQL Table using Bulk Insert.

  Hello All, I have a requirement to dump the below data from .txt file into SQL Table using Bulk Ins…

  Mac1986

  3 replies

  10 years ago

  By: Mac1986

• Instead Of Trigger to pseudo-update computed column

  We are doing some refactoring of our database, and we are redefining a status column in a parent ta…

  bartedgerton

  5 replies

  10 years ago

  By: Gail Shaw

• Finding retention of a person

  I would like to ask if anyone would be able to help out with this. I would be more than happy to up…

  Stephen crocker

  14 replies

  10 years ago

  By: Sachin Nandanwar

• Assign Variables

  How do I assign row values to variables? Let’s say I have a table with one column called Values wit…

  mceventphoto

  8 replies

  10 years ago

  By: ScottPletcher

• parent/child relationships

  have the following 2 tables: declare @Policy table ( AccountNum nvarchar(5), PolicyNum nvarchar(20)…

  scottcabral

  4 replies

  10 years ago

  By: scottcabral

• 3TB database

  I have 3TB database and MDF is 2TB, how to create secondary file?

  PJ_SQL

  4 replies

  10 years ago

  By: Hugo Kornelis

• conditionally count method

  I need to do a report for all available flavors sold in different regions. However I only want to c…

  Magy

  2 replies

  10 years ago

  By: Sergiy

• I don't understand why I'm getting an "invalid column name" error when creating this SP

  I'm trying to create a stored proc using both a function and a view. I'm getting an "invalid column…

  Rod at work

  6 replies

  10 years ago

  By: csolervicens

• Automation to find element path in xml files

  Hi, I am trying to automate some manual process where i have to read some attributes and insert the…

  SQL006

  2 replies

  10 years ago

  By: SQL006

• Looping up and down records in a table?!

  I currenlty have a stored procedure which puts together a table which quite a clot of complicated r…

  gleavek

  3 replies

  10 years ago

  By: John Mitchell-245523

• Take out sub-query

  I have this script below: How can I take out the sub-query in this? select datepart(yyyy, D.Date)…

  PJ_SQL

  2 replies

  10 years ago

  By: Sachin Nandanwar

• Is it possible to alias a function within a SELECT statement?

  I'm working on converting some MS Access queries into SQL Server equivalents. (Ultimately this is s…

  Rod at work

  1 replies

  10 years ago

  By: Sergiy

• Pivot table

  Hi, CREATE TABLE #Status ( Cycle INT, Name VARCHAR(20), Status VARCHAR(20), ForecastDate DATE, …

  PSB

  2 replies

  10 years ago

  By: PSB

• Integration thru CRL fail executing function

  Hi, i am trying to use CLR to make integration task, by this i create a dll in c# with several func…

  felipejjr

  3 replies

  10 years ago

  By: Phil Parkin