Make a lookup table which allocates every location mentioned in the system to a correlated currency symbol.

Locales might not be sufficient for this purpose.

I can see 3 tasks here:

- capture and record data changes;

- build a report comparing current data with the previous versions of it;

- generate HTML file out of that report...

Read about "parameter sniffing"

very common issue.

Look up for my article "age calculation" on this web site.

All is done for you. 🙂

Look for queries which are heavy on BLOB processing.

You mentioned BizTalk - do you have some massive FOR XML queries? It may be either massive XML (JSON, you name it)...

how about a table with 498 columns which is updated daily. And updated...

Can you check if the event records in your string are separated not just by space but some special character, like CHAR(13)?

you may use output to text in SSMS, or...

Hi Des,

When running the SQL against the live data source, just to test it, i'm getting this error:

Msg 241, Level 16, State 1, Line 1

Conversion failed when converting date...

Yep, you're missing one thing.

The thing is - the offset is not a constant.

it was +10:00 yesterday, or an hour ago, but it's +11:00 now.

And your code must reflect that...

Pay attention to details:

CREATE TABLE accounts (

ID INT(11) NOT NULL AUTO_INCREMENT,

CONSTRAINT FK_SESSION_HISTORY_ACCOUNT FOREIGN KEY(ACCOUNT) REFERENCES account(ID) ON DELETE CASCADE ON UPDATE RESTRICT,

There is not table "account" in your...

Honestly, this is why I personally find it easier to just store anything in UTC if I'm ever working with time sensitive data, or multiple timezones (and...

This will give you ID's for records with zeros wrapping the set of sequential records with 1's in between:

SELECT Last0.ID Last0_ID, next0.ID Next0.ID
FROM @T Last0
OUTER APPLY (select...

Here it is:

TallyGenerator

• This reply was modified 5 years, 8 months ago by Sergiy.
• This reply was modified 5 years, 8 months ago by Sergiy.

All you need is to convert normal numerical sequence to desired codes.

Something like this:

declare @a tinyint, @b tinyint, @t smallint 
select @a = 6, @b = 4,...

They say - the fastest internet data channel is a truck full of hard drives.

there might be a good reason to have a good data replication channel, so those 70...