T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Combine to tables to display iteratively

  Hi I am looking for a way to combine the following two tables to get a result set that would look l…

  Marcus Farrugia

  6 replies

  11 years, 10 months ago

  By: Marcus Farrugia

• UPGRADTION FROM SQL EXPRESS TO STANDARAD EDITION 2008r2

  Hi, We need a calarification about upgradation sql 2008 r2 Iam going to upgrade sql express edtio…

  pradeep.k 50453

  1 replies

  11 years, 10 months ago

  By: free_mascot

• How to use stored procedure to query data in anohter server?

  Hi I am a newbie to sql server so please help me! Say I have to server, A and B. Now I want to wri…

  x1029cloud

  4 replies

  11 years, 10 months ago

  By: x1029cloud

• Help needed in join

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

  KGJ-Dev

  25 replies

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months 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

  11 years, 10 months ago

  By: thava