T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Concatenate into fixed length

  OK it is late and I am having trouble keeping my eyes open so please forgive this easy question tha…

  Bosco2

  5 replies

  14 years, 1 months ago

  By: jbrewer

• Convert Seconds for a given time

  Hi Folks, I have an requirement that, i need to convert all the times into seconds. Based on the be…

  sqlusers

  4 replies

  14 years, 1 months ago

  By: John Esraelo-498130

• need help to improve my stored procedure

  Hi, I've stored procedure as following, create proc assignprogram @studentId int, @programid int a…

  Qira

  7 replies

  14 years, 1 months ago

  By: Andre Guerreiro

• How to copy a table (with data) to another database?

  Is there any MySQL type similar script generation option in Management Studio through which CREATE …

  @RDBMS

  1 replies

  14 years, 1 months ago

  By: viiki.seth

• Disable print in a stored procedure - TSQL - Example: Print 'This is my result'

  I have a stored procedure that has several statements like print 'This is the result' These stateme…

  Robert Cearley

  6 replies

  14 years, 1 months ago

  By: mtassin

• Script to enable Auto-growth

  I need to generate a script to enable autogrowth on multiple databases on a SQL Server 2005 instanc…

  Tarsha Shannon

  12 replies

  14 years, 2 months ago

  By: Lynn Pettis

• Calculate First & Last Day of for 2 Months from current date & First & Last Day of the Weeks going back 4 Weeks

  I need to Calculate the First & Last Day of for 2 Months from current date & First &…

  Welsh Corgi

  11 replies

  14 years, 2 months ago

  By: Lynn Pettis

• concatenation of multiple rows

  hello community, guys I need help on this one, Here is the scenario CREATE TABLE #tmpdata ( nkey in…

  Teemo

  3 replies

  14 years, 2 months ago

  By: Teemo

• Advice on update

  Hi, How do you update a group of records with the following "features", By each group, update every…

  Lou

  4 replies

  14 years, 2 months ago

  By: drew.allen

• Subquery With Aggregates and Pivot

  I having issues with a simple query. I need to GROUP BY in the OUTER Query by Company Name, Account…

  Welsh Corgi

  5 replies

  14 years, 2 months ago

  By: Welsh Corgi

• SPLITTING CSV COLUMN TO MULTIPLE COLUMNS IN 1 ROW

  I HAVE A COLUMN THAT CONTAINS CSV DATA LIKE THIS: 428.0,414.8,414.00,426.11,426.3,401.9,250.00,496,…

  montgomery johnson

  13 replies

  14 years, 2 months ago

  By: Jeff Moden

• XML Query Help

  I have a piece of XML in a table that looks like this: Servername XMLField Server1 XMLData T…

  Kenneth.Fisher

  1 replies

  14 years, 2 months ago

  By: Eddie Wuerch

• Rounding issues

  I am having a random rounding issue and wondering if someone has dealt with this. I have two fields…

  Sandeep2

  2 replies

  14 years, 2 months ago

  By: Sandeep2

• index on big table

  I've got a big table with millions of records. It doesnt have any unique key and the uniqey key is …

  dva2007

  29 replies

  14 years, 2 months ago

  By: tfifield

• Need Charindex to Pick Up the Second Instance

  I have a sample of a table: --===== If the test table already exists, drop it IF OBJECT_ID('Te…

  ducksql@gmail.com

  11 replies

  14 years, 2 months ago

  By: Ninja's_RGR'us