You're also likely (continuing the pun) to see some pretty poor performance - with the leading wildcard, you won't be able to utilize an index.

Hi Paul,

#1: yes, you're correct, I didn't think about bulk loads.

#2: A default is only used on the initial insert into the table for that row. I was thinking about...

assuming that you would also need rows in the output of:

1084d1084d

1084e1084e

1084f1084f

Then this would work. Someone might be able to make it nicer...

-- See how this starts off with a table...

Talk to your credit-card processor. I believe that they have some numbers that can be used for this type of thing - they pass the verification process but are completely...

I assume you're talking about doing this in Reporting Services.

Click on the detail row. On the far left, just to the left of the report, right-click on the box beside...

Rem-487422,

Do you understand how the code that Scott sent completely replaces that cursor?

Rahul, falgunoza did a pretty good job of explaining it. If there is something that you still don't...

Step 3 upgrades the secondary.

Step 5 copies the tlog backups from primary to secondary, and applies them to the secondary.

Step 8 upgrades the primary.

Glad it helps

Well, first of all, you can't run this exact same command in sql 2005... the microsecond precision is only available in the datetime2 datatype and other SQL 2008 new datatypes,...

How's this:

-- See how this starts off with a table and data in it?

-- If you had provided us the data in this format,

-- it would have made things...

Cool, I was hoping that there was a solution for this, it just sounded like a reasonable thing to do.

Good job Lowell!

(Now if only one could bookmark a forum post...

Here's my solution. This first part uses the test data you provided in your first post, with an additional row showing the startdate overlap.

--===== If the test table already exists,...

I was thinking the other day that maybe we could use a persisted computed column for something like the Modified date. If I set the column "Modified_date" as a persisted...

Here's a quick example of the differences of the different datatypes. Note that to insert the time into the datatypes that support time, you have to prefix your MM:SS with...