Topics
Started by
Posts
Last post
hi folks, I need ur help to finding least node from the tree. consider the following snippet: --dro…
8 replies
I have done some searches and decided to just ask. I have read article after article about indexing…
3 replies
I need to select a distinct acct_nb from a table that could contain duplicate acct_nb's with differ…
5 replies
Hi, 1) I have created the following procedure and i would like to pass sid , mid , cid , iid row …
2 replies
Hey guys, From a performance, I've read on here plenty of times to avoid Cursors and While Loops, b…
9 replies
I have a data table of following: Date Close 1/4/201010583.96 1/5/201010572.02 1/6/20101…
11 replies
Is there a keyword to sum these 2 resultsets by rim_no? select rim_no, sum(cur_bal) [cur_bal] …
3 replies
Please help me write the below query in basic optimized way. Thanks in advance Query: ==== select b…
18 replies
Hi, I know the following code will replace single defined character (*) REPLACE(Phone, '*', '') but…
81 replies
There are 3 days of full backups and TLog backups in backup and trn folders respectively. I need to…
21 replies
DECLARE @date1 DATETIME,@date2 DATETIME,@date3 DATETIME; SET @date1=CONVERT(varchar,GETDATE()+1,108…
4 replies
Hi All I have a seemingly simple TSQL problem which is proving more challenging than I anticipated.…
2 replies
Hello Folks, I want to create a dynamic crosstab query. I have attached an Excel file that consists…
14 replies
I'm sure there's something simple for this, but I have 2 tables one has a column with text, a colon…
6 replies
Hi Look at these SELECT statements. 1. SELECT CAST(1.67574 AS DECIMAL(38,10)) A, CAST(10000 AS DECI…
4 replies
Viewing 15 topics - 4,201 through 4,215 (of 12,230 total)
You must be logged in to create new topics.