T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Which query is scanning that index?

  Hi, I found an article on this matter: http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/200…

  Roust_m

  2 replies

  17 years ago

  By: Ken Simmons

• how can i use declare text in sql store procedure

  Hi , I am using a store procedure where i am creating a query dynamic , but query size is increasi…

  solutionsdxb

  4 replies

  17 years ago

  By: Grant Fritchey

• How to get Table's field name as rows

  Hi all, I have a table like T1 ================== Name Address …

  nitinkumar_tss

  4 replies

  17 years ago

  By: Grant Fritchey

• Execute Multiple Exec Command in a string

  Hi all, I have a store procedure that generates this dynamic output Execute generate_email '1'; E…

  jj011185

  2 replies

  17 years ago

  By: arun.sas

• Transaction Log grows to much / Recovery Model Simple

  Hi, I'm running several SELECT .. INTO Statements, one after another, without an explicit transacti…

  Tobias Kiemes

  21 replies

  17 years ago

  By: Tobias Kiemes

• WANTED: UDF for Least Squares estimate

  I have an application with known X and Y points, I'd like to run a function that would calculate m …

  bschieber

  5 replies

  17 years ago

  By: RBarryYoung

• updating xml schema collections

  I am not sure how to update existing data in an xml field when we add elements and remove them. fo…

  JKSQL

  1 replies

  17 years ago

  By: LutzM

• Re: View definition changes and sp_refreshview

  When should I use sp_refreshview? Here are two scenarios: 1. In the following example, should I ca…

  jlp3630

  3 replies

  17 years ago

  By: JKSQL

• Updating Duplicate data in a table to Make it Unique

  I have a table with 6120 records 2275 records = Unique LicenseNumber 1941 records = duplicate x2 1…

  schwizla

  4 replies

  17 years ago

  By: schwizla

• Week Commencing Count

  Hi Guys I have a table containing order information. An example is shown below (trimmed down versio…

  rcr69er

  7 replies

  17 years ago

  By: Paul White

• Percentages performance

  Anyone know a more efficient way of doing this. Obviously my code scans the table three times. I im…

  Jules Bonnot

  1 replies

  17 years ago

  By: GSquared

• Help with xml to text

  I want to convert values from a xml column into a text column. Example: UPDATE tblTest set textData…

  baumgaertner

  2 replies

  17 years ago

  By: baumgaertner

• Help with varchar to date(urgent)

  i have a column which holds the date in string format and is as given below yyyymmddhhmm is there a…

  lijusmail

  8 replies

  17 years ago

  By: Johan Bijnens

• display selected pivot data

  hi, I have data like Select personid, company from persons 123 bbc 123 google 123 microsoft 1…

  Jamie-136634

  2 replies

  17 years ago

  By: Jamie-136634

• delete then dropTruncate then drop/just drop

  I have a table with millions of rows. It was used to store audit data but is no longer used. It liv…

  Jules Bonnot

  4 replies

  17 years ago

  By: Jules Bonnot