T-SQL

• Topics

  Started by

  Posts

  Last post

• tempdb 35 GB using by query statement- Help

  Hi, In SQL server 2000 with SP5, Totally 10 Lacks record need to be retrieve by using this Query. b…

  SQL Galaxy

  14 replies

  13 years, 12 months ago

  By: Jeff Moden

• UK Postcode Sector

  Hello, I am trying to retrieve the first part and the first letter on the second part of a UK postc…

  Damion

  3 replies

  14 years ago

  By: Damion

• Parsing XML Data to return a specific node

  To all, I have not worked with XML much at all so in this area I am a rookie. Version SQL 2000, se…

  GF

  1 replies

  14 years ago

  By: Hunterwood

• Return a Table from a Stored Procedure

  I am an application programmer using VB6 with SQL Server 2000 as a backend and Crystal Reports 8 as…

  goodguy

  18 replies

  14 years ago

  By: John Esraelo-498130

• Isthere any function in T-SQL to get day of week using?

  I've found that there is a function called "trftime" in Sqlite. However, I cannot find any function…

  kpao

  9 replies

  14 years ago

  By: Jeff Moden

• Convert positive number to a negative

  Hi All, How can you convert a positive number into a negative. I have tried *-1 but this doesn't se…

  aaa121

  19 replies

  14 years ago

  By: Mark Weaver

• T-SQL command to determine the "SET" values

  Is there a command one can execute in TSQL that will list all values for SET xxx? Example: value o…

  Tom Carnahan

  5 replies

  14 years ago

  By: Tom Carnahan

• Run same SQL or Stored Proc for multiple databases

  Hi, I have a series of SQL that are the same that need to run on multiple databases SELECT COUNT(*…

  Joe Contreras-290946

  9 replies

  14 years ago

  By: Joe Contreras-290946

• Display first record from duplicate records in a column in sql query

  Hi, I would like some help creating a T-sql statement that can produce the following results: selec…

  zionman4

  7 replies

  14 years ago

  By: Sergiy

• Get data one by one and split using cursor or while loop

  Hi to all, can anyone help me regarding my problem. here is it... table name: table1 id prodname …

  spungus

  5 replies

  14 years ago

  By: spungus

• Convert rows into columns

  Hi, I have the following table structure ID   Jan   Feb   March …

  isaac briseño

  6 replies

  14 years, 1 month ago

  By: deepak.khopade

• Triggers Problem

  Hi, I have created the Trigger for insertion, Deletion, and Updation in table, this triggers chang…

  yromero

  3 replies

  14 years, 1 month ago

  By: Sean Lange

• Name concatenations

  I have been unable to arrive at a working solution to this, and my hunch is there is not enough inf…

  David Lester

  8 replies

  14 years, 1 month ago

  By: Cadavre

• Sum rows of data from various tables in single column

  The following is probably a simple question for most of you but I'm learning by trial and error. I…

  Linked999

  5 replies

  14 years, 1 month ago

  By: Linked999

• Field names with hyphens

  Hello, We have a developer who is trying to run the following script: UPDATE DB59.OBCBusinessF…

  Andrew Clark-151434

  4 replies

  14 years, 1 month ago

  By: Andrew Clark-151434