Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• stored procedure for tagging same contact information

  Hi, I'm stumped at how to create a stored procedure that would group and identify contact informati…

  raymond.wee.823

  9 replies

  9 years, 3 months ago

  By: ChrisM@Work

• Last day of month in a WHERE clause

  Hi all! Have looked a bit around to find something here, but only found something about how to calc…

  Edvard Korsbæk

  25 replies

  9 years, 3 months ago

  By: ChrisM@Work

• [HELP] SQL Server 2014 Database Tuning Advisor

  What causes the DTA Engine to cause this problem, "Tuning process exited unexpectedly" ? I tried to…

  jcarlxv15

  1 replies

  9 years, 3 months ago

  By: TheSQLGuru

• Difference Between source OrderItems And ReturnOrderItems

  HI We have 4 Tables : 1- Order (Head of orders) 2- OrderItems (Details Of orders) 3- ReturnORD (he…

  sm_iransoftware

  7 replies

  9 years, 3 months ago

  By: Joe Celko

• Relationship of Operator cost and execution time

  Hi, I have 1 query, which as below select [USERNAME] ,[JOBNAME] ,[STEPNBR] from [dbo].[JobStep]. Al…

  sqlbaby2

  7 replies

  9 years, 3 months ago

  By: Gail Shaw

• Difference between ROW_NUMBER() and ORDER BY...DESC

  Hi guys This is just for interest sake from my side. I have the following code entered into Advent…

  frdrckmitchell7

  7 replies

  9 years, 3 months ago

  By: Alan Burstein

• Does express edition in sql server 2014 supports business intelligence ?

  Hi All, Does express edition in sql server 2014 supports business intelligence ? I need to create a…

  yuvipoy

  2 replies

  9 years, 3 months ago

  By: yuvipoy

• Error when i try to upload multiple rows

  i have two pages the first one select.php shows 4 records when i can modify one value in each one b…

  pedro.imex

  3 replies

  9 years, 4 months ago

  By: Phil Parkin

• Cross Database Procedure exexcution

  Hello Everyone, I have 2 Databases DB1 & DB2 (Owner is 'sa' for both) Table1, SP1 both exists …

  kasamsandeep

  1 replies

  9 years, 4 months ago

  By: Jeff Moden

• server side trace

  Hi Guys, I am currently setting up a server side trace that will run constantly on a server for one…

  Jim-S

  5 replies

  9 years, 4 months ago

  By: Sue_H

• Cast Varchar to Float Resulting In (Scientific) E Notation

  I have a pipe delimited text file which I bulk insert into a SQL table with all fields being of dat…

  RonMexico

  22 replies

  9 years, 4 months ago

  By: MMartin1

• Select name and count(records) from all tables in DB

  Hi all! I have a db with app. 500 tables. Many af them are empty, or has just a very few records. N…

  Edvard Korsbæk

  2 replies

  9 years, 4 months ago

  By: Edvard Korsbæk

• simple dynomic Transpose 2 column as 2 rows

  Hi friends , i would like to transpose powerunit_natlang and transmission_natlang columns. please s…

  Anand BI Developer

  1 replies

  9 years, 4 months ago

  By: Gail Shaw

• Seconds to hours??

  I am pulling data from an Avaya system, What I am trying to do. Example, I am pulling from [dAgentB…

  bcrockett

  5 replies

  9 years, 4 months ago

  By: Jeff Moden

• Error handling in my stored procedure

  Posted in error

  SQLCurious

  1 replies

  9 years, 4 months ago

  By: The Dixie Flatline