T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Trying to UnPivot without using multiple selects unioned together

  I've got a table that is populated from the OUTPUT from an update statement: declare @Update TABLE …

  WayneS

  50 replies

  15 years, 3 months ago

  By: The Dixie Flatline

• Optimize SQL Queries

  Hello I have two queries whose results are inter connected. The result for Query 1 is input to the…

  shantanusenin

  18 replies

  15 years, 3 months ago

  By: RichardDouglas

• Calling Batch File (from Network Location) using T-SQL

  Hello there, I wanted to call a batch file (which is available in network shared location) from SQ…

  prakash.tamilarasan

  3 replies

  15 years, 3 months ago

  By: prakash.tamilarasan

• not updating inserted row in an insert trigger

  Hi ! I have a insert trigger which is used on canteen invoice detail table. It should ideally calcu…

  aspardeshi

  6 replies

  15 years, 3 months ago

  By: aspardeshi

• RegEx query not working

  I'm trying to query records that are strictly integers via a regex query (not with real regex, just…

  andegre

  5 replies

  15 years, 3 months ago

  By: andegre

• Complicated Subquery

  I have 2 tables. Table 1: Primary Key – ID CreatedDateField Table 2: Table1’s Primary Key – records…

  byrdmom2

  4 replies

  15 years, 3 months ago

  By: byrdmom2

• Extremely slow query

  I have 4 tables to use that have the following format and row counts PersExpByQuarter Has 71920 rec…

  loki1049

  15 replies

  15 years, 3 months ago

  By: SQLRNNR

• Procedure not executing in trigger

  Hi, I have create the procedure to insert the data from one database to another database. and creat…

  pankaj.kuchaliya

  6 replies

  15 years, 3 months ago

  By: drew.allen

• Find Minimum

  Hi, Based on the data below, how would I find the minimum frees pace of only one drive for each cli…

  EjSQLme

  2 replies

  15 years, 3 months ago

  By: EjSQLme

• Dateformat different if Stored Procedure is run from a job

  Hi there. I just spend over an hour wondering why a stored procedure executed as job behaves differ…

  shadow_2

  1 replies

  15 years, 3 months ago

  By: shadow_2

• XML parameter passing (into a stored proc) and subsequent parsing

  Hi, I have been googling and trying to solve this most of the morning. I have the following SQL; DE…

  Rob Priestley

  3 replies

  15 years, 3 months ago

  By: Rob Priestley

• No function FINDSTRING?

  I want to return everything in a certain value before the first '('. LEFT(esl.text,FINDSTRING(esl.t…

  DrStrangepork

  3 replies

  15 years, 3 months ago

  By: Alvin Ramard

• pivot query

  hi all, i am new to t-sql i need to sum of the sales based on months and quarters together can some…

  sayedkhalid99

  11 replies

  15 years, 3 months ago

  By: drew.allen

• Subqueries to Inner Joins

  Hi all, how would these selects be written as joins? Thanks, BLL --Checking for Services records fo…

  blacklabellover2003

  4 replies

  15 years, 3 months ago

  By: Maxim Picard

• sp_SEND_DBMAIL - Pass variable as parameter.... shows null value?

  I have an SP that runs and updates a column in the database. I setup a dbmail profile and everythin…

  Mike Menser

  3 replies

  15 years, 3 months ago

  By: Maxim Picard