my pleasure; something like this is much easier to understand visually like that. glad i could help.

here's something to help visualize it:

Dave Ballentine showed you step by step how the conversion is going to work; but if you use the final answer, you don't get the timne portion, just the correct...

Yes = You meant something else?

or

Yes = That was the solution i was looking for?

ok if there could be multiple spaces before the period,

here's how i would do it: i thought about STUFFing it, but relized there's a simpler solution:

i would simply grab the...

if you mean when you copy and paste from Management Studio to Excel, it's an option you'll want to turn on:

did you mean something else?

conversions like this are a pain; obviously, whenever possible, this kind of data should be placed in a datatime filed, instead of a varchar/char; if you can, convert your original...

ajith.ranjan (8/17/2009)

---

Thanks Lowell

Your code worked for me. Next step is I have to workout how to pickup one file at a time from the directory.

It is great if...

why does it fail though? I'm speculating that the constraint is merging the INSERTED and the DELETED rows to get the count or [INSERTED] and [tbl], so it finds...

your example was interesting!

I see how that fails, when I'd obviously think that was jsut fine...That's what you mean about having to test the business condition in the trigger instead,...

I saw mine jump up; thanks!

I got promoted as a result and I'm in the "Hall of Fame" now. only 17,000 more posts and I can be like

Steve Jones...

here's a simple example I whipped up to show the table constraint preventing more than three items checked out per student id:

Create Table tblStudent (

StudentID int identity(1,1)...

David Portas (8/14/2009)[hr

SQL Server unfortunately has quite poor support for referential integrity and other declarative constraints in the database. Such rules often have to be implemented in procedural code either...

recursive triggers is a per-database option; it is usually rare that you really need to call a trigger recursively, so it's disabled by default.

right click...properties for the database in quesiton...Options...

another thing you can try to change is this:

WHERE searchstring like '%@search1%' AND searchstring like '%@search2%' searchstring like '%@search3%'...

if you search for LIKE '%something%' , then it requires a...