T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• After update trigger - only insert records not exists

  I have an address table, and a log table will only record changes in it. So we wrote a after udpate…

  sqlfriend

  2 replies

  11 years, 7 months ago

  By: sqlfriend

• Cross Join Help

  I have a massive table (company, plant, resource, part number) that I need to create a from part nu…

  dwilliscp

  21 replies

  11 years, 7 months ago

  By: Jeff Moden

• what do rows were affected mean

  I have an address table and a log table that stores historical records. So the address table have a…

  sqlfriend

  5 replies

  11 years, 7 months ago

  By: sqlfriend

• T-SQL to add 7 days to ship date

  Hello All, A quick question to all regarding my query. Below statement adds 7 days to the shipment …

  SSRS Newbie

  22 replies

  11 years, 7 months ago

  By: ZZartin

• T SQL script improvements

  Hi everyone Hope someone can offer some advice. Been stuck on this one for a while. Trying to use t…

  MickyD

  1 replies

  11 years, 7 months ago

  By: Lynn Pettis

• Report

  Hi Team, For pre-paring report I need this format report on instance. Database Name Database Us…

  shiv-356842

  2 replies

  11 years, 7 months ago

  By: SQLRNNR

• Trigger is not working as expected

  Hi , 1) I have two tables , chat and country tables , chat table has 3 columns(chat_id,language,ch…

  raju.venkatsv

  6 replies

  11 years, 7 months ago

  By: Gail Shaw

• One to many problem

  I have three tables I want to match two of them based on the third. CREATE TABLE #Check1 (IDX INT, …

  djj

  3 replies

  11 years, 7 months ago

  By: djj

• Problem with Round

  I have the following problem with ROUND. When doing the calculation for each value by a percentage …

  mballico

  6 replies

  11 years, 7 months ago

  By: Sean Pearce

• SQL Query Help Please

  Hello Everyone, I need to write a report where I query against my table that holds employee's Pay D…

  DiabloSlayer

  6 replies

  11 years, 7 months ago

  By: Lynn Pettis

• Conversion from varchar to strong data types

  Hi all, There are a few databases I work with that have been designed where varchar columns are use…

  Drammy

  6 replies

  11 years, 7 months ago

  By: Luis Cazares

• Returning MAX(Value) in String

  Hello comunity I need help to create a TSQL to return MAX(Value) removing the first part and last p…

  luissantos

  3 replies

  11 years, 7 months ago

  By: luissantos

• T-SQL to get value on any given day

  I have a table that records when a value changes. For example item = x, date = 2014-06-15, value = …

  OldCursor

  14 replies

  11 years, 7 months ago

  By: Sean Lange

• Filtered index "AND" and "OR"

  I am trying to create an index for a specific query that is used a lot. Unfortunately I am keep get…

  DennisPost

  3 replies

  11 years, 7 months ago

  By: Gazareth

• Need suggestions on dividing two rows within a CASE statement

  Hello, I was given the task to come up with a result set based on certain criteria: Please add one …

  PFlorenzano-641896

  2 replies

  11 years, 7 months ago

  By: PFlorenzano-641896