Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

• 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 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 ago

  By: irabufan

• SQl question

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

  darwesh1992

  4 replies

  11 years 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 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 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, 1 month 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, 1 month 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, 1 month 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, 1 month 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, 1 month ago

  By: derekmcdonnell3

• Need a Query on group by condition

  Hi ALL, I have one table which contines 3 columns they are 1.emp 2.monthyear 3.amount in that table…

  smharabbani40

  13 replies

  11 years, 1 month ago

  By: ParulPrabu

• Dynamic SQL to move data from from database to another taking into account identity keys

  I'm trying to move specific data from three linked tables on a source database to three tables on a…

  Gregory Brown

  3 replies

  11 years, 1 month ago

  By: Gregory Brown

• Delete Row from one table if other table with multiple rows meet the condition

  Hi I have 2 Tables as below , I need to delete TableA row with ConsumerID = 99 as my condition wou…

  Steve Dell

  23 replies

  11 years, 1 month ago

  By: nitinkachhwaha

• The special character changed to question mark in DB

  Hi.. When i am trying to insert delta symbol into db, its converted to question mark(?) symbol. I a…

  yuvakom

  3 replies

  11 years, 1 month ago

  By: sqldriver

• How to write the Following Equevalant Query

  Hi, can anyone provide me the equivalent MS SQL server query for the following query: LOAD DATA L…

  amitsingh308

  2 replies

  11 years, 1 month ago

  By: Lynn Pettis