T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Records common in both tables

  panpk  is identity value. I am trying to how many records (count) are common between both the …

  curious_sqldba

  2 replies

  8 years, 12 months ago

  By: mhtanner

• Qty Adjust based on Last date

  Dear All Experts, I have an table where data is coming as below and i want the output as per the la…

  abhitkumar

  1 replies

  8 years, 12 months ago

  By: pietlinden

• function to return fraction from decimal and rounds to the nearest 16th

  I want to convert a decimal number to a fraction and round to the nearest 16th. the fraction should…

  rosarozina

  4 replies

  9 years ago

  By: Luis Cazares

• Send E-Mail if job has not run for X hours

  Hey there,I've come across a specific need for a script (to run i.e. as a sql job hourly) which sen…

  shp.shftr

  4 replies

  9 years ago

  By: shp.shftr

• Need help to perform Weighted avg calculation to update back to table

  Hi all,  Actually i am working in banking domain. Our company has decided to change the data p…

  JoNTSQLSrv

  4 replies

  9 years ago

  By: JoNTSQLSrv

• Devide ' n' Conquer techniques in t-sql query writing

  Hi Folks,It would be a great help for me if you suggest some best ideas or blogs where we…

  Anjan@Sql

  3 replies

  9 years ago

  By: Chris Harshman

• UPDATE Duplicates Except for One Record in a Table

  Hi All,I need to set a field in a product table for a bunch of products. We have some duplicated pr…

  donato1026

  12 replies

  9 years ago

  By: Jeff Moden

• Help with query

  Hi all, I'm having a moment, and I can't seem to get the query right. I'm trying to get the actual …

  schleep

  11 replies

  9 years ago

  By: schleep

• Hierarchical data :skipping child rows up to the parent

  Hi ,I have hierarchical data in a table  having UserId and his ParentIDEvery user has a task ,…

  SJanki

  3 replies

  9 years ago

  By: Jeff Moden

• Can I eliminate or move a WHEN from a CASE statement for a more efficient code?

  SELECT DISTINCT  col1,  CASE   .   .  WHEN Name IS NOT NULL THEN…

  TheSQL_fan

  6 replies

  9 years ago

  By: Sergiy

• Query Date Help

  Hi, I have a query that is looking at the current Month. My issue is that there is a gap if it's th…

  mbrady5

  4 replies

  9 years ago

  By: mbrady5

• Help with Daterange split please

  CREATE TABLE table1 (  PersonID int,  startdate datetime,  enddate datetime  )…

  misstryguy

  5 replies

  9 years ago

  By: Sergiy

• SP output is -1

  when we get a store procedure output as -1 ?

  Ron007

  4 replies

  9 years ago

  By: Sue_H

• Joining on date only

  I am trying to join these two tables based on date only, for instance, 05-03-17 SELECT top 5 Create…

  TheSQL_fan

  6 replies

  9 years ago

  By: Jason A. Long

• best way to learn T-SQL

  hi so i want to know what is best way to learn TSQL, like i know all functions and what it does in …

  coool_sweet

  3 replies

  9 years ago

  By: coool_sweet