T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Record Delete is slowing server

  Hi folks, I have a daily process that deletes all but the last 28 days of data The table holds on a…

  JokerUK

  22 replies

  13 years, 7 months ago

  By: lnardozi 61862

• Query optimisation

  Hello all, I have two tables with the following structure - --t1 ID bigint SourceID varchar(20)) …

  AllaboutSQL

  4 replies

  13 years, 7 months ago

  By: MVDBA (Mike Vessey)

• Trying to Pull Records from Two Tables With Conditions

  I have two tables. One is my current Audit table for my ERP system and another is my archived Audit…

  ducksql@gmail.com

  7 replies

  13 years, 7 months ago

  By: Eugene Elutin

• Inserting custom query values from one into another, along with seperate corresponding field

  Hi I have a table timings with 4 different time fields namely : intime, outtime, lunchout, lunchin.…

  abs1337

  3 replies

  13 years, 7 months ago

  By: GSquared

• Pull data from another table

  I have 2 tables; tbl1 and tbl2. Information: tbl1 has the following columns; PID, PNUM, PDISC tbl2 …

  businessintelligence2010

  7 replies

  13 years, 7 months ago

  By: haseenahydrose

• Update a Table after comparing data from 2 differnt tables

  Hi, I am a beginner and don't know where to post my problem, hope i have posted it right. waiting …

  jeetendrakshetry

  4 replies

  13 years, 7 months ago

  By: Rohit Khare

• How to consolidate sequential detail rows into one summary row

  I have a table where it shows sequential actions that take place. When I have the issue happen in …

  plynch1

  6 replies

  13 years, 8 months ago

  By: plynch1

• The DELETE statement conflicted with the REFERENCE constraint "". The conflict occurred in database

  HI all , I am deleting some rows in the table .. I am Getting an Error Message : The DELETE sta…

  kodalisridevi

  5 replies

  13 years, 8 months ago

  By: Orlando Colamatteo

• insert data into a table from another table, while sorting according to a field.

  Hey, I am making attendance management system in VS2010 with RFID technology, doing all my backend …

  abs1337

  7 replies

  13 years, 8 months ago

  By: abs1337

• RAISERROR and Remote Stored Procedure

  Hi, I have a stored procedure on serverA called SP1. In a try catch block in SP1, it executes a st…

  adb2303

  4 replies

  13 years, 8 months ago

  By: Mike01

• build sql string into variable

  hi i'm trying to change a left join string based on a parameter. ..this is how i build the string..…

  spin

  12 replies

  13 years, 8 months ago

  By: Orlando Colamatteo

• dynamic operator?

  hi i have an sql proc which i'm calling from excel i want to pass in an account number as a variabl…

  spin

  4 replies

  13 years, 8 months ago

  By: Cadavre

• Return items not modified in "X" days?

  So, we have re-usable drums and totes with serial numbers and I'm trying to make a report that list…

  mellestad

  8 replies

  13 years, 8 months ago

  By: mellestad

• Insert other data with xml

  I am uploading xls to sqlserver as xml for bulk upload...it works fine for me till now...now i want…

  MuhammadShafiq

  8 replies

  13 years, 8 months ago

  By: MuhammadShafiq

• Using dynamic SQL on Information_schema views

  I'm using some scripts to insert small sets of data from DB to DB and everything works using dynami…

  blom0344

  2 replies

  13 years, 8 months ago

  By: blom0344