T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• What is the difference?

  Hi Friends, I have a doubt regarding joining two tables, so i came here to get your s…

  Charmer

  4 replies

  13 years, 7 months ago

  By: Charmer

• CLR Funtion To split the cama separated string.

  Hi All, I need a CLR function to split the "," separated string. Ex: string like 1,2,3,4, Result: V…

  Tony1234

  6 replies

  13 years, 7 months ago

  By: Lynn Pettis

• Consolidating records - TSQL problem

  Good afternoon, I've been working on a project to eliminate duplicates from a record set containing…

  Abu Dina

  23 replies

  13 years, 7 months ago

  By: Luis Cazares

• FK referencing multiple tables

  Hi, Is it possible to have a column on table A that references table B or table C depending on anot…

  PiMané

  6 replies

  13 years, 7 months ago

  By: PiMané

• Tables most and least used in SQL Server

  Hi, I wanted to know this just to increased my information as i am a newbie. I found out this on in…

  Shadab Shah

  4 replies

  13 years, 7 months ago

  By: Grant Fritchey

• Restart runningtotal when predetermined value is reached

  Hi, Im trying to create a running total based on FieldToSum that will restart everytime runningTota…

  matak

  6 replies

  13 years, 7 months ago

  By: Mark Cowne

• user_seeks Vs user_scan

  Hi, I tried finding this (user_seeks Vs user_scan) out on internet but no proper explanation is pre…

  Shadab Shah

  3 replies

  13 years, 7 months ago

  By: Gail Shaw

• sys.tables.type

  Hi, What does sys.tables.type meant.

  Shadab Shah

  2 replies

  13 years, 7 months ago

  By: Shadab Shah

• How to transform this result?

  Hi SQL Gurus, I have this default master data table below: ITEM | CNT | DESCRIPTION ----------…

  yingchai

  2 replies

  13 years, 7 months ago

  By: Dwain Camps

• sum every two number combination

  Let's say your coworker gave you the results of a query, and noted he/she did not include SalesOrde…

  Amy.G

  16 replies

  13 years, 7 months ago

  By: Dwain Camps

• Trigger for or after Update

  Hi, I have a customer with webservice that creates users on his database. On the same database serv…

  PiMané

  4 replies

  13 years, 7 months ago

  By: Evil Kraig F

• detailed information of tables in all databses

  hi all, I am looking for a query which can give us detailed information of the database tables in a…

  stillconfused

  6 replies

  13 years, 7 months ago

  By: Lowell

• Performace Improvement in Table Valued Function

  Hi Guys, Could you Please help me to improve the function Performance.This Function is …

  gordon.davis

  4 replies

  13 years, 7 months ago

  By: Grant Fritchey

• Get one record on each category

  Hi. i have two table Projects and ProjectCategory. They are related with each other. Projects Table…

  cemelma.20

  6 replies

  13 years, 7 months ago

  By: SomewhereSomehow

• SQL query eliminating rows problem

  Hi all! I am trying to solve an issue and wondered if you could help, I'm relatively new to t-SQL a…

  Dominic_godfrey

  14 replies

  13 years, 7 months ago

  By: SomewhereSomehow