SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• SQL Query assistance

  Hi Team, I need to optimize a query, Please let me know how to fix this code, the DB size is 3…

  Davekahn

  4 replies

  8 years, 7 months ago

  By: Gail Shaw

• CREATE TABLE FROM CTE's

  I have a series of complex CTE's, which I would like to use to drop the results into a table. …

  ExhibitA

  3 replies

  8 years, 7 months ago

  By: ExhibitA

• t-sql programming

  Hi all I know Sql basics , what is the  path or way to study T-sql programming topic wise Any …

  db8

  3 replies

  8 years, 7 months ago

  By: Steve Jones - SSC Editor

• To compare previous rows then update

  I am using SQL Server 2012 and fairly new to writing queries.  I am stuck with this one for a …

  faylc

  9 replies

  8 years, 7 months ago

  By: faylc

• Get the balance prior to account being close (get Previous record prior to being closed)

  I have a scenario where I need to get the balance from the previous records prior to account being …

  Garin T

  6 replies

  8 years, 7 months ago

  By: Garin T

• SQL temp table issue

  Is there any patch made in SQL about handling temporary table? Previously the SQL (2012) is seeming…

  aasree

  5 replies

  8 years, 7 months ago

  By: aasree

• Do it all in C# instead?

  Possibly a bit of a Friday afternoon question.I've been working on a product for about 10 years. Th…

  julian.fletcher

  12 replies

  8 years, 7 months ago

  By: sgmunson

• how to create random values for 1 million records or 10,000 records

  CREATE TABLE dbo.RandomData (   RowId INT IDENTITY(1,1) NOT NULL,  firstname VARCHAR(10),…

  db8

  7 replies

  8 years, 7 months ago

  By: Kaye Cahs

• Query Help

  I have several tables that I am working with trying to get some data:SALES_ORDERS S -  header …

  shanegair

  7 replies

  8 years, 7 months ago

  By: shanegair

• Replace string

  Hi I need to replace these values as blank space from a string Hello all! & #160; How Are you …

  PSB

  10 replies

  8 years, 7 months ago

  By: Jeff Moden

• tempdb curiosity

  I maintain a sql server 2012 server with 4 tempdb files.  The first one is on a different part…

  fizzleme

  14 replies

  8 years, 7 months ago

  By: Jeff Moden

• XML to compare two rows is slow when dealing with large sets

  We have a process where every time an update is made to a table the current / new records are writt…

  lspfister

  1 replies

  8 years, 7 months ago

  By: Joe Torre

• Query Help

  I have Data set like this create table #Data(BID int, AID int, DID int, OV varchar(50))insert into …

  inayatkhan

  7 replies

  8 years, 7 months ago

  By: inayatkhan

• Need Help on schedule days

  I have created temp table and inserted data, problem is we have schedule days column staring from 0…

  koti.raavi

  3 replies

  8 years, 7 months ago

  By: koti.raavi

• How to find post, which is NOT related to another table

  Hi! Shortly descipted - the tables are at the end of this post - I have two tables:Dutyrostershift…

  Edvard Korsbæk

  2 replies

  8 years, 7 months ago

  By: Edvard Korsbæk