A bit of google search gives the below ..

SP2 includes hotfixes of SQL Server 2008 SP1 Cumulative Update 1 to 8 only. Cumulative update package 1 for SQL Server 2008...

Thanks Lynn,

I want to avoid such a scenario. I have a fix in CU4 (after SP1). So should I apply SP1 + CU1 to CU4 OR should I install SP2...

Perry,

I get the same error.

Query-1:

select top 1* from TABLENAME where

isdate(DATEFIELD) = 1

and convert(datetime,DATEFIELD) < getdate()-120

and VARCHARFIELD in ('111111','222222')

Above query works fine. But when i include another value in...

Thanks Lutz,

I will try to post the data maybe with some dummy values. I will get back to you after readying the dummy data.

For one set of load (which is monthly), I give a unique number say 1, for next load it wud be 2 and so on.. and i need to retrieve...

No Lutz, its still not resolved.

Sometimes ordering becomes,

A1 datetime1

B1 datetime1

C1 datetime1

A2 datetime2

B2 datetime2

C2 datetime2

D2 datetime2

E2 datetime2

D2 datetime1

E2 datetime1

Lutz,

Sorry missed it

bcp "select 'Col1', 'Col2', 'Col3','Date' union all select top 15 cast(Col1 as varchar(25)) as Col1,Col2,Col3,cast(DATE as varchar(25))as DATE from TABLENAME where SortOrder<>0 ORDER BY SortOrder asc" queryout D:\XXXX.xls...

Lutz,

bcp "select 'Col1', 'Col2', 'Col3','Date' union all select top 15 cast(Col1 as varchar(25)) as Col1,Col2,Col3,cast(DATE as varchar(25))as DATE from TABLENAME where SortOrder<>0" queryout D:\XXXX.xls -c -SXXXXXX -T

Lutz,

I order by DATE field, its default GETDATE. At one time, 5 records would be inserted, so all the 5 would be having same datetime value. Example data is...

1. First query returns the same error

2.

DECLARE @datefield VARCHAR(10)

select @datefield = CAST(DATEFIELD AS DATETIME) from TABLENAME select @datefield

returns only one record after which it returns same error. The one record...

Markus, thanks for the brief reply.

1. For Extended SP's, I go to Database Properties->Security-->

Roles-->Database Roles--> Public--> Properties-->Securables

Here, I see a number of Extended SP's. I had to select each one...

I would have to sanitize the code before posting :(...even then it would be difficult, anyway will check on that..

Thanks Ninja for reminding about the MERGE. 🙂

Only one table is involved in the entire operation (case/update/bulk insert)

Thanks for the immediate reply.

I would be checking for a value in a particular column and depending on the value.. i would be running update queries (different one for...

Do we have any other way.. to fix this? The link has code which has BCC etc. which is not needed. A basic mail parameters are fine.