Vedran Kesegic (6/2/2011)

---

I would move begin tran just after begin try, and commit tran just before end try.

That's because not all transactions can be commited.

If commit raises error and it...

sdvoranchik (6/1/2011)

---

I worked for Cizer several years ago and the Quick Query tool was designed to do what the poster was asking. There's nothing in it for me, I...

Newbie Question

I was referenced this series by a post on the forums but after reading the highlights (not the article in full) I'm not sure this is the right...

Many thanks to all who have replied with recomendations/links.

sdvoranchik (5/13/2011)

---

There is another reporting tool I had worked with in the past called Cizer .Net Reporting that sounds like it would meet your needs as well. It also...

Kooper - I don't know if you...

GSquared (5/10/2011)

---

Have you tried connecting Excel to SQL Server? I've done that, for pivot tables, et al, and it works beautifully.

As for SSRS, Report Builder has wizards for building...

I just stumbled across how to get the total row count returned as a value in the results. Another user (cold Coffe) posted the suggestion to go with

Count(*)...

Wayne,

I managed to work it out and get what I was looking for however I've got another RANKING functions question I was hoping you might shed some light on.

Is there...

I looked at your rowcount sample and...

Couple of items to note all of which assume a SQL 2005 platform as you say this code is for:

1) The call to DBCC UPDATEUSAGE in your ‘proc_records_per_database’ SP is...

If you (like me) have a SQL 2005 instance with a DB set to level 8 compatability then the below which works for me may be of interest.

NOTE:...

WayneS (5/18/2011)

---

DECLARE @test-2 TABLE (

SalesOrderId INT,

ModifiedDate DATETIME,

PRIMARY KEY CLUSTERED (SalesOrderID, ModifiedDate));

INSERT INTO @test-2 ( SalesOrderId, ModifiedDate )

VALUES ( 1, '2011-05-19 01:10:52'),

...

Jan-155192 (10/25/2005)

---

By the way, I ended up with the following code. Thanks for helping.

Jan

CREATE TABLE #tmpADUsers

( employeeIdvarchar(10) NULL,

SAMAccountNamevarchar(255) NOT NULL,

emailvarchar(255) NULL)

GO

/* AD is limited to send 1000 records in one...

homebrew01 (5/16/2011)

---

I don't think compatibility level would affect it. It should work .... give it a try.

If you are running on a SQL 2000 instance, then you would need to...