Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Sanitising inputs when creating a sql string by concatenation in C#

  I'm not sure if this is really the right sub forum but it seemed the closest fit. It's really abou…

  FunkyDexter

  3 replies

  11 years, 2 months ago

  By: FunkyDexter

• SQL Query to make a single records from multiple records based on different fields of different records

  I need help in writing the query for the following, I need to collapse the continuity. If the termd…

  sattar419 10789

  1 replies

  11 years, 2 months ago

  By: doug.brown

• Please hlp me to creating package upsert

  Hi, Please help me how to create package upsert industry and want to do update and insert operatio…

  jeni.jm23

  4 replies

  11 years, 2 months ago

  By: Grant Fritchey

• How to remove trailing zeros from a decimal (type) value?

  Hi Everyone, I would like to 'drop' some trailing zeros from a decimal value, e.g.: 50.000000, and …

  david.dartnell

  4 replies

  11 years, 3 months ago

  By: david.dartnell

• Get SharePoint logged-in user using SQL Server

  Hi I have created a SharePoint external list using SQL Server, the data source is SQL Server. Is th…

  thamilanga

  2 replies

  11 years, 3 months ago

  By: thamilanga

• Best Development of SQL Server 2014

  SQL Server 2014 is the best server ever all. Fixed price Appliance repairs from the ServiceNET Prof…

  appliancerepairssouthendon

  1 replies

  11 years, 3 months ago

  By: Ron McCullough

• count the order on weekly basis

  I want the count of orders of a particular table on weekly basis i.e if date given to me is 10\03\2…

  vinaya_2690

  5 replies

  11 years, 3 months ago

  By: Aditya Daruka

• Migrate from Oracle trigger to MSSQL trigger

  Hi I am new to MSSQL server. I have problem in migration from ORACLE trigger to MSSQL server. Here …

  myofficenilu

  2 replies

  11 years, 3 months ago

  By: gautham.gn

• UNABLE TO RETRIEVE data while using between operator

  Hi Experts, I came across a weird issue this morning while using Between operator am unable to retr…

  kishorefeb28

  8 replies

  11 years, 3 months ago

  By: Sushil Dwivedi

• dense_rank

  Team, Using of Dense_rank() and row_number will leads to any performance issue? if yes can please s…

  JohnNash

  6 replies

  11 years, 3 months ago

  By: Gail Shaw

• adding one more column for SubTotal in Select statement

  HI EXPERTS, need your help badly....... We have a table with 2 columns 'OrderNo' and 'Amount' as be…

  kishorefeb28

  7 replies

  11 years, 3 months ago

  By: Dwain Camps

• When is an In-Memory table a good solution?

  I've read through a few articles on In-Memory tables for 2014, such as the one below. It seems that…

  AbrahamLeftJoin

  3 replies

  11 years, 3 months ago

  By: Andreas.Wolter

• Hierarchical order by TSQL

  Dear Sir create table Hierarchy ( ParentID int, ChildID int ) go insert into Hierarchy values (101,…

  hifaizal90

  18 replies

  11 years, 4 months ago

  By: hifaizal90

• Sql database recovery?

  Databases in my MS SQL Server 2014 have a condition - suspend, according to SQL Management Studio. …

  oleskurilenko

  2 replies

  11 years, 4 months ago

  By: Grant Fritchey

• Subtotal when vendorcode changed.

  Hi Experts, i need to write a stored procedure for a table with below columns for instance the tabl…

  kishorefeb28

  11 replies

  11 years, 4 months ago

  By: Luis Cazares