SQL 2012 - General

• Topics

  Started by

  Posts

  Last post

• after add two statement stuff query executing take long time as 5 minute?

  I work on SQL server 2014 after add two stuff statement to script below it become very slow before …

  ahmed_elbarbary.2010

  2 replies

  3 years ago

  By: frederico_fonseca

• inner join give me huge data when package id equal package id from another table

  I work on sql server 2014 i face issue when join two tables as inner join from table package it hav…

  ahmed_elbarbary.2010

  8 replies

  3 years ago

  By: Mr. Brian Gale

• Are there are any way to get partc without make join by Verification Hash?

  I work on sql server 2014 I need to get partc as expected result Actualy i need partc from table #p…

  ahmed_elbarbary.2010

  6 replies

  3 years ago

  By: Jeff Moden

• Opinion for the better game server

  I am currently upgrading my game server and I have 3 options 1- Ryzen 5950x / 128GB ECC / 3.84Tb NV…

  bissagars

  8 replies

  3 years ago

  By: Mr. Brian Gale

• error The index entry of length 1890 bytes for the index 'IDX_EStrat' exceeds th

  i have table create index on it but it give me error so how to solve it please   CREATE TABLE…

  ahmed_elbarbary.2010

  2 replies

  3 years ago

  By: ahmed_elbarbary.2010

• How to add top 1 row as header on SQL server as extra row ?

  I work on SQL server 2014 I face issue but I don't know how to solve it I need to add columns heade…

  ahmed_elbarbary.2010

  2 replies

  3 years ago

  By: Jeff Moden

• How to get different time between every row and previous row

  i work on sql server i can't calculate created date time from every row and previous based on creat…

  ahmed_elbarbary.2010

  5 replies

  3 years ago

  By: DesNorton

• How to use group by instead of distinct when execute dynamic SQL query @SQL ?

  I work on SQL server 2012 i need to use group by instead of distinct so how to do that please query…

  ahmed_elbarbary.2010

  1 replies

  3 years ago

  By: Mr. Brian Gale

• what i do to enhance this statement select into ?

  I Work on sql server i have slow transfer data when make select into small number of rows it take t…

  ahmed_elbarbary.2010

  3 replies

  3 years ago

  By: DesNorton

• How to add Extra Header as rows on result of pivot ?

  I work on sql server 2012 i need to add extra row as same header to result of pivot my code as belo…

  ahmed_elbarbary.2010

  2 replies

  3 years ago

  By: PB_BI

• Dynamic procedure pivot not accept multi columns SQL server ?

  I work on SQL server 2012 i face issue when using multi column ON COLUMN as companyid,Year exec [db…

  ahmed_elbarbary.2010

  4 replies

  3 years ago

  By: Phil Parkin

• SQL Object Usage like Views, SP's

  Over the period of time we created lot of customer stored procedure and views. We would like to aud…

  skb 44459

  3 replies

  3 years ago

  By: Mr. Brian Gale

• Sql 2012 service pack 3 fails to install

  Hallo. Hope you can help. Im trying to install Sql 2012 Service Pack 3 on one of my servers, but it…

  karbomike

  1 replies

  3 years ago

  By: Eddie Wuerch

• Fill down empty cells with values from a previous non-empty row

  Hi , I have written code to fill empty rows from previous non-empty row, attached piece of code, it…

  koti.raavi

  6 replies

  3 years ago

  By: rocketseeds

• How to get data from two tables from sub procedure to main procedure without usi

  I work on sql server 2014 I can't get data from sub procedure to main procedure sub procedure will …

  ahmed_elbarbary.2010

  3 replies

  3 years ago

  By: ratbak