T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Need Help on User Tree Hierarchy with Addition/Deletion Option

  Hello All, I have situation where if user pass the userid then their respective hierarchy displa…

  roh_ranjan

  14 replies

  13 years, 6 months ago

  By: Jason-299789

• Is there any best way to REPLACE the query?

  Hi there, I have a below query which needs to replace the label to actual value. I can do this by u…

  lokesha.b

  4 replies

  13 years, 6 months ago

  By: Dwain Camps

• TSQL Suggestion: Support GROUP_CONCAT

  Please vote: https://connect.microsoft.com/SQLServer/feedback/details/764820/support-group-concat-a…

  peterhe

  5 replies

  13 years, 6 months ago

  By: Orlando Colamatteo

• coversion error while inserting value in datatype=Int column

  Hi...I am getting this message Msg 245, Level 16, State 1, Line 7 Conversion failed when converting…

  komal145

  4 replies

  13 years, 6 months ago

  By: Sean Lange

• require database with table adn row count with space used.

  hi, i am using SET NOCOUNT ON /*DATABASE TABLE SPY SCRIPT Micheal Soelter 1/24/03 DESCRIPTION Retur…

  stillconfused

  1 replies

  13 years, 6 months ago

  By: Ben Teraberry

• Remote command and powershell

  Hi all I have a situation where I need to run a cmd line on a remote server and have the results of…

  Kwisatz78

  1 replies

  13 years, 6 months ago

  By: Scott D. Jacobson

• 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, 6 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, 6 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, 6 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, 6 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, 6 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, 6 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, 6 months ago

  By: Gail Shaw

• sys.tables.type

  Hi, What does sys.tables.type meant.

  Shadab Shah

  2 replies

  13 years, 6 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, 6 months ago

  By: Dwain Camps