T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• How to know who made the changes in Table structure

  Hi, I want to know who (which user/login) has made the changes in table structure. e.g. some new co…

  AJ07

  4 replies

  15 years ago

  By: David Benoit

• update related data

  i have 2 tables with one having some data with first table having id as primary key and auto increm…

  scottichrosaviakosmos

  2 replies

  15 years ago

  By: scottichrosaviakosmos

• inner join vs correlated query

  Hi All, I want to fetch records from 4 tables. Fetching a single field from first 3 tables and more…

  Raghavendra-499237

  4 replies

  15 years ago

  By: Johan Bijnens

• can't execute sp_addextendedproperty

  hi, I have an SQL script that executes sp_addextendedproperty but i get this error: Object is inval…

  quasar_phoenicis

  5 replies

  15 years ago

  By: quasar_phoenicis

• Need help on SQL Server Service Broker ("SSB")

  Hi, I can communicate between two different database instances on the same Server using SQL Server…

  Little Nick

  12 replies

  15 years ago

  By: Little Nick

• Get Monthly total in sp

  I want to select all columns and get monthly total in my table. how am i do this... plz help me...

  ruwanwickrama

  4 replies

  15 years ago

  By: Lynn Pettis

• Update Records Based on Two Concatenated PK Columns

  I have a query tuning question. I have a table with some 1.7 mil records and the 2 columns (SalesOr…

  Ken Sturgeon

  10 replies

  15 years ago

  By: Arjun Sivadasan

• Construct an EXECUTE string

  I have an Access application that I use with SQL Server. I have some functions that build a string …

  OceanDiscovery

  15 replies

  15 years ago

  By: Jeff Moden

• SQL Query to find the nearest date for Currency ExchangeRate

  Hi I have a transaction table (Invoices) and a CurrencyTable. In Currency table Currency Exchnage…

  saurabh.deshpande

  1 replies

  15 years ago

  By: Nevyn

• date comparison issue with < and <= operator

  i have 5 records in an table. one of the colum is datetime type. while input date compares with exi…

  jamesmario

  1 replies

  15 years ago

  By: WayneS

• sp_helpuser

  I have been asked to give a listing of all users in a DB that have 'administrative access' I'm assu…

  krypto69

  6 replies

  15 years ago

  By: VSSGeorge

• Rolling Up Data

  I need to rollup data that looks like this: personnofromdatetodateacctstatcdmcatcd …

  Jack Corbett

  6 replies

  15 years ago

  By: Jack Corbett

• where 1 or more is true

  I have a table that has value1, newvalue1, value2, newvalue2, value3, newvalue3. There is an initi…

  jude-32296

  4 replies

  15 years ago

  By: jude-32296

• Holidays

  I need an efficient way to make sure that a date range does not overlap into a holiday. So, I have …

  BSavoie

  3 replies

  15 years ago

  By: WayneS

• Resultset Size

  I have t-sql query, in which I do some transactions and return a result set. After I execute the q…

  Madhusudana Rao

  6 replies

  15 years ago

  By: Resender