T-SQL (SS2K5)

• Topics

  Started by

  Posts

  Last post

• How to rotate columns into rows

  Hi All, I have the below query which retuns one row of data, how can I get the data grouped on the …

  4EverandEver

  3 replies

  15 years, 10 months ago

  By: 4EverandEver

• XML Fragment Parse

  I have been assigned a task involving XML parsing and am stumped. Essentially, an XML fragment is …

  Jeff K

  2 replies

  15 years, 10 months ago

  By: Jeff K

• URGENT---Why I adding new user failed?

  Hi Folks, I need to add some logins in my database, I have no problem finding them in the Login -Ne…

  halifaxdal

  27 replies

  15 years, 10 months ago

  By: Lynn Pettis

• Create table dynamically using loop

  I create table 1 by 1 as follow, CREATE TABLE [dbo].[DERInfo_201001]( [trnxid] [int] IDENTITY(1,1)…

  miss.delinda

  8 replies

  15 years, 10 months ago

  By: miss.delinda

• recursive query

  hi folks, I need ur help to finding least node from the tree. consider the following snippet: --dro…

  Mohamed Asane

  8 replies

  15 years, 10 months ago

  By: kevin_nikolai

• How to enhance query performance

  I have done some searches and decided to just ask. I have read article after article about indexing…

  hughesj23

  3 replies

  15 years, 10 months ago

  By: WayneS

• Need Help with Query

  I need to select a distinct acct_nb from a table that could contain duplicate acct_nb's with differ…

  bigclick

  5 replies

  15 years, 10 months ago

  By: RP_DBA

• Stored Procedure Error Handling

  Hi, 1) I have created the following procedure and i would like to pass sid , mid , cid , iid row …

  hsac1301

  2 replies

  15 years, 10 months ago

  By: Jack Corbett

• While Loop for Inserts from Read-only Function

  Hey guys, From a performance, I've read on here plenty of times to avoid Cursors and While Loops, b…

  Nugby

  9 replies

  15 years, 10 months ago

  By: Nugby

• Sql 2005 query problem, thanks for your help

  I have a data table of following: Date Close 1/4/201010583.96 1/5/201010572.02 1/6/20101…

  SQL-Newbie

  11 replies

  15 years, 10 months ago

  By: SQL-Newbie

• sum two result sets

  Is there a keyword to sum these 2 resultsets by rim_no? select rim_no, sum(cur_bal) [cur_bal] …

  krypto69

  3 replies

  15 years, 10 months ago

  By: J-F Bergeron

• Need help on optimize the query

  Please help me write the below query in basic optimized way. Thanks in advance Query: ==== select b…

  moosamca

  18 replies

  15 years, 10 months ago

  By: Gail Shaw

• Replace non numeric characters in string

  Hi, I know the following code will replace single defined character (*) REPLACE(Phone, '*', '') but…

  DerbyNeal

  81 replies

  15 years, 10 months ago

  By: mr.kit.west

• automatically restore recent backups

  There are 3 days of full backups and TLog backups in backup and trn folders respectively. I need to…

  jsb12

  21 replies

  15 years, 10 months ago

  By: george sibbald

• How to calculate Average datetime in sql server

  DECLARE @date1 DATETIME,@date2 DATETIME,@date3 DATETIME; SET @date1=CONVERT(varchar,GETDATE()+1,108…

  malleswarareddy_m

  4 replies

  15 years, 10 months ago

  By: malleswarareddy_m