Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Loop over all in table Current Month and Prior Month for Change Report

  Hope I explain this correctly.  I have the following query that is looking at a specific recor…

  Stephen crocker

  3 replies

  7 years, 9 months ago

  By: Stephen crocker

• Is this Deadlock due to Lock Partitions?

  The same update ran a few miliseconds apart. It causes deadlock. Col2 is primary clustered key. In …

  ayemya

  13 replies

  7 years, 9 months ago

  By: Gail Shaw

• Drop Columns in multiple tables that have Column Name similar to values in another Table

  I need help with a requirement. I am able to manually complete the requirement but hoping this coul…

  skpanda4u

  3 replies

  7 years, 9 months ago

  By: @Taps

• query just runs; possible join issue?

  This report used to run until i added the CTE to pull MAX Created date from the Broker Feed table.N…

  jeffshelix

  7 replies

  7 years, 9 months ago

  By: Eirikur Eiriksson

• How to rotate table values

  Hi guys.I need help  with query results output.I have a driver report results which looks look…

  Barcelona10

  3 replies

  7 years, 10 months ago

  By: sgmunson

• Idea working with Liquibase or Flyway to versioning database

  Hi,I am wondering how to organize work with Flyway or Liquibase tools in connection with Git. In Li…

  jaryszek

  1 replies

  7 years, 10 months ago

  By: sgmunson

• is it possible to use inner join inside case.

  Hi expert can anyone point me on the right direction, is it possible to use the joins inside select…

  jaquino012

  3 replies

  7 years, 10 months ago

  By: jaquino012

• Convert integer to time format

  Hi, I have two fields in a table that has time recorded in number format (eg; 9:31 PM is stored as …

  pajjuris

  2 replies

  7 years, 10 months ago

  By: DesNorton

• SQL Server publication keeping suscription data

  I have a publication scenario on SQL Server and I want to keep the data of the subscriber connected…

  fmejiavillegas

  3 replies

  7 years, 10 months ago

  By: sgmunson

• SQL uses 2 different executions plan (slow and fast) for a simple query. Need a new index ?

  Hi everyone, I am experiencing a performance issue with one process in our system. The performance …

  Gamleur84

  9 replies

  7 years, 10 months ago

  By: Gamleur84

• AVG a range of dates while grouping them by supplier

  I have multiple suppliers with a purchase order date. I'm trying to calculate the average time betw…

  jcobb 20350

  7 replies

  7 years, 10 months ago

  By: jcobb 20350

• SSRS Report: Any way to copy or download either an RDS file or the text needed to create one?

  It's been a while since I dealt with SSRS.   Am hoping to find an easy way to either down…

  sgmunson

  12 replies

  7 years, 10 months ago

  By: sgmunson

• Connect MS SQL Server with Progress 4gl OpenEdge database

  Hi, I want to create a connection to Linked Server with Progress 4gl database. MS SQL Server i…

  zsultan 53790

  5 replies

  7 years, 10 months ago

  By: sgmunson

• Batch Update Performance

  Hi all, I have a batch UPDATE I'm trying to use to populate a new column for historic data on some …

  mg_dba

  4 replies

  7 years, 10 months ago

  By: mg_dba

• Add Group ID value for set of sequential rows

  HiTo be honest I wasn't sure how to phrase this subject, I hope it makes sense after I describes my…

  SteveD SQL

  24 replies

  7 years, 10 months ago

  By: Jeff Moden