Jakke (2/11/2010)

---

Hi Markus,

Thanks for the reply. 🙂

I will certainly test your solution.

You stated that it would work on not to big tables. Is a table with about 550000 records per...

Michael Jeffrey (2/11/2010)

---

I had forgotten to say that in all cases I am using 32 bit versions of all the software and I am using SQL Express 2008 (the free...

CooLDBA (2/11/2010)

---

CREATE TABLE [dbo].[_CalendarDate](

[F1] [varchar](20) NULL

) ON [PRIMARY]

select * from dbo._CalendarDate

8242004

8252004

8262004

select CONVERT(datetime, F1, 103) from _CalendarDate

Syntax error converting datetime from character string.

I want to convert it to datetime, any...

I don't have a solution at this time, but had the 2nd and 3rd values been byte aligned you could have used SUBSTRING by casting the BIGINT value as a...

My recommendation, don't use VARCHAR(10) to store dates, use the datetime data type.

Here is my solution since everyone else is just jumping without seeing what the OP has tried to do to solve his problem.

with FindDups as (

select

assetid,

...

Just missing one thing from your posts, the code for what you have done so far to solve your problem. Please, show us what you have tried so far...

RBarryYoung (2/10/2010)

---

OK, here's the first one:

Lynn:

I want to apologize for what I said about you in the "black-list" thread. I know that it wasn't derogatory, but it was condescending...

RBarryYoung (2/11/2010)

---

GilaMonster (2/11/2010)

---

RBarryYoung (2/10/2010)

---

1) Goto my blog site and download my presentation "TheTop Ten Reasons You Aren't already using Service Broker", or "Top 10 Fixes for your first Service Broker...

From what I can tell Hijri format requires that the date portion is mm/dd/yyyy. The strings that are failing to convert have a format of dd/mm/yyyy.

$3cur1ty (2/10/2010)

---

Lynn - this sounds familiar and just happened to me two weeks ago:)

If you're looking @ Page Faults and watching other ocounters on the source server when the full...

I take it that the 8060 byte limit has its roots with Sybase. Not all database systems have such a limitation. I had the opportunity to work with...

Just going by what our Network people say. They...

If you are looking at upgrading to SQL Server 2005 or newer, I wouldn't bother. English Query goes away with SQL Server 2005.

$3cur1ty (2/10/2010)

---

The most important variable is the size of the "backup" file (as stated) he wants to move and the connection between the servers:

> .bak file only = xcopy with...