T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Selecting against multiple-table "has a" relationships

  Let's say I have three tables with the following table names and columns: Opportunity opportunityID…

  hamsterofdoom

  3 replies

  17 years, 10 months ago

  By: hamsterofdoom

• update value from the max date value

  I have interesting scenario and would like to get some help on how to approach this problem. I have…

  sqlstar2011

  7 replies

  17 years, 10 months ago

  By: Lynn Pettis

• Need help with scripting an aging date ("older than XXX days")

  Hi all, I'm writing a script that is going to look for old invoices. I've got everything working th…

  bjohnson-533065

  3 replies

  17 years, 10 months ago

  By: bjohnson-533065

• Synonym help needed

  Hmm. BOL isn't being too clear on this, so I'm going to post. I know you can create synonyms for L…

  Brandie Tarvin

  7 replies

  17 years, 10 months ago

  By: Brandie Tarvin

• Sql Server Locking Hints

  Hi Friends, Is it recommended to follow the locking hints in the Sql query or not? If the database …

  IN_Sandeep

  3 replies

  17 years, 10 months ago

  By: Gail Shaw

• How to return multiple recordsusing Stored Procedure?

  Hi how to return multiple records from sql server without using WHERE clause. In Oracle using CURSO…

  sharma-691993

  8 replies

  17 years, 10 months ago

  By: sharma-691993

• Eliminate NULL Values from the result set

  Issue: ------ I am working on a health care system and currently facing problem with NULL values be…

  Sreemati

  7 replies

  17 years, 10 months ago

  By: Sreemati

• help with update statement

  hi guys, I hope you can help me. I have a list of items and prices from an excel spreadsheet. Using…

  DBA-640728

  10 replies

  17 years, 10 months ago

  By: DBA-640728

• Problems caused in computation of values due to Float and Decimal datatype

  Hi, I am facing problems in computing the results which include sequence of arthmertic operations l…

  krishna-kanth

  3 replies

  17 years, 10 months ago

  By: Piotr.Rodak

• Execute 2 stored procedures from within a stored procedure

  I have a stored procedure that will fire 2 other stored procedures. When I run the 2 stored proced…

  ed.nettestad

  7 replies

  17 years, 10 months ago

  By: Grant Fritchey

• Column to Row

  Is it possible to convert a number of columns to rows? I have a table which lists the months of the…

  David-155102

  7 replies

  17 years, 10 months ago

  By: Piotr.Rodak

• How to use alias name ?

  hi, My query is working fine but I just want to know how to change the result like eg,5,4,6 GB i wa…

  jagpalsingh4

  7 replies

  17 years, 10 months ago

  By: shamshudheen

• select with pair of values

  I’m trying to optimize existing C++ application running on SQL 2000 ready for migration to 2005. I…

  mjschwenger

  5 replies

  17 years, 10 months ago

  By: RyanRandall

• can PIVOT command transpose rows into columns

  Hi, I just need to flip row data into column data but the number of columns is not predetermined. …

  Karthika Raman

  9 replies

  17 years, 10 months ago

  By: nagarajanmm-699934

• Problem with transaction inside loop

  Hi, When i execute the following set of statements only 8 is getting inserted into table instead 6 …

  presidencyprakash

  6 replies

  17 years, 10 months ago

  By: rcavill