T-SQL

• Topics

  Started by

  Posts

  Last post

• row number in sql server 2000

  hi friends i am using following row number function in my sql server 2005 : select appno,row_numbe…

  amol_j_kothawade

  6 replies

  15 years, 5 months ago

  By: Ayan Bose

• Query with 2 Joins and Structure Changes

  Hello all! I've been racking my brain for the past couple of days trying to figure this out. I'm no…

  Alan_A

  3 replies

  15 years, 5 months ago

  By: WayneS

• SQL query that needs to join comma seperated values to another table

  I need to run a query on a sql 2000 server the query needs to join two tables The first table has I…

  jjf410

  4 replies

  15 years, 5 months ago

  By: jjf410

• Issue in using OPENROWSET

  Hi, I am trying to upload set of data from Excel to database in sql 2000. I am using below query SE…

  Veera Karthi

  3 replies

  15 years, 5 months ago

  By: Bob Griffin

• Help - Query for Max concurrent users from a login and logout table

  Hi Everyone, I have a table that contains the login and logout time and here are the following colu…

  dcw8888

  1 replies

  15 years, 5 months ago

  By: Ben Teraberry

• Compute addition of datetime fields

  Hi, I have 2 fields - ScanTime and DataTime. Now I want manipulate the these 2 fields to get Averag…

  Sanchit297

  3 replies

  15 years, 5 months ago

  By: Sanchit297

• Stuck with CAST operator Error

  Hi, I am trying to insert into a temp table using Dynamic SQL and need to use CAST operator for dis…

  Sanchit297

  3 replies

  15 years, 5 months ago

  By: Cadavre

• Interesting problem for the "Running Total/Quirky Update" method of removing cursors

  This is an extension to another topic I had posted but I decided to split it off as the problem is …

  Robb Melancon

  13 replies

  15 years, 5 months ago

  By: ChrisM@Work

• Cursor performance

  Hi. I've heard and read so much negative press about cursor performance and that we should never us…

  teck-1054678

  4 replies

  15 years, 5 months ago

  By: Jeff Moden

• Modifying a Column To Computed Column

  Hello Friends, I have a situation i want to modify existing column to a Computed Column using Some …

  Kamal Gautam

  1 replies

  15 years, 5 months ago

  By: Lowell

• Question about Update() function in triggers

  I have a very strange issue with the update() function. I have spent quite a while searching thro…

  jobeth

  9 replies

  15 years, 5 months ago

  By: jobeth

• Send_db_mail html issue

  Hi, This might look like a simple problem. But i am new to html. Below is the script i use to send …

  Dpac

  1 replies

  15 years, 6 months ago

  By: Jeffery Williams

• Multiple columns at GROUP BY clause in CASE clause

  Dear All, Please help me, I want to know that can I use multiple columns for GROUP BY clause after …

  naunton

  2 replies

  15 years, 6 months ago

  By: naunton

• date fuction

  I need to be able to multiply number of months by a start date, Is there a way to accomplish this t…

  Ittech03

  1 replies

  15 years, 6 months ago

  By: Lowell

• if statement

  Afternoon, Trying to use an if statement to return a date plus 3 months If I take out the th if sta…

  Ittech03

  3 replies

  15 years, 6 months ago

  By: Sergiy