Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• Linked Server to File Folder Security Issue

  Here is my Problem: 1. I have sql 2008 R2 running on my LocalHost. 2. Created Data Base [Customer].…

  hornak.john

  4 replies

  11 years, 5 months ago

  By: Lowell

• Conditional where

  I need two tables to query together, but not if the value is blank(it is empty, not NULL) so I need…

  derekmcdonnell3

  6 replies

  11 years, 5 months ago

  By: ChrisM@Work

• How to call procedure from function. Getting error Invalid use of side-effecting or time-dependent operator in 'INSERT EXEC' within a function.

  Hi! I am trying to call procedure from function but getting following error. Invalid use of side-ef…

  mote.ajit2

  3 replies

  11 years, 5 months ago

  By: roman.asadovsky

• Adding alphabet to a number to make it unique

  create table #temp_Alpha_num ( [uniquenum] [int] Not NULL, [Somenum] [int] Not NULL, ) Insert int…

  gavva.sravan

  4 replies

  11 years, 6 months ago

  By: Sean Lange

• Data type validations

  Hi, I have two columns in the same table One is data_value (varchar) and the other is sql_data_type…

  shravan.gavva

  16 replies

  11 years, 6 months ago

  By: Orlando Colamatteo

• Microsoft SQL Temp Tables (without declaring columns – like Informix)?

  I recently changed positions, and came from an Informix database environment, where I could use SQL…

  jarrell.dunson

  14 replies

  11 years, 6 months ago

  By: michal.lisinski

• Poor query plan generated for SQL Server 2014 CTP2 clustered columnstore index

  I posted this on Microsoft's SQL Server forum but I want to post it here as well to see if anyone h…

  irabufan

  1 replies

  11 years, 6 months ago

  By: irabufan

• SQl question

  Hello Guys, Can you help me to solve these questions? Employee …

  darwesh1992

  4 replies

  11 years, 6 months ago

  By: Bhuvnesh

• Subqueries

  1. I need to find the names of the customers who have purchased academic books. (Coding required as…

  venk_sr

  4 replies

  11 years, 6 months ago

  By: Dwain Camps

• how to write Pivot Query for Following

  Hi Everyone I have wrote a query as SELECT PD.Name,PD.ContactNumber,Sum(cast(dbo.GetNumericValue…

  amitsingh308

  1 replies

  11 years, 6 months ago

  By: Richard Warr

• With Clause in SQL Server Function (UDF)

  I am trying to Write a function the needs with clause with in the function so Create FUNCTION Temp(…

  az1862

  1 replies

  11 years, 6 months ago

  By: weitzera

• how do i find 5th working day in a month.

  Hi Experts, i would like to know how to find fifth workingday* of a given month and year. workingda…

  kishorefeb28

  4 replies

  11 years, 6 months ago

  By: Jeff Moden

• Using with in SQL Server Function

  Why this doesn't work? I have to use code 2 as my atual scenerio is more complex as it brings data …

  az1862

  1 replies

  11 years, 6 months ago

  By: mister.magoo

• CURSOR and TABLE

  Hi all, I consider CURSOR and TABLE as data types but some one has argued that these are database o…

  T.Ashish

  7 replies

  11 years, 6 months ago

  By: x

• Need Help

  I have 2 tables, Parts & WOParts. Parts keeps a comprehensive list of all parts in all wareho…

  derekmcdonnell3

  11 replies

  11 years, 7 months ago

  By: derekmcdonnell3