SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• how to get GPNSignature that first part on it start by portion key ?

  I work on sql server 2012 I face issue i can't get GPNSignature that have portionkey exactly so if …

  ahmed_elbarbary.2010

  7 replies

  4 years, 2 months ago

  By: Jeff Moden

• Conversion failed when converting the varchar value ‘Active’ to data type int

  I work on sql server 2012 I face issue when make pivot for data I get error Conversion failed when …

  ahmed_elbarbary.2010

  3 replies

  4 years, 2 months ago

  By: Jeff Moden

• can i enhance this query to run fast on sql server 2012 ?

  I run query below it take too much time it reach to 30 minue so I need enhance it to get 5 minute o…

  ahmed_elbarbary.2010

  6 replies

  4 years, 2 months ago

  By: Jeff Moden

• what condition case when related to portion key mean ?

  I work on sql server 2012 I don't understand condition below do this condition as below case WHEN P…

  ahmed_elbarbary.2010

  6 replies

  4 years, 2 months ago

  By: Jeffrey Williams

• How to get mask related with every part on same row ?

  I work on SQL server 2012 I face issue I can't display Part Number with Mask related for family CRE…

  ahmed_elbarbary.2010

  12 replies

  4 years, 3 months ago

  By: Mr. Brian Gale

• how to get the entire sql statement while sql statment is over 4000 characters

  I use the following sql script to capture which sql statement taking more resource, but if the exec…

  892717952

  13 replies

  4 years, 3 months ago

  By: Jeff Moden

• How to update generated number field with number to every group from 1 to 4 ?

  I work on SQL server 2012 I face issue I need to update Generated Number on table test to get UNIQU…

  ahmed_elbarbary.2010

  2 replies

  4 years, 3 months ago

  By: Alan Burstein

• How to convert characters or number to underscore and after that concatenate it

  I work on sql server 2012 i face issue I need to convert characters and numbers to underscore "" an…

  ahmed_elbarbary.2010

  2 replies

  4 years, 3 months ago

  By: Jeff Moden

• How to use name alternative of acceptedvaluesoption_value when I have text after

  I work on SQL server 2012 I face issue on code below when EStrat value is number as sample >1000…

  ahmed_elbarbary.2010

  1 replies

  4 years, 3 months ago

  By: ahmed_elbarbary.2010

• This query is very slow how to enhance it to be more faster?

  I work on sql server 2012 I face issue this query when run is very slow so how o enhance it to be m…

  ahmed_elbarbary.2010

  2 replies

  4 years, 3 months ago

  By: Jonathan AC Roberts

• Database stuck in recovery mode after server restart

  Hello, We were running a particular update on a huge table and SSMS got stuck, it gave the error "L…

  kirti

  2 replies

  4 years, 3 months ago

  By: Jeffrey Williams

• hotfix for tsl1.2 ?

  hello, what hotfix do i need for the following version to enable tsl1.2? Or can someone tell me whe…

  GustlJoe2

  5 replies

  4 years, 3 months ago

  By: Mr. Brian Gale

• Can I add an index to a table type

  This is my table type definition ( below ) and as you see I declared a table whose name is in @t /…

  mw_sql_developer

  8 replies

  4 years, 3 months ago

  By: Jeff Moden

• How to find two latest prices for each ItemNo using SQL query

  I have two tables: OrderItems tabel OrderId       OrderDate      ItemNo      ItemDescrepation    Un…

  Vipul

  1 replies

  4 years, 3 months ago

  By: pietlinden

• How to rewrite sql query after where condition with another query ?

  I work on sql server I need to rewrite statement after where statement so how to rewrite I don't un…

  ahmed_elbarbary.2010

  1 replies

  4 years, 3 months ago

  By: Steve Collins