I can make a guess as to why you have a zero in the denominator. You are dividing an INT by 3600.0, and then this number is the...

Performance tuning is generally done for a specific performance goal, and without some detail on what you already have in the way of tables, indexes, row sizes, row counts, and...

Question: If a staff member works with 2 patients at the same time, for the last 15 minutes of the work with patient1, and those 15 minutes are also...

OOps... just saw the post about connections NOT being Linked Servers. But remembering your mention of Crystal Reports, it does a rather similar thing, so I try to...

I'd be interested in knowing how well that query runs against the Reporting/Backup server from Management Studio, as I suspect that what Lowell posted about using OPENQUERY might help. ...

Jeff Moden (12/10/2012)

---

sgmunson (12/10/2012)

---

You can always kill one spid or the other, but you should know the impact of that first. As to what you meant by "deadlock...

You could also create a "template" so to speak, with the necessary tabs with column headers only, from the resulting spreadsheet, and copy it over the exsting spreadsheet each time...

marlon.seton (12/10/2012)

---

Hi Steve,

Thanks for your message.

Yes, I've tried to search for the sqlcmd equivalent of -D and -n but to no avail.

I've not considered SSIS because I know nothing about...

Nevermind... missed part of the requirements and had bad code posted... GSquared has it covered...

Take a look at the following VBScript. I took your data (removing the color directive and the <CR/LF> codes), and pasted it into a TEST_DATA.TXT file.

Dim fso, FH,...

Deadlock is a condition where two or more queries go after resources that the others are using, and in at least 2 cases, an "other query" needs an exclusive lock...

This sounds like they've scheduled FULL backups of the database file, with DIFFERENTIAL backups of the transaction log file, but it's also clear that the statement was made by someone...

You can always kill one spid or the other, but you should know the impact of that first. As to what you meant by "deadlock and blocking both...

I too, had assumed that you only had 1 delimiter - the #. Then came your response indicating 1 # and a bunch of tabs. ...

I'd have to go look to see if I could find equivalents, but I suspect you've already searched and come up empty, so I'll ask if you've considered using an...