I do have to disagree with a database "being a poor choice" to support documents and images.  At best, I'll agree to say "It Depends" but even that bothers me...

From my quick look, there is absolutely NOTHING in the code in the original post that requires Dynamic SQL.

In our environment, such hint is placed after every single table in every join in every stored proc.

SELECT 1

FROM #GR             X     WITH(NOLOCK)

JOIN GT           ...

First of all, I never drop a supposedly unused stored procedure immediately.  I rename the stored procedures by appending the with "_ToBeDeleted"  Such a rename constitutes a modification of the...

I have the following data in a table, its pricing for items, so if a customer buys 275 of .250BP, they pay .043

I need to get this data in...

That's pretty interesting. Looks somewhat similar to Eirikur's but a few differences. The one thing I am not a fan of is that it has the same major...

It did the same thing for us... went for 7 years with no incident and then it apparently hit a tipping point... and the tipping point wasn't gentle... it was...

I've gotta say it again...

While I agree that this doesn't appear to be a problem of any kind, it is a sudden almost 30% increase in usage from the "baseline". ...

Not sure in this case but I'd be tempted to say that the LOGO database is corrupt or actually.  First thing I'd do is execute DBCC CHECKDB on it to...

You're already on one of the greatest projects there is.  Start answering questions on the these forums.  You won't find a broader range of real life problems to solve anywhere...

I've been cycling to work, 5 miles each way, for over 17 years now, and I feel about it all the ways you talk about your running. Five miles...

BWAAAA-HAAA-HAAAA!!!!  I LOVE the cartoon!  Thanks for the great laugh!

Suppose you have column ID in table T. Try the following:

Select ID, CAST(ID as Varbinary(255)) as Hex From T.

I find this to be sufficient in almost every case (and...

If you're...

Shifting gears a bit, have a look at the original post on the following thread (no need to pile on.. I'm just confused) ...

https://www.sqlservercentral.com/forums/topic/conversion-failed-when-converting-the-varchar-value-to-data-type-int-4

The OP posted this early on...