Lowell (10/16/2010)

---

a single record? no...the TRUNCATE TABLE [TABLENAME] command will delete all records in a table. so that deletes...

BTW, why did you started a new thread on the answer I gave you?

scottichrosaviakosmos (10/15/2010)

---

yes, this is what i want, but what i wanted is to the column A and B the values in @tblmonth be added.

i.e row of a like 10+20+40.. to...

Do you mean something like this?

declare @tblmonth table(stdid int, code char(1), jan int, feb int, march int, april int, may int)

declare @tbldate table(stdid int, sdate date, eddate date)

insert into @tblmonth

values...

Because of being busy writing those great optimizer articles?

Like Steve already pointed out,...

The top input of the inner join contains an index seek on Topic.t_id =...

steve-893342 (9/13/2010)

---

WayneS (9/13/2010)

---

Test code:

SET NOCOUNT ON;

print replicate('*',30);

Print 'Jeff''s function';

print replicate('*',30);

SET STATISTICS IO,TIME ON;

select

count(*)

from

CsvTest

cross apply

dbo.Split8KX(CsvParameter, ',');

SET STATISTICS IO,TIME OFF;

print replicate('*',30);

print 'Inline table valued function';

print replicate('*',30);

SET...

I am not an XML Ninja either, but you can try a inline table valued function

CREATE FUNCTION dbo.Split8KX_Inline(@Parameter VARCHAR(MAX), @Delimiter VARCHAR(1))

RETURNS TABLE

WITH SCHEMABINDING

AS

RETURN

SELECT...

Lowell (8/26/2010)

---

ok, I just realized that the shortcut command you needed was for {slash L}, not {slash R]

ROWTERMINATOR =

vbCrLf = CHAR(13) + CHAR(10) = \n

vbCr = CHAR(13) = \r

vbLf...

Oops, posted twice.

BravehearT1326 (8/26/2010)

---

BULK INSERT TEST.dbo.NA_BANKACCTTYPELOOKUP

FROM 'C:\TEST\test.txt'

WITH

(

FIELDTERMINATOR ='|',

...

Is this what you want?

;with OrderedProbability as

(

select

ConstructNo, ImportanceBands, Probability,

row_number() over (partition by ConstructNo order by Probability desc, ImportanceBands desc)...

deepthik (8/12/2010)

---

Hi...

Am using the below function as you mentioned. At that time, there is no data, so i habve tested on test data and is working fine.

now, my report is...

You are using the wrong expression for the format. Given a date of 2/3/2009, your expression

=Format (<datetime field from dataset>, "dd-MMM-yyyy").

evaluates to "3-Feb-2009" which is then used to format...