T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• Database Space Usage Tips

  Hi all, Another general question. The database server which I am currently administering, is runnin…

  kramaswamy

  2 replies

  14 years, 5 months ago

  By: kramaswamy

• snapshort replication subcription failed

  error message : Retrying the bulk-copy operation into the table " " without load ordering hint beca…

  athiyamaan

  1 replies

  14 years, 5 months ago

  By: AlexSQLForums

• Best way to separate "stacked" records

  I have been handed the task of parsing (might be better to say "unstacking") records produced by a …

  WDT3

  31 replies

  14 years, 5 months ago

  By: WDT3

• Applying Precedence Rule

  Hi All, I have one requirement. create table #t1 ( assetid int, type varchar(50), dt datetime, ret …

  karthik M

  7 replies

  14 years, 5 months ago

  By: karthik M

• Select element value as column from Nested XML namespaces

  HI i want to select item "coke" as a column. (xQuery, xPath etc....) I have tried this and its fine…

  iBar

  7 replies

  14 years, 5 months ago

  By: Mark Cowne

• Combining Multiple Records Into One

  I have an order table with an order number column and a country column. Some orders have multiple c…

  ducksql@gmail.com

  13 replies

  14 years, 5 months ago

  By: Jeff Moden

• Custom Grouping Related Records

  I have a table data as: Rec1 Rec2 ----- ----- 1 2 2 3 4 3 5 6 I wa…

  rka

  2 replies

  14 years, 5 months ago

  By: rka

• Help SQL Query

  Guys, I am not developer, just a pure DBA guy needing help with SQL-Fu. There is a table keeping t…

  htt

  3 replies

  14 years, 5 months ago

  By: SQLRNNR

• DISABLE - TRUNCATE - REBUILD vs DROP - TRUNCATE - CREATE for Indexes

  Hi all - Quick question. I have a table with ~60 million rows. The table contains 11 columns, of wh…

  kramaswamy

  1 replies

  14 years, 5 months ago

  By: Gail Shaw

• Get the records in comma separator

  Hi, DECLARE @TABLE TABLE (fldName1 VARCHAR(8), fldName2 VARCHAR(8)) INSERT INTO @TABLE SELECT 'Test…

  sqlusers

  4 replies

  14 years, 5 months ago

  By: kramaswamy

• Row to column - Help Please

  Please help. I need to create a column to place the only changing cell in a group of rows into colu…

  a_egbunike

  11 replies

  14 years, 5 months ago

  By: a_egbunike

• Syntax ponderable (variations on the SET vs SELECT theme...)

  The code in question: DECLARE @thevar INT SELECT @thevar = TheID FROM TheTable WHERE TheType…

  Pam Brisjar

  5 replies

  14 years, 5 months ago

  By: kramaswamy

• How to find count of employee's/count of names of employee's as per first character

  Hi all, Suppose, I have employee table in which i have Employee Name stored in one column. I want t…

  roshan.zanwar

  8 replies

  14 years, 5 months ago

  By: kramaswamy

• Inventory Stock Report Stored Procedure - Urgent Help

  Hi All, I need to take inventory stock report. I have 3 tables and provide all the scripts…

  francissvk

  5 replies

  14 years, 5 months ago

  By: TheSQLGuru

• parallel execution of a stored proc?

  Hello All, I've got a stored proc (all 12500 lines of it!) that takes 7 minutes to run. I need to r…

  BenWard

  9 replies

  14 years, 5 months ago

  By: TheSQLGuru