T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• How to return a certain percentage of rows (NOT TOP PERCENT QUESTION)

  I want to return all values that represent x% of the total values within a table. Here's some test …

  David-155102

  7 replies

  13 years ago

  By: Sean Pearce

• Email attachment script ?

  I have a sql table that contains 100 email addresses & a word document that needs to be sent t…

  jude-32296

  6 replies

  13 years ago

  By: jude-32296

• Missing Number Find out

  Hi I am doing University Project.In my scenario I have two tables.One table name called studentm…

  vs.satheesh

  6 replies

  13 years ago

  By: Cadavre

• Order by clause in openrowset

  hi INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=c:\test\…

  vsjayashri

  2 replies

  13 years ago

  By: ProgramAndPM

• restart counter when number changes

  Hello all, a quick question i am working on a SQL script which a colleague of mine has half complet…

  jbon007

  4 replies

  13 years ago

  By: Cadavre

• Copy Dynamic List of Tables to Another Server

  I have a need to copy all tables created in the last 60 days from ServerA.DatabaseA to ServerB.Data…

  homebrew01

  3 replies

  13 years ago

  By: homebrew01

• trying to loop through all database on server to get a count of tables and stored procedures on each database

  trying the following cursor but the insert statement remains in the current db and does not switch.…

  gchappell

  3 replies

  13 years ago

  By: Michael Valentine Jones

• CASE WHEN Statement when creating a VIEW

  Hi Guys, I am having a few issues with some code and wanted some guidance ; I am creating a view ba…

  SteveEClarke

  4 replies

  13 years ago

  By: SteveEClarke

• Inline Query Too Large For Varchar(MAX)

  My SQL Server 2005 inline query is over 8K in length. The variable I'm using to store the query te…

  fstop

  1 replies

  13 years ago

  By: fstop

• Full Text Search query and noise words

  Hi coders (and administrators 😀 ), I am working on query with CONTAINSTABLE. Everything works well …

  Boris Pazin

  3 replies

  13 years ago

  By: Steven Willis

• Identify objects in all the databases which are using specific column as the filter (where condition)

  Hello All, I have 3 databases ABC, DEF, GHI. I need to identify all the database objects (Stored Pr…

  SQL Prog

  13 replies

  13 years ago

  By: Eugene Elutin

• Find Price Changes in Item History Table

  Ok, here's an easy one for some of you. I want to read through a group of items and determine the m…

  homebrew01

  8 replies

  13 years ago

  By: homebrew01

• Creating a Household "Pecking Order"

  Hi all, I have a requirement to place family groups into a "pecking order". This involves: Identify…

  irobertson

  1 replies

  13 years ago

  By: Chris Harshman

• datediff with unix timestamp

  I have a table with date in unix timestamp and iam using the following query to get the dates which…

  sahmad43

  6 replies

  13 years ago

  By: Lynn Pettis

• How to know which column updated

  Hi, I have one Customer Table which contains more than 25 columns. When user Updated any column in …

  suresh0534

  3 replies

  13 years ago

  By: Jeff Moden