It's clear example of hardcoded business logic.

Wrong by definition.

This is the core of your problem, not ANSI standad or its implementation in MS SQL.

Russians use to get stuck with this kind of questions after 2nd bottle of vodka.

What you've got today?

Yes, this is it, and...

> We were asked how to do this in MS SQL Server,

What makes Edwin's suggession extremely "useful".

> Until you are willing to post all your code as I did,...

It's good to read manual time to time. At least when you are in trouble.

See BOL:

ORDER BY 1 means "order by 1st column in the query".

ORDER BY 2 means "order...

During DELETE only LOG file is growing. So, this may lead to situation when DB run out of space.

So, you need to shrink it just not to allow to grow.

.mdf...

> No, I don't remind myself of my own kids.

You should. Because (quote) "they look for things and don't see them when it is right in front of them."

Does syntax...

And for SHRINKDATABASE specify you need to shrink LOG file only.

Then you can run it not only off hours. It will methodically delete records by small portions and let everybody work...

Looks like you need to add into the loop 2 statements before WAITFOR:

BACKUP LOG WITH TRUNCATE_ONLY

DBCC SHRINKDATABASE

Sounds terrible, but it seems to be the only exit from this dead end.

It's...

WHERE?

Select * From Table

Where Date(timestamp_column) >= DateAdd(Day, 1, DateAdd(Month, -1, Convert(Char(10), GetDate(), 120)))

Where is it "RIGHT HERE"?

Don't yourself remind you of your kids ?

Sorry to disappoint you, but your test is not right.

1st, Edwin's query was this:

Select * From Table

Where Date(timestamp_column) >= DateAdd(Day, 1, DateAdd(Month, -1,...

You requested query for records with date FROM month ago TO moth ago + 1 day. You've got it.

Than you changed request - dates FROM month ago TO ... no...

I did respond.

And respond was complete.

What you have found missing in that response?

If it's an image it's not a link by definition. Everything going into image_column is an image, not link. Even if that image is just displaying picture of a link.

Easiest...

Actually embedding photos  is what image datatype is about.

If you don't want them to embed photos then just remove image column and replace it with nvarchar(255) one. They gonna store links...

Yeah, you're bloody right. Terrible thing.

Try this:

Select Country

FROM CarrierRates.dbo.International R

WHERE R.Country_Cd = SUBSTRING(@ANI, 1, LEN(R.Country_CD))

AND R.City_Cd = SUBSTRING(@ANI, LEN(R.Country_CD)+1, LEN(R.City_Cd))

If you have computed column for...