The best high-level explanation of Windowed functions I've read so far! Excellent work.

This is excellent. Think I'll probably get some good use out of this query. Will post again if I notice any issues.

I just don’t understand....

From

CREATE TABLE [dbo].[ErrLogData](

[LogID] [int] IDENTITY(1,1) NOT NULL,

[LogDate] [datetime] NULL,

[ProcessInfo] [nvarchar](50) NULL,

[LogText] [nvarchar](4000) NULL,

[SQLServerName] [nvarchar](150) NULL,

PRIMARY KEY CLUSTERED

(

[LogID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY =...

Red Gate SQL search will do this and much more as well as being totally free.

http://www.red-gate.com/products/sql-development/sql-search/

Cheers tpalmer. Anoter SSMS oddity where technically SSMS is correct but still not working as expected.

Hi Perry,

I know i'm jumping in here a little bit but if the offer still stands would I be able to get a look at that guide?

Just started...

@jack-2 Nice response, Very helpful.

Hi Andy,

Great post, it really helped me out of a bind!

Keep up the good work, as its really hard to find good SSIS tutorial examples.

Cheers

Chris

Hi,

I used Visio for around three days with those three days being possibly the most stressful of my life, and the kicker with Visio is once you've persevered and...

HI Lutz,

Ok change of plan, i've redesigned my import procedure to inculde a import staging table for any problem Donation Amount files etc based on your advice, and to...

Hi Lutz

Cheers for the advice.

In the end I've decided that when I import the XML DonationDetail file I import all IDs from the file to XMLDonationDetailID regardless and the...

Hi John,

Many thanks for the response.

So far (i'm fairly new to SSIS) I have three sequence containers, 1 parent and 2 children. The parent container has a data...

Hopefully its not a problem me linking to another website but I found

http://stackoverflow.com/questions/307027

very useful in my final solution.

Institutional knowledge and all that.....

Thats excellent advice, many thanks.

Now I know that I can include the same attribute in multiple subtypes of the same supertype my conceptual ERD is going to look a...

Paul many thanks for the advice.

How ever what would happen further down the line when it comes to implementing the design and if I decide not to roll up...