Development - SQL Server 2014

• Topics

  Started by

  Posts

  Last post

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

  By: Lynn Pettis

• how to convert date in varchar format into datetime

  Hello Everyone, I have table in which date is in varchar format i.e. '29/09/2013' now I want to ins…

  amitsingh308

  5 replies

  11 years, 7 months ago

  By: Dwain Camps

• Query to show Items in FIFO method.

  Dear Experts, my client needs a report which shows inventory data. he executes this report before …

  kishorefeb28

  4 replies

  11 years, 8 months ago

  By: ParulPrabu

• N' annotation

  I am still trying to make sense of the whole n' when selecting text or varchar values... Is that so…

  grecci1077

  6 replies

  11 years, 8 months ago

  By: siggemannen

• Tables inside In-Memory 2014

  How the data are stored in memory. How the memory is been shared between database and OS operations…

  yuvipoy

  1 replies

  11 years, 8 months ago

  By: Gail Shaw

• BCP Error

  Hi I'm trying to queryout a result from table to file using BCP in SQL server 2012 . My T-SQL is as…

  Srini kolar

  2 replies

  11 years, 8 months ago

  By: alekya

• how to write a query with subquery

  i want to query for consumer, phone and address, SSN information consumer table is Consumer Phone a…

  reddysrinu

  5 replies

  11 years, 8 months ago

  By: Erland Sommarskog

• how to write query

  Hello I have to generate a report in which amount should be 13 digits. e.g 2000- convert it into pa…

  amitsingh308

  12 replies

  11 years, 8 months ago

  By: Dwain Camps

• Need a Query where with case statement

  This Query is not working please help........ select * from tbl e INNER JOIN LKUP L ON e.ID=L.LKUP_…

  smharabbani40

  1 replies

  11 years, 8 months ago

  By: ChrisM@Work

• Query issue 2

  Hi if any one have solution for this please let me know. i am getting the below convertion issue wh…

  smharabbani40

  3 replies

  11 years, 8 months ago

  By: Erland Sommarskog

• query error

  Hi i am getting the below error when i run this query. Msg 241, Level 16, State 1, Line 2 Conversio…

  smharabbani40

  1 replies

  11 years, 9 months ago

  By: Sean Lange