T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• How do I combine a column from multiple rows into a string or new column?

  COLUMNA COLUMNB 123 JSOSJD 433 SDFOJE 123 DOD…

  SQLConfused

  5 replies

  14 years, 9 months ago

  By: Jeff Moden

• PIVOT result column format

  The following query works, but I need the result column Amt to be formatted with commas every three…

  deluxSQL

  8 replies

  14 years, 9 months ago

  By: Jeff Moden

• Need help with cte or self Join

  I have a table, TableA Id Rows 1 10 2 30 3 10 Now I need two more column …

  krishusavalia

  5 replies

  14 years, 9 months ago

  By: Jeff Moden

• Cursors and concurrency

  Hi guys, I have a stored procedure which contains a cursor to loop through a queue (The queue is ju…

  elogen

  9 replies

  14 years, 9 months ago

  By: R.P.Rozema

• Is there a way to do a group by on all fields with a having clause?

  I'm trying to find duplicate records, so basically I wanted to do a select distinct * from myTable …

  Sean Grebey-262535

  3 replies

  14 years, 9 months ago

  By: spaghettidba

• Creating join in a fuction

  Hi, I have two tables with below structure: Table A: ID, FName, Age, City, Date Table B: id, Lname,…

  dsrapid

  8 replies

  14 years, 9 months ago

  By: ChrisM@Work

• Index view

  Hi please help me, Is index view is save into the database. Thanks Prithvi

  pnpsql

  2 replies

  14 years, 9 months ago

  By: Gail Shaw

• dynamic query

  hi can anyone tell me how i should do it. normal way of opening the database is use database_name s…

  kumarramachandrarao

  1 replies

  14 years, 9 months ago

  By: spaghettidba

• Calculate component percents without a cursor

  I have a challenge that I have not been able to solve (without using a cursor). I have products th…

  gcresse

  14 replies

  14 years, 10 months ago

  By: ChrisM@Work

• joining 3 tables not getting valid resultset

  hi all, I need to join 4 tables 3 are in one database and the other table is in other database, Tab…

  User7766

  13 replies

  14 years, 10 months ago

  By: NotoriousDBA

• Creating View

  Hi, I have a table with below structure: COLA B C D E int int int datetime varchar I want to …

  dsrapid

  6 replies

  14 years, 10 months ago

  By: NotoriousDBA

• How to retrieve the max character on a text field?

  Many thanks in advance?

  SQL ORACLE

  5 replies

  14 years, 10 months ago

  By: Sean Lange

• Query doing most IO and longest elapsed time

  Hi, ----–Queries taking longest elapsed time: SELECT TOP 50 qs.total_elapsed_time / qs.execution_co…

  SQL Galaxy

  6 replies

  14 years, 10 months ago

  By: Grant Fritchey

• TSQL "Meta compiler" or precompiler?

  Does anyone know of a tool that can do more structural and syntactic checking on T-SQL code than Ct…

  corey lawson

  2 replies

  14 years, 10 months ago

  By: winash

• unique problem with t-sql

  hello, i have a data to be processed in t-sql. The data looks like below: ordernumber session_time …

  nairdeepa

  43 replies

  14 years, 10 months ago

  By: nairdeepa