T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Isolation Level

  Hi, I have a scenario in which I am performing insertion on a table using a stored procedure. For e…

  kapil_kk

  50 replies

  13 years ago

  By: kapil_kk

• filtere index benefit

  i need to create a query on a table where the condition is such that we select the rows where the v…

  IT researcher

  3 replies

  13 years ago

  By: Gail Shaw

• Partition Results

  There is a heap like the one shown below: USE tempdb; CREATE TABLE Heap ( [Column 0] NVAR…

  UnionAll

  4 replies

  13 years ago

  By: UnionAll

• GROUP BY question

  Morning all, Could someone help me generate the following grouping please? Sample data plus expecte…

  Abu Dina

  8 replies

  13 years ago

  By: Abu Dina

• conversion of the varchar value overflowed an int column

  I have a stored procedure : In this prcedure I am returning @pSTN value and used in another sp as …

  kapil_kk

  12 replies

  13 years ago

  By: kapil_kk

• Syntax to call a function correct in one databse but not another? (both SQL 2008 R2)

  Hi All I have a function that works in one database but not another. Both databases are SQL2008 R…

  thepotplants

  3 replies

  13 years ago

  By: thepotplants

• How to Insert/Upadte data based on exist in mathcin table, in single query

  Hello All, please help me with this single select statement, StudentNew table is exist with below v…

  asita

  10 replies

  13 years ago

  By: asita

• Inner join returning all rows.

  I figured it out....Thank you, I would like to return all the data for a single empnum, but this qu…

  TryingToLearn

  6 replies

  13 years ago

  By: Sean Lange

• Indexed view CI chosen of table CI. Why?

  Hi, This is related to the table and query in question: http://www.sqlservercentral.com/Forums/Topi…

  Dennis Post

  7 replies

  13 years ago

  By: Dennis Post

• Unpivot Multiple Columns

  This is my first shot at an trying to unpivot multiple columns, and I'm not getting any results. I …

  sqlpadawan_1

  2 replies

  13 years ago

  By: sqlpadawan_1

• Understanding CASE processing

  Hi, I found an SP that generates multiple index seeks from 1 case statement. By the looks of it eac…

  Dennis Post

  6 replies

  13 years ago

  By: Dennis Post

• Tricky Merge Row Question

  Hi all SQL gurus... I need help in creating a query without any funtion to do merge owner's names f…

  drkusnadi

  1 replies

  13 years ago

  By: drkusnadi

• T-SQL help

  For the below SQL code, I need the output as: person dob Age Frank3/20/199023 Years Jo…

  etirem

  13 replies

  13 years ago

  By: Steven Willis

• Transforming an Interative Solution into a Set-Based Solution

  The problem here is that the grpID field is sometimes loaded with multiple values for a single elem…

  ehondzin 99718

  3 replies

  13 years ago

  By: mickyT

• How to sum in SQL removing varchar

  Hi All, I am trying to sum of amount (data type varchar) column but I am getting error error conve…

  niladri.primalink

  21 replies

  13 years ago

  By: Sergiy