Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• decimal places correction

  Hi All, I want my numbers to be converted from a column which is of nvarchar(100) datatype to decim…

  vsamantha35

  4 replies

  8 years, 1 months ago

  By: GaryV

• Unusually Expensive Deletes

  Hi all, I have a scenario on a few of our servers that I can't quite explain that I'm hoping someon…

  sh856531

  6 replies

  8 years, 2 months ago

  By: Eric M Russell

• Tricky LAG() and Windowing Script

  I have a requirement where 3 records *should* be getting recorded on the patient at the same time. …

  Vertigo44

  5 replies

  8 years, 2 months ago

  By: Vertigo44

• Query to omit single record based on data from two columns?

  Hi there, I need help with a query to remove a record from a data set. I need to remove BranchNumbe…

  zach.routt

  3 replies

  8 years, 2 months ago

  By: Lynn Pettis

• Add only changed or new rows to table

  Hi I am a DBA who does a small bit of SSIS / TSQL development and have been given a project to read…

  LightShip

  9 replies

  8 years, 2 months ago

  By: GaryV

• Nested If statements

  Hello,I have a prob with the follow  stored procedure, can any one help me with this pleaseI d…

  benny 52509

  4 replies

  8 years, 2 months ago

  By: Eirikur Eiriksson

• 0 or $0.00 instead of NULL?

  SELECT    '$' + CONVERT(VARCHAR(12), SUM(CAST([ie].[AMOUNT] AS MONEY))) I tried…

  chef423

  12 replies

  8 years, 2 months ago

  By: Jeff Moden

• Query to find what current query the procedure is executing.

  Dear All,Have a job on a server in which it executes a stored procedure that is present in other li…

  adilahmed1989

  4 replies

  8 years, 2 months ago

  By: Jeff Moden

• SSMS 2014 not opening PRC/TAB/UDF files in SQL Query Editor

  I am running SQL Server 2014 SP2 CU3 on Windows 7 Enterprise. I'm unable to get SSMS to open files …

  Rick Thomas

  2 replies

  8 years, 2 months ago

  By: Rick Thomas

• Incrementing integer values within closed quotation marks and parentheses in VBA for SQL

     I have to add incrementing integer values within closed quotation marks and parenthese…

  leavesandmusic

  4 replies

  8 years, 2 months ago

  By: Umer Akram

• Trigger after update not working when updating 2 or more rows

  Hello,whats wrong here, when I update only one row everything is fine. But when there are more then…

  orenk

  5 replies

  8 years, 2 months ago

  By: Lynn Pettis

• How to resolve one to many linkage

  CREATE TABLE [dbo].[Client]([ID] [int] NOT NULL,[Full_Name] [char](50) NULLPRIMARY KEY CLUSTERED (…

  rkordonsky 63916

  11 replies

  8 years, 2 months ago

  By: rkordonsky 63916

• Operating system error 5: "5(Access is denied.)".

  HiCan anybody advise me, what is wrong or what am i doing wrong?

  yrstruly

  5 replies

  8 years, 2 months ago

  By: yrstruly

• Scope of Variables in Stored Procedure

  I have simple statement:USE iMIS_DevGO--BEGIN TRAN DECLARE @ID      &…

  rkordonsky 63916

  11 replies

  8 years, 2 months ago

  By: rkordonsky 63916

• Failed to start debugger - Data is Null.

  I'm a developer working on a web application using an instance of SQL Server 2014. I use Visual Stu…

  garrett.bates

  3 replies

  8 years, 2 months ago

  By: tim 28156