T-SQL (SS2K8)

• Topics

  Started by

  Posts

  Last post

• Build string from passed parameters

  Is there to easily build a comma delimited list from parameters that are passed. I know you can do…

  tshad

  3 replies

  14 years, 7 months ago

  By: tshad

• how to add intermediate columns in PIVOT tabe????

  hI ALL... I'm keep getting PIVOT table problems 🙂 HAving a PIVOT table(THE FINAL RESULT) AS BUDGET…

  kavinithi

  3 replies

  14 years, 7 months ago

  By: nithiyanandam-447806

• Is it RBRAR???

  Hi, My developer gave me a query as usual and told me that it runs for 3-4 hours sometimes and usua…

  chandan_jha18

  8 replies

  14 years, 7 months ago

  By: Lamprey13

• Regular Expression Replace using sql server function

  Hi All I have following Values. ABC EN 709+A1 ABC-EN 1/A1 ABC 104233/1M ABC-EN ISO 50065-4-7 CORR A…

  rohit.kumar.barik

  3 replies

  14 years, 7 months ago

  By: Lowell

• Need help with Cursor!!!

  Hi Everyone, I come across a problem and don't know what to do? I have 2 tables. TableA and TableB.…

  krishusavalia

  4 replies

  14 years, 7 months ago

  By: krishusavalia

• casting or converting a division

  i have a number that i want to cast into 2 decimal places so i dont loos the precision example sele…

  klineandking

  3 replies

  14 years, 7 months ago

  By: OzYbOi d(-_-)b

• Returning Wrong Decimal Places

  Hi - I have a VB Script where I write Longitude and Latitude to VARIABLES and then pass those Varia…

  aadler 19786

  5 replies

  14 years, 7 months ago

  By: aadler 19786

• script need for Index size belongs to HEAP, clustered, non clustered index

  Hi, I got script Mr.RBarryYoung from sqlserver central one of the threads, this is working with SQL…

  SQL Galaxy

  1 replies

  14 years, 7 months ago

  By: Gail Shaw

• Removed Null values by this output

  Hi, This script output display total No.of table, SP, PK and etc.. please suggestion me, how to rem…

  SQL Galaxy

  4 replies

  14 years, 7 months ago

  By: SQL Galaxy

• Fulltext Search syntax error

  Hi, we have enabled the fulltext search it working fine in sql server 2008 r2 enterprise editions …

  Saravanan_tvr

  3 replies

  14 years, 7 months ago

  By: Saravanan_tvr

• Return one row from multiple rows based on order of tests in where clause

  I have a table where I would like to get only one row from a table where multiple parameters are p…

  tshad

  11 replies

  14 years, 7 months ago

  By: LutzM

• how to get grand total row in pivot concept??? urgent plz...... Thank u all

  i want to have a summerized row at the end of my result. I used pivot concept in my procedure. How …

  kavinithi

  9 replies

  14 years, 7 months ago

  By: kavinithi

• Updating a column....

  Hey guys, Im trying to set a flag on table based off a query...But when I tried running the update …

  asm1212

  10 replies

  14 years, 7 months ago

  By: asm1212

• please advise on temp table solution to automate migration scripts

  I have given interim (clumsy) instructions for running a set of migration scripts, until I create a…

  KoldCoffee

  15 replies

  14 years, 7 months ago

  By: KoldCoffee

• T-SQL Newbie needs help

  Hey folks, I'm relatively new to writing complex SQL statements and have a business reporting chall…

  JohnnyMac_SQL

  9 replies

  14 years, 7 months ago

  By: Jeff Moden