SQL Server 2012 - T-SQL

• Topics

  Started by

  Posts

  Last post

• XML Query Help

  I have four tables and I want to create one XML file. I provided the temp tables with data and expe…

  inayatkhan

  3 replies

  11 years, 6 months ago

  By: wBob

• Exclude rows where value in column not found in another row

  This is a followup to a previous question to a previous but in reverse of Find rows where value in …

  jaymezek 9886

  2 replies

  11 years, 6 months ago

  By: ChrisM@Work

• Manager and Employee Hierarchy

  Hi, I need to get a hierarchy where manager gets to see all employees working under him and all emp…

  PSB

  4 replies

  11 years, 6 months ago

  By: Ant-Green

• SQL Trigger multi row updates

  Good Day I am attempting something I haven't done before with a trigger, I am logging multi row ins…

  marc.heidemann

  3 replies

  11 years, 6 months ago

  By: Jack Corbett

• Find rows where value in column not found in another row in the same table

  Can't seem to make this SQL query work! I have searched for the answer to this and although some po…

  jaymezek 9886

  2 replies

  11 years, 6 months ago

  By: jaymezek 9886

• Composite Index performance

  Hello, thanks in advance for any help. I have a large table with 500M records. It has a primary c…

  jjf112

  21 replies

  11 years, 6 months ago

  By: Igor Micev

• Simple Linked Server Query from SSMS to datatable syntax

  Hello I have a linked server and when I execute this query, I can see the Database, ex: ( http://ms…

  andrewcwatts

  2 replies

  11 years, 6 months ago

  By: andrewcwatts

• Cross Tab, UNION or Different solution for this problem?

  Hello, I have a requirement to join actual sales data to projected sales data based on periods, qua…

  vecerda

  10 replies

  11 years, 6 months ago

  By: vecerda

• Distinct and count

  SELECT Distinct MAGINUS_SUPPLIER.SUPPLIER_ACCOUNT, MAGINUS_SUPPLIER.SUPPLIER_NAME,MAGINUS_SUPPLIER.…

  SQLAssAS

  12 replies

  11 years, 6 months ago

  By: Lynn Pettis

• Missing Text Data

  Thank you to everyone that read my response yesterday. Also Thank you to the guys that gave great c…

  AndrewSQLDBA

  1 replies

  11 years, 6 months ago

  By: Andrew Kernodle

• Fill in Missing Data

  Hello Everyone I hope that you all had a wonderful weekend. I am working with some data that is not…

  AndrewSQLDBA

  3 replies

  11 years, 6 months ago

  By: AndrewSQLDBA

• Difference between ROWS UNBOUNDED PRECEDING And ROWS BETWEEN 2 PRECEDING AND CURRENT ROW

  Hello, What's difference between 'ROWS UNBOUNDED PRECEDING' And 'ROWS BETWEEN 2 PRECEDING AND CURRE…

  Hardy21

  4 replies

  11 years, 6 months ago

  By: Hardy21

• MSG 3154 The backup set holds a backup of a database other than the existing database.

  I'm creating a module for our testing team to copy database in same server without using any wizard…

  sirvikasrana

  16 replies

  11 years, 6 months ago

  By: Gail Shaw

• How to call a stored proc once per each row of a table, without using CURSOR

  Hello Everyone, I have a situation where I need to call a stored procedure once per each row of tab…

  SQLCurious

  9 replies

  11 years, 6 months ago

  By: Eirikur Eiriksson

• Optimize SQL

  Hi, We have an application management planning in which we must manage: First   - Daily attendance …

  Arno Ho

  35 replies

  11 years, 6 months ago

  By: J Livingston SQL