SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• Restore Database by Store Procedure

  Hey guys! I need to create a procedure with Restore Database command in many applications in differ…

  rDrigu

  1 replies

  11 years, 5 months ago

  By: Eirikur Eiriksson

• How to get most recent and oldest from the the joins to a child table

  Hello, I have the following tables in my DB Employee table - This table has EmployeeID, Name, DOB. …

  SQLCurious

  5 replies

  11 years, 5 months ago

  By: Eirikur Eiriksson

• Running Total on 2 columns

  Table A has day to day transactions, Table B has beginning balance. I'd like to get a running total…

  bmahony993

  4 replies

  11 years, 5 months ago

  By: Eirikur Eiriksson

• SQL Pivot?

  I have data like: ItemIdCustomerItemIdCustomerPlantUnitPriceCustomerPO 63782604029-5C1…

  ken.stoner

  6 replies

  11 years, 5 months ago

  By: Eirikur Eiriksson

• altering all objects to find syntax errors

  how to alter all objects in database i want to find if can any syntax errors in my database after r…

  mxy

  4 replies

  11 years, 5 months ago

  By: mxy

• Need to understand how queries and this sample query is processed.

  I took the Adventure works example below and created my own sample to see if I can understand how …

  groads2

  4 replies

  11 years, 5 months ago

  By: MMartin1

• XML Import into multiple tables with data translation

  Hi All, I've never had to do this before, so forgive me if I'm not explaining the question well, I'…

  pixelwiz

  5 replies

  11 years, 5 months ago

  By: wBob

• condition to identify values that are +/- than 2 cents

  I want to identify rows that go negative but only for 2 cents or more as well as identify rows that…

  itortu

  3 replies

  11 years, 5 months ago

  By: itortu

• T-SQL : Problem with WHEN ... CASE

  Hi, I have a little problm.. or not 🙂 On my database, I have many NULL values and when I run my req…

  Valbuenito

  6 replies

  11 years, 5 months ago

  By: The Dixie Flatline

• How To Group By Values Over None Contiguous Data

  HI Guys I was wondering if anyone can help me. Im trying to generate a list of data such as this …

  NumptySpence

  3 replies

  11 years, 5 months ago

  By: autoexcrement

• IN / JOIN / EXISTS giving same performance in a query.

  Hi all, I have written a query in three different ways using IN, JOIN and EXISTS. As per my knowled…

  T.Ashish

  4 replies

  11 years, 5 months ago

  By: Gail Shaw

• Please help me debug this SQL

  Hi All, I've got this CTE and it's giving me fits. I'm getting the following Error which I can't tr…

  craig.bobchin

  7 replies

  11 years, 5 months ago

  By: ChrisM@Work

• How to run a SQL job using different account.

  Hi I have a job that needs to execute with different account. I figured i need a proxy so i have cr…

  Mac1986

  3 replies

  11 years, 5 months ago

  By: SQLRNNR

• how to have a conditional join, or a conditional union based on parameters passed to stored procedure

  I am writing a stored procedure that takes in a customer number, a current (most recent) sales orde…

  itortu

  6 replies

  11 years, 5 months ago

  By: x

• Database Mail Issue - Who/What is Sending it. Help please

  Hello I need some help with trying to track a email back to who/what sent it and where it is sent f…

  Knives85

  1 replies

  11 years, 5 months ago

  By: rahulgsingh