Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Write to table, send email, mark as sent

  I have a few triggers but know they can cause issues if everything doesn't fire correctly. What I w…

  jcobb 20350

  3 replies

  6 years, 8 months ago

  By: pietlinden

• Remove duplicate substrings from string

  Hello experts, I have a problem I'd appreciate advice on please. I'm asked to determine distinct co…

  mickey w

  10 replies

  6 years, 8 months ago

  By: ScottPletcher

• insert from an Excel linked server did not enforce table constraints

  I have a table with an Hours column that allows null and has a default constraint of 0.  When …

  DBAless

  2 replies

  6 years, 8 months ago

  By: frederico_fonseca

• Case When Between issue

  I have a list of suppliers and their next review date. The date is always on a Monday but there cou…

  jcobb 20350

  4 replies

  6 years, 8 months ago

  By: jcobb 20350

• LAG Function, to compare two rows

  I need to have SQL look at the previous row and comare the previous row is a "Y" or an "N"in the el…

  jeffshelix

  2 replies

  6 years, 8 months ago

  By: Thom A

• Merge Multiple Rows into a logic

  Good Day, Please find below my requirement : --SOURCE TABLE CREATE TABLE [dbo].[SourceTable]( …

  sqlquery29

  7 replies

  6 years, 8 months ago

  By: sqlquery29

• Find individual column mismatch between source and target

  Hi All, Source table:CREATE TABLE EMP_CLIENT( ID INT     NOT NULL,&n…

  saravanatn

  7 replies

  6 years, 8 months ago

  By: saravanatn

• Two selects, a column is invalid in the the second Select,but not first

  t.Duty_Saved is an INVALID COLUMN Name in the second Select but not the first.Odd.  Thoughts?&…

  jeffshelix

  4 replies

  6 years, 8 months ago

  By: ScottPletcher

• very slow select

  Team, I have this query that runs quite a long time, actually the result is not been displayed at a…

  Tomys

  55 replies

  6 years, 8 months ago

  By: Jeff Moden

• How to add year to membercode already exist on table firstprintcardfooter

  Problem Cannot add year to this query  SELECT FirstPrintCardFooter.FooterNotes,FirstPrintCard…

  ahmed_elbarbary.2010

  3 replies

  6 years, 8 months ago

  By: ninjamy

• Beginners Question

  Hi Guys, I clearly don't understand how SQL deals with negative selection. Please consider the foll…

  Jim-S

  2 replies

  6 years, 8 months ago

  By: Jim-S

• Order BY clause in View using Stuff Function.

  I have two views. My First View definition CREATE VIEW FIRST_VIEW AS SELECT PT.F_PRODUCT AS F_…

  jkramprakash

  8 replies

  6 years, 8 months ago

  By: jkramprakash

• access token value

  Hi, i have the below script :{  "access_token": "7mYWLVjfbttKjxT4_T_rL8SGFMKHjjjhhiTTkklkhKHKK…

  ikrami2000

  4 replies

  6 years, 8 months ago

  By: ikrami2000

• Permission - Execute as - Issue

  Hi, Having some trouble seeing where the issue is here:  alter PROCEDURE pec.jpwPermissionTes…

  krypto69

  1 replies

  6 years, 8 months ago

  By: Sue_H

• Truncate Table Over Linked Server to Oracle

  Is there any way to do a table truncation across an oracle linked server?  I have looked up me…

  amy26

  1 replies

  6 years, 8 months ago

  By: frederico_fonseca