SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Sales Order vs Warehouse Inventory Stock FIFO

  Dear All, Table  1 is the sales order that received in each different day for inventory ID 122…

  weilingleong

  3 replies

  8 years, 1 months ago

  By: drew.allen

• t-sql 2012 using temp table

  In some new t-sql 2012 that I am going to be setting up, I will be loading some data into #temp tab…

  wendy elizabeth

  2 replies

  8 years, 1 months ago

  By: TheCTEGuy

• data insering from staging table to final table how to avoid duplicates? please

  I have two tables Table1(has 10 columns), Table2(has 22 columns). every time I insert data from tab…

  asita

  4 replies

  8 years, 1 months ago

  By: Phil Parkin

• deleting duplicate rows based on a condition

  I've cobbled together other answers from similar posts but can't quite get over the finish line.I'm…

  skippyV

  9 replies

  8 years, 1 months ago

  By: TheCTEGuy

• Total amount paid by year then vendor

  I have one report for which i need total amount paid for the year by the vendor based on each year.…

  EasyBoy

  2 replies

  8 years, 1 months ago

  By: TheCTEGuy

• Updating 1 record in Table A with multiple records in Table B

  Hello.  SQL Server 2012, novice level programmer.  I am trying to UPDATE a master table w…

  jchatton1

  18 replies

  8 years, 1 months ago

  By: TheCTEGuy

• View creation with conditions

  Hello, I have an application that create some meetings inside a tool and some freelancers will do t…

  team.bernard

  3 replies

  8 years, 1 months ago

  By: sgmunson

• How to get a "Cumulative" weely report?

  My task is to get a cumulative weekly status report, for a period of time, i.e. last 12-month. The …

  jay-125866

  8 replies

  8 years, 1 months ago

  By: John Mitchell-245523

• Database trigger to send email after column in table is updated.

  Hello all, Thank you for any help given in advance, it is much appreciated. Scenario - What I …

  mattdarvellwow

  10 replies

  8 years, 1 months ago

  By: TheCTEGuy

• Creating a table from existing table.

  I have a table which is 175GB in size. I am working on getting only the data from August and on.&nb…

  NewBornDBA2017

  7 replies

  8 years, 2 months ago

  By: kevaburg

• Comma separated list

  Is there any efficient way to get a comma separated list than the query below ? This query is getti…

  PSB

  4 replies

  8 years, 2 months ago

  By: kevaburg

• Query Help :)

  Hi,Guys i have a task for daily report in SQL 2012 r2  so i have to take all customer ID from …

  iseedeadpeople

  1 replies

  8 years, 2 months ago

  By: Phil Parkin

• Dividing a count of rows from a table into equal batch sizes using NTILE

  Good afternoon all. I am trying to figure a way of getting the total row count of a table and divid…

  duncanburtenshaw

  3 replies

  8 years, 2 months ago

  By: duncanburtenshaw

• Running total challenge - SORT OF

  Hello ladies and gents! I have a task that has boggled me for a few days now. What the client needs…

  marty.seed

  3 replies

  8 years, 2 months ago

  By: Jason A. Long

• Returning an attribute from a range of numbers

  Hi all! Thanks in advance for the help. I have quite a dilemma for a query and I'm not even sure ho…

  jhols1

  12 replies

  8 years, 2 months ago

  By: Thom A