T-SQL

• Topics

  Started by

  Posts

  Last post

• SQL Query

  Scenario is like - I have a table for product with records - IDTimeStampsTeamStatus 12010-0…

  HakunaMatata

  1 replies

  15 years ago

  By: andrewd.smith

• Number sign prefix

  Hi Team, I am having problem on how to get the number sign of a numeric value. For exmaple I have -…

  simplefrog

  2 replies

  15 years ago

  By: simplefrog

• How to OPTIMIZE the following

  Hi I need your precious commements on the following issue. We need to display customer informat…

  Gautam.Roy

  1 replies

  15 years, 1 months ago

  By: Lowell

• Replace Row_Number() to make the query SQL2000 Compatible

  Select A.CLI_ID, CLI_SEQ, CL_ID, A.CLR_ID, UPPER(A.CL_Status) CL_Status, A.S_Code , A.START_DATE, …

  SQLHeap

  1 replies

  15 years, 1 months ago

  By: GSquared

• Multiple Counts in a Row

  I want to display three different counts in a single row. Any clues on the select statement. Must …

  ckmoied

  11 replies

  15 years, 1 months ago

  By: sravanb

• Explain a SELECT statement (Patindex) inside this Email function

  Hi All, Can anyone pls explain to me step-by-step what the little SELECT part of this function is d…

  askquestions

  2 replies

  15 years, 1 months ago

  By: askquestions

• Search Date-Month togetherly in a query; ignoring year.

  Hello Developers, I am having a query. I have 2 tables named as astrology & store_dob: Table:…

  mail2payan

  4 replies

  15 years, 1 months ago

  By: spaghettidba

• Compare 2 fields in the same table Using LIKE '%[fieldname]%'

  Hi guys, can you help pls. I have a "person" table with the following fields: title, forename, surn…

  askquestions

  8 replies

  15 years, 1 months ago

  By: askquestions

• t-sql find top 10 users in tabel

  hi guys, I'm new to this forum so I hope I'm posting in the right forum. question is: I have a tabl…

  xxx_olduser_9999

  1 replies

  15 years, 1 months ago

  By: qaz123 90964

• Locking issue in linked server

  hi Recently we faced a issue of locking happening to a linked oracle server table, when a sleect op…

  qaz123 90964

  1 replies

  15 years, 1 months ago

  By: qaz123 90964

• Select or copy data from an MSAccess db

  I don't know if I should place this question here or in the Access forum. There is a legacy Access …

  Ken at work

  6 replies

  15 years, 1 months ago

  By: Ken at work

• Join Query? How to

  I am using sql server 2000. Below is the scenario: I have 3 tables: select * from A1; gives: agenti…

  mpk_1980

  3 replies

  15 years, 1 months ago

  By: mpk_1980

• Export SQL Database to flat file with header(column) name

  hi, i have tried bcp, it can dump only table data from sql to txt file- i need column name too. Is …

  rbamania

  8 replies

  15 years, 1 months ago

  By: Jeff Moden

• changing dependent Stored procedures if table schema changes

  Hi Friends After a looong time.. I am back with another question. I have written about 25-30 stored…

  ShekharNaidu

  2 replies

  15 years, 1 months ago

  By: Lowell

• keywords in column names

  I've inherited an old and massive stored proc. Inside the sp, several ##temp tables are created usi…

  Uripedes Pants

  8 replies

  15 years, 1 months ago

  By: Uripedes Pants