Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• ERROR INSERT with db link 4 partname to oracle

  i have somthing strnage. when i run this command in mssql insert into [LinkedSRV]...[xfer_in_order…

  liorvikel

  3 replies

  9 years, 1 months ago

  By: Phil Parkin

• Drill down values...

  Hi, I've an orders table with customer and supplier (customer_id, supplier_id, order_id, order_date…

  PiMané

  7 replies

  9 years, 1 months ago

  By: Jeff Moden

• Determine if a table column is used?

  Does anyone know if there's any way you can determine if a column in a table is used or not? I have…

  MyDoggieJessie

  17 replies

  9 years, 1 months ago

  By: Eric M Russell

• where condition on same column doesnt return data

  i have a question, below query doesn't return any data. application is allowing filters on same col…

  mxy

  3 replies

  9 years, 1 months ago

  By: MMartin1

• Sproc/view/function code parser

  Hi - I'm looking for a code parser for SQL Server 2014 - ie something that I can point at a sproc o…

  jellybean

  6 replies

  9 years, 1 months ago

  By: Jeff Moden

• Indexes on Views - with UNION

  Hi Team, Want to create a view using below query, and also want to apply indexes on that view. SE…

  Minnu

  8 replies

  9 years, 1 months ago

  By: ManicStar

• Split Record by Field into Multiple Records

  Hello all, I have a table that I need to split up the records into multiple records by and Integer …

  Chuck S

  12 replies

  9 years, 1 months ago

  By: Alan Burstein

• Dynamic pivot and its effect on the plan cache

  We have a heavily used GUI that displays specific business data in a pivot. A stored procedure is u…

  scott.laird

  3 replies

  9 years, 1 months ago

  By: ChrisM@Work

• how to trace the effected table when a primary table is updated/inserted

  Hi, When we update/insert any table how do we know which other tables are effected in sql server? I…

  hegdesuchi

  3 replies

  9 years, 1 months ago

  By: drew.allen

• Is my use case a good fit for Unpivot and Pivot ?

  I've been trying to use dynamic unpivot and pivot (thanks to some code examples from someone named …

  pharmkittie

  7 replies

  9 years, 1 months ago

  By: pharmkittie

• WITH INDEX hint

  I was recently trying to optimize a big SQL statement (a dozen of JOINs and APPLYs), commenting som…

  cmartel 20772

  7 replies

  9 years, 1 months ago

  By: TheSQLGuru

• Include the first zero when converting time from datime into INT

  I have declare @t datetime = '2016-11-02 07:22:26.320' SELECT LEFT(CAST(REPLACE(CONVERT(VARCHAR, …

  hoseam

  7 replies

  9 years, 1 months ago

  By: Jeff Moden

• Total by Group.

  Dear All, I am trying to bring the group total .below my query, WITH Prep AS (SELECT preffered_name…

  ShawnBryan

  14 replies

  9 years, 1 months ago

  By: Chris Harshman

• Merge two tables and insert/update respectively

  I have two tables and I have to merge the records. source: ID seq name designation company 0…

  hegdesuchi

  4 replies

  9 years, 1 months ago

  By: The Dixie Flatline

• Using Lag/Lead and OVER() to get growth pattern

  Hi Guys, I've got a bit of a query problem that I am not quite getting where to start, to be honest…

  alex.sqldba

  8 replies

  9 years, 1 months ago

  By: John Mitchell-245523