SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Need set based method to insert missing records into table - right join doesn't work

  I apologize if I don't set this up the appropriate way as this is my first time requesting help and…

  sqlmom

  15 replies

  11 years, 8 months ago

  By: sqlmom

• What is wrong with this syntax? Query will work, but CTE will not "compile"

  with UnloadDates asselect DISTINCT ShipmentID, (select Min(starttime) from tblInvoice I …

  Tobar

  16 replies

  11 years, 8 months ago

  By: Jason-299789

• Choose of join algorithm - Query Optimizer

  Hi all, Is there a sort of pattern for the query optimizer take a decision about the best algorith…

  Alexandre Araujo

  4 replies

  11 years, 8 months ago

  By: Alexandre Araujo

• chache queries

  Hi , Do you happen to know of a way to invalidate cached query plans? I would rather target a speci…

  Zohaib Anwar

  3 replies

  11 years, 8 months ago

  By: Grant Fritchey

• updated Aggregate column

  I am trying to create an aggregate table where the value is a rolling sum. Type a on date 1 is the …

  jeandlauro

  10 replies

  11 years, 8 months ago

  By: jeandlauro

• SQL query to fill RAM?

  I work for a federal government client who restricts us to using virtual machines for dev work. Now…

  jpSQLDude

  8 replies

  11 years, 8 months ago

  By: benjamin.reyes

• Create view with exploding rows into multiple

  I have a table like below: ItemIdAmountTax1Tax2SrvType 111 100 10 20 1 11…

  NERO

  4 replies

  11 years, 8 months ago

  By: David Burrows

• update query very slow sql server

  Dear friends, my table have 100000000 records. i update the data with query like …

  polo.csit

  8 replies

  11 years, 8 months ago

  By: Sean Lange

• Get original order quantities and dates, and find any changes or additions to quantities in subsequent order version(s)

  I am due to work on this problem, but I have a lot of trouble trying to figure out how to do it on …

  itortu

  45 replies

  11 years, 8 months ago

  By: itortu

• recursive queries - parent child

  Hi everyone i need to make some parent-child transformation. here is test input data: CREATE TABLE…

  priestxandar

  6 replies

  11 years, 8 months ago

  By: priestxandar

• Left join or not Left join ?

  Hello, I'm requesting your help for any ideas that could help me to do a better query, I'm trying …

  Lou

  2 replies

  11 years, 8 months ago

  By: Lou

• More than 1 alphanumeric chars in a string

  I have an employee table Surname GivenName ABC x.yz A.BC X.*YZ A*.BC xyz The query need…

  shan-422658

  22 replies

  11 years, 8 months ago

  By: Jeff Moden

• Replace code in SP

  Hi, In this SP SELECT TOP (@topval) dbo.bigtb.fire, dbo.maingroup.maingroup, dbo.bigtb.subg…

  msh083

  7 replies

  11 years, 8 months ago

  By: msh083

• Unknown object type 'SEARCH' Error when I try to CREATE SEARCH PROPERTY LIST

  I'm following along in Itzhik Ben Gan's book for Exam 70-461 Querying Microsoft SQL Server 2012, in…

  polkadot

  9 replies

  11 years, 8 months ago

  By: nbenoit

• using lookup as alternative in SCD type 2 and adding date

  guys please help me..how i can add date using ssis or data tools 2012..My flat files had no date..d…

  darksoul_1206

  2 replies

  11 years, 8 months ago

  By: pietlinden