T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• huge diffence direct query vs query view

  Engine: SQL Server 2008 R2 Service Pack 2 CU12 (I know, but I'm stuck with it) When I copy the code…

  Johan Bijnens

  16 replies

  8 years ago

  By: Johan Bijnens

• 3-level reporting hierarchy.

  Hi I have a requirement where I need to get employees managers up to 3 levels. (Example : A(Employe…

  abhas

  3 replies

  8 years ago

  By: aaron.reese

• Slow queries during busy times

  We have a SQL 2008 Enterprise Edition server with 32 GB of memory and 16 CPU.During quiet times of …

  Casper101

  13 replies

  8 years ago

  By: Jeff Moden

• splitting column into two

  Hello I am working to split one colume named "name" that includes the LastName/Firstname seprated w…

  alhakimi

  8 replies

  8 years ago

  By: Jason A. Long

• SLOW QUERY FOR Movements of Stock

  HI expert,i need an help to speed up an apparently simply queryI have a table MGMOV with about…

  gsassanelli

  3 replies

  8 years ago

  By: TheSQLGuru

• How to categorise my customer last 3 year , 2 year and 1 year not billed?

  Hi Friends, desc  tab1locn varchar(10)cust_no  varchar(10)address varchar(10) desc tab2cu…

  raghuldrag

  5 replies

  8 years ago

  By: drew.allen

• Query help- check min(column1) , if column1 is same take max( column 2 )

  Hi all, I have a question , I was trying to get a result based on 2 different conditions that I hav…

  sql_learner29

  4 replies

  8 years ago

  By: seshagirikudaravalli

• how to find cutsomer who is not billed after 31-march-2017?

  desc cust_master locn_no varchar(20)cust_no  varchar(20)address varchar(20) desc  billed_…

  raghuldrag

  2 replies

  8 years ago

  By: ChrisM@Work

• running stored procedure in a loop to get Top level Demand(s) form a Supply

  i would like to create a stored procedure to find the Top Level Demand for a Supply .I have a store…

  skb 44459

  9 replies

  8 years ago

  By: Jeff Moden

• Openquery Update Single Quote Issue

  Hi All, I am using Openquery to update a remote server but run into an issue where a quote exists …

  Gribbs

  2 replies

  8 years ago

  By: Joe Torre

• Nested sub queries with SUM, optional parameters in Storedprocedure

  Hi,The following storedprocedure (seems) to work fine when I supply all the optional parameters.But…

  JJR333

  4 replies

  8 years ago

  By: Gail Shaw

• Getting sum of current and next row in sql server 2008/2005

  Dear Sirs My data is as below till 3rd columns Year Month Sumsales Curr_Next 2016 12 100 2…

  dineshcred

  1 replies

  8 years ago

  By: Gail Shaw

• MAX() FROM VALUES with GROUP BY

  Hi all, I know you can use the MAX(v) FROM (VALUES () AS VALUE(v)) query to select the max value fr…

  kramaswamy

  4 replies

  8 years ago

  By: Avi1

• Creating View with More Records than original table

  I am not sure if this can be done but I would like to create a view (or 2nd option a new table that…

  les.61

  6 replies

  8 years ago

  By: HanShi

• Subroutines in TSQL

  I am a heavy TSQL coder, I love the many aspects of TSQL but I always wonder why we should not have…

  sihaab

  96 replies

  8 years ago

  By: GaryV