It just turns out the solution has a deficiency: it seems cannot get result for url like more than three "."

declare @url varchar(255)

set @url = 'cid-0d8636520754b1ec.users.storage.live.com'

select PARSENAME(@url, 2) + '.'...

Thank you so much for your quick and simple solution

chris.johnson 1969 (7/28/2014)

---

Maybe I'm just being a bit dense but I would rather use the below script to generate instead of relying on the datediff function and working back from...

paul.pennington (7/28/2014)

---

As written, your code would leave out any transactions datestamped for the start time of the period:

WHERE

d.DateFirstIssued > fy.FYQ2

Shouldn't the operator be >= to include the start date and...

g.britton (7/27/2014)

---

Much better to use a date dimension table that contains all relevant date info for your company. You can include columns like 'IsHoliday' or 'IsWeekend' as well as...

Jeff Moden (7/23/2014)

---

halifaxdal (7/22/2014)

---

For the 400M file, I remove the first two rows (non data), I also added BULKSIZE = 200 to the Bulk Insert, and I was able to...

Alvin Ramard (7/23/2014)

---

It looks like a normal task, but you task was made more complicate by the fact that the file is not properly formatted for a "data exchange" file....

Alvin Ramard (7/23/2014)

---

Reading about this after all the discussion, I'm starting to think it would have been a lot faster to try the import with VB or C#, or at...

For the 400M file, I remove the first two rows (non data), I also added BULKSIZE = 200 to the Bulk Insert, and I was able to load all the...

Jeff Moden (7/22/2014)

---

David Burrows (7/22/2014)

---

Jeff Moden (7/21/2014)

---

Think of it as a "Unicode file prefix". It actually means something else specifically and I can't think of the precise meaning but...

Jeff Moden (7/21/2014)

---

halifaxdal (7/21/2014)

---

as I suspect if the EOF was recognized by bulk insert, I compare the two data files (the larger file costs me long time to load and...

as I suspect if the EOF was recognized by bulk insert, I compare the two data files (the larger file costs me long time to load and even longer time...

For the little test data file, the script and the format file work like charming and finished in less than 1 second.

I decided to go further, so I started...

I found the root cause to the error, there is nothing wrong with you code but in fact when I save the format file, the UltraEdit automatically added some prefix...

Thank you so much Jeff,

BUT, the first line of your script throws me an error:

Msg 9422, Level 16, State 48, Line 1

XML parsing: line 2, character 0, incorrect document...