Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• how to rollback transaction explicitly

  By forcibily i tried to fail insert statement (Insert into dbo.student) by entering 1/0 value into …

  mcfarlandparkway

  6 replies

  1 hour, 33 minutes ago

  By: Brahmanand Shukla

• TSQL assistance to reduce output of the query

  Hi Experts, Wondered if someone with TSQL knowledge can let me know how I can amend the below TSQL …

  Buddy84

  2 replies

  12 hours, 9 minutes ago

  By: Buddy84

• Need Help: On Query with Case Statement

  Hi, As part of development task I have to write a SQL logic for the below 6 scenarios, I have achie…

  windows_mss

  2 replies

  1 day, 23 hours ago

  By: John Mitchell-245523

• A bit of mathematics...

  Hi all, I'm just doing some work on my own bank statements imported from CSV.   Two salient column…

  JaybeeSQL

  2 replies

  2 days, 12 hours ago

  By: JaybeeSQL

• Is it possible to compare columns' content?

  I have a table of objects. Each of them has various references, e.g. from reference 1 to reference …

  BOR15K

  3 replies

  3 days, 13 hours ago

  By: BOR15K

• Using SELECT LEFT and WHERE IN in the same SELECT Statement.

  Greetings ~ I'm trying to get the following query to work in SQL 2014 [Code] SELECT LEFT(AKey, 3) A…

  MarkW.Rhythm1

  10 replies

  5 days, 16 hours ago

  By: ScottPletcher

• Effect of force update stat on tables used by query when db auto update stat on

  Hi, Developer complain that in  dynamic AX  production ,application query execution time degrade…

  ebooklub

  1 replies

  6 days, 9 hours ago

  By: Sue_H

• Saving Hebrew text as nvarchar

  Is there something special I need to do to be able to save some Hebrew text in my table?    I ha…

  mjohnson 71479

  8 replies

  6 days, 14 hours ago

  By: mjohnson 71479

• Extracting certain numbers from a string

  Hi Guys, if object_id('tempdb..#Equipment') is not null drop table #equipment create table #equipme…

  Jim-S

  2 replies

  6 days, 23 hours ago

  By: Jim-S

• Optimizing a stored procedure that uses cursor

  There is a long running stored procedure. The 2nd (visit) and 3rd (billing) tables are used just fo…

  keneangbu

  7 replies

  1 week ago

  By: Luis Cazares

• redistribute by total dollar value (not by count)

  Table X: Consumer bigint (PK) CurrentGroup bigint DollarValue money I want to redistribute records …

  scott.laird

  2 replies

  1 week ago

  By: Phil Parkin

• Guaranteed Varchar to Date conversion

  I regularly load in multiple files using SSIS into a staging table and then onto another table (I c…

  Ells

  10 replies

  1 week, 5 days ago

  By: DesNorton

• Sql script Transpose Multiple Column into Rows

  Hi   i've the current situation DtCont        | DtCont       | DtCont | -------------…

  Bomby

  5 replies

  1 week, 6 days ago

  By: Joseph.caldwell 19590

• Deadlock while updating the same table - SQL

  There is a stored procedure that updates pre_plan and pre_type for all associates. And it is deadlo…

  keneangbu

  7 replies

  2 weeks, 1 day ago

  By: keneangbu

• Sequential Token Management in sql server

  I am looking for a better solution to achieve following task I have a table as shown below CouponNo…

  sivaay1223

  3 replies

  2 weeks, 1 day ago

  By: ben.brugman