hi pankaj ,

i dont think we have any option by which we can calculate SELECT coomand but this can be done in front end by putting counter on...

Nopes...Buddy it wont gives different result if spaces added at the ends

try this

select len('99202 10060 99000 A6402'),len('99202 10060 99000 A6402 ')

INSERT INTO OPENROWSET ('MICROSOFT.JET.OLEDB.4.0', 'Excel 8.0; Database=D:\RFPSent\SENT_RFPs.xls;HDR=NO;IMEX=2', 'select * from [Venue_RFPs$]'

) SELECT * from tblvenue_RFP

------------------------------------------

In above text [Venue_RFPs$] is a worsheet which...

What kind of FORMATTING oyu are talking about ....is it like width of excel's column ??

can any body tell me advantages of system catalog views over system tables ???

create table tbl12 (

date datetime primary key)

insert into tbl12

select '2008-09-19'

union

select '2008-09-19'

see the script aboce..it has same story as ur Stored proc

actaully as u said u are inserting same date...

hi thanks for ur advice but this is not actually login and password ......i know its crime 🙂

prob SOLVED !!!!!!!!!!thanks for all

select * from sys.configurations where configuration_id = 116

--------------------------

its maximum col should be 1 to AVOID recursion

----i guess it will help you 🙂

Thanks GILA...i got the point ....

hi,

if you see table creation syntax ,i m using A varchar(40) instead of A varchar

below queries resluts same but WHY????

CREATE

TABLE #TEST(A varchar(40),B varchar(30));

INSERT

INTO #TEST(A) VALUES('A');

INSERT

INTO #TEST(B)...

--Step 1

Declare @Str VarChar(max);

Set @Str=Replicate(cast('*'as varchar(MAX)) ,10000)

Print Len(@Str);

--Step 2

Declare @Str VarChar(max);

Set @Str=Replicate('*' ,10000)

Print Len(@Str);

----

i m hardly got the difference between step 1 and step 2 ..please...

CREATE TABLE #TEST(A varchar,B varchar(30));

INSERT INTO #TEST(A) VALUES('A');

INSERT INTO #TEST(B) VALUES('Some text');

INSERT INTO #TEST(A) VALUES('B');

INSERT INTO #TEST(B) VALUES('Some more text');

SELECT COUNT(*)FROM #TEST GROUP BY LEN(ISNULL(B,A));

go

SELECT COUNT(*) from #TEST GROUP BY...

CREATE TABLE #TEST(A varchar,B varchar(30));

INSERT INTO #TEST(A) VALUES('A');

INSERT INTO #TEST(B) VALUES('Some text');

INSERT INTO #TEST(A) VALUES('B');

INSERT INTO #TEST(B) VALUES('Some more text');

SELECT COUNT(*)FROM #TEST GROUP BY LEN(ISNULL(B,A));

go

SELECT COUNT(*) from #TEST GROUP BY...

can you provide SAMPLE data and error occurred ???