T-SQL

• Topics

  Started by

  Posts

  Last post

• query to get the user that created the stored procedure

  hi community, is there a query that display the user that created the stored procedure? (ex. domain…

  Teemo

  7 replies

  14 years, 1 month ago

  By: Gail Shaw

• Query to delete items for every order

  Hi All, I am looking for a better way to write a query for the following scenario and this is for S…

  genius.ck

  6 replies

  14 years, 1 month ago

  By: genius.ck

• Pivot with possible multiple rows

  Hi all, I wondered if anyone might have an idea how to accomplice this scenario. I have schools wit…

  kangarolf

  5 replies

  14 years, 1 month ago

  By: kangarolf

• syntax for sp_dump_dtspackagelog

  Hi, I'm clearing up my old DTS package logs that were done in sql2000. I can see a stored procedur…

  dave hants

  3 replies

  14 years, 1 month ago

  By: Ulysses_Infinity

• Could not allocate ancillary table for view or function resolution.

  Hi all, I need to create a view that returns the last balance of all accounts as per period, for mu…

  ajv.consult

  2 replies

  14 years, 1 month ago

  By: mahmadk

• query to retrieve all status if a given status falls in a specific date range

  Hi, I have a table with item_id,status,datetime columns item_id status date 534 Evaluated…

  ssisnovice

  1 replies

  14 years, 1 month ago

  By: Lowell

• Merge Statement

  I have a question about merge insert/statements. Below is a simple code where I want to insert/mer…

  David Elliott-401886

  1 replies

  14 years, 1 month ago

  By: GSquared

• Binding Error

  Hey there! We have a simple bit of sql... [font="Courier New"]table 1 & 2 don't exist select *…

  Martin Bastable

  4 replies

  14 years, 1 month ago

  By: Martin Bastable

• Looking for a way to return a table with a row for every word contained in a column in another table

  I'm looking to rank words contained in a varchar column in a table. I would like to create an outp…

  Stephen Phayre

  5 replies

  14 years, 1 month ago

  By: Stephen Phayre

• Scalar Function returns only one char

  Hi all I have a simple function as below: ALTER FUNCTION [dbo].[TransactMonth] ( @PostingDate …

  meelan

  5 replies

  14 years, 1 month ago

  By: Jeff Moden

• Query Help - using 2 Column update 3rd column

  here is the Result column i updated like penspencils result 4 2 4pens / 2penc…

  John Paul-702936

  2 replies

  14 years, 1 month ago

  By: baabhu

• How to categorize patient encounters based on procedures done.

  Hi all, I have a table that holds patient encounters in it, and another table that holds all of the…

  ajenawsu

  2 replies

  14 years, 1 month ago

  By: ajenawsu

• Get the SUM of 2 Rows/Count Columns

  So I have this statement: SELECT ClassDefinition.symbolic_name, COUNT(DocVersion.object_class_i…

  gfedz

  2 replies

  14 years, 1 month ago

  By: Bill Anton

• Import CSV File to SQL 2000

  Dear master, I do not know why I can not import csv file into sql 2000 using DTS Import/Export Wiza…

  diboy79

  12 replies

  14 years, 1 month ago

  By: diboy79

• HELP-- Need to Create a Trigger when a database is updated to write to a history table the old and the new value along with the timestamp

  Hi All, In need of some help to create a trigger for a database when a record is changed in a table…

  mary.neslony

  7 replies

  14 years, 2 months ago

  By: mary.neslony