T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Help needed in join

  Hi, Below is my table structure Create Table Company(IdCompany int primary key,CompanyName varchar…

  KGJ-Dev

  25 replies

  12 years ago

  By: KGJ-Dev

• Update field value for numbers only

  Hi all, Here's my situation: Large design flaw, I know, but we have a table with a varchar field wh…

  lbrady

  8 replies

  12 years ago

  By: lbrady

• Need to return a count per unique check in invoice table

  We have a table that has customers invoices and payment records. In some cases a customer has 10 li…

  Hyabusact

  10 replies

  12 years ago

  By: Hyabusact

• count events on date

  Hello all, I am trying to solve a problem. I have a tabel containing some events. Those events all …

  Mike Saunders NL

  14 replies

  12 years ago

  By: Mike Saunders NL

• Parent-Child Grouping

  Hi, below is my table structure Create table ParentMember(IdParentMember int,Name varchar(40),compa…

  KGJ-Dev

  1 replies

  12 years ago

  By: Lynn Pettis

• Question re Check Contraints

  Hi all, I am creating a database where each record is required to have a twin record in the databas…

  paul 31908

  8 replies

  12 years ago

  By: ScottPletcher

• INSERT/SELECT from xml.nodes very slow

  I'm currently using OPENXML to shred a large @xml variable. It can INSERT/SELECT thousands of shre…

  Bill Talada

  5 replies

  12 years ago

  By: Eirikur Eiriksson

• Syntax Error with Trigger

  Hi I have a syntax error I can't figure out. It's probably simple but I don't see it. Any suggestio…

  jdbrown239

  1 replies

  12 years ago

  By: Sean Lange

• Version Breakdown

  Currently we store our version as a string in a table. I need to break this into ints for comparis…

  JKSQL

  5 replies

  12 years ago

  By: Sean Lange

• Could this be done using PIVOT ?

  I have 2 identical tables one contains current settings, the other contains all historical settings…

  Budd

  9 replies

  12 years ago

  By: Sean Lange

• Cursor from variable

  Hi all, I am using a cursor (i know - but this is actually something that is a procedural loop). So…

  danielfountain

  6 replies

  12 years ago

  By: Jeff Moden

• Query to predict future job schedules from MSDB tables

  I want to query my msdb job and jobschedule related tables to generate a list of runtimes for each …

  SQLCurious

  1 replies

  12 years ago

  By: thava

• DEMO_CODE = 'DE1'

  Hi everyone. I have these two records in [prj_demo_data] table: prj_code demo_code decmo_…

  RVO

  5 replies

  12 years ago

  By: Koen Verbeeck

• t-sql load values from stored procedure into a temp table

  I would like to know if the following sql can be used to obtain specific columns from calling a sto…

  wendy elizabeth

  1 replies

  12 years ago

  By: Jeff Moden

• comparison in the merge statement about null values

  I use the merge statement in a sproc to insert, update and delete records from a staging table to a…

  sqlfriend

  28 replies

  12 years ago

  By: Paul White