T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Crosstab type report -- Horizontal Summray

  Hello All: I'm trying to build a stored procedure to present user data in a fashion that I have not…

  Joseph Henry

  20 replies

  17 years ago

  By: Jeff Moden

• Sorting the tables according to foreign key constraint.

  How to sort the tables in a database by foreign key constraint. So if one can have insert scripts f…

  Rahul Bhosale

  10 replies

  17 years ago

  By: Lowell

• server memory low during xml import in ms sql table xml size is near about 4 GB

  --I am using Sql Server 2005 . --I have one sp which simply takes xml document as a input and inser…

  mayank jarsaniya

  2 replies

  17 years ago

  By: mayank jarsaniya

• need help creating several excel or access files from a query

  Hi, I have a table with the next structure: customer_id, product, date_product,product_qty so I n…

  luisalfonso70

  1 replies

  17 years ago

  By: LutzM

• Import xml into sql server 2005

  Hello, I have goggled a couple different methods for importing using t-sql and found this one to su…

  cthorn112

  10 replies

  17 years ago

  By: Florian Reischl

• Need Help in aggregate query

  Hi, I am trying to find the efficient way of getting records from table which has around 5lakhs of …

  descentflower

  1 replies

  17 years ago

  By: LutzM

• detecting cycles in a hierarchy using t-sql

  I am tasked with identifying all the cycles (node relationships that have a circular reference, i.e…

  Jesse Reich

  1 replies

  17 years ago

  By: Florian Reischl

• Tunning Q - Use of SUbquery vs Derived Table

  I'm trying to determine why a query with an aggregated value (SUM()) would take 6- 8 times longer t…

  YSLGuru

  8 replies

  17 years ago

  By: YSLGuru

• getting serious aggitated on datename function working randomly!

  Greetings everyone 😀 So I had a query that was working. I have a calendar dimension that I am tryin…

  shannonjk

  5 replies

  17 years ago

  By: shannonjk

• Calculate Trigger Date

  I have been asked to create a Trigger to email suppliers 7 days prior to order due date (I assume a…

  2Tall

  4 replies

  17 years ago

  By: 2Tall

• t-sql question

  I am trying to calculate the following order counts based on the orderdate parameter: For example i…

  Mh-397891

  5 replies

  17 years ago

  By: Lynn Pettis

• I need to delete 400,000 records

  We have a SQL 2005 database and there are some old records that need to be deleted with the matteri…

  interflex

  5 replies

  17 years ago

  By: steve block

• Can not turn ENTITY_INSERT Table ON.

  Hi, I tried to execute in SQL Server 2005 Query Analyzer the following statement: SET IDENTITY_INSE…

  zubamark

  2 replies

  17 years ago

  By: zubamark

• diplay first word before a space

  hi, say I have a field [text] with the data 'Jamie's Car' how can I show just the word 'Jamie's' ?

  Jamie-136634

  7 replies

  17 years ago

  By: rja.carnegie

• Search with blank values passed to stored proc

  I have a simple search form in MS Access (ADP) that passes parameter values into a stored procedure…

  lenrigby

  2 replies

  17 years ago

  By: lenrigby