You can make those huge case expressions much simpler, shorter, easier to maintain....

'FY ' + cast((YEAR(Registrationdate) + MONTH(Registrationdate+2)/12) as varchar(10)) as FY,

(MONTH(Registrationdate)+3) % 12 as FYMonth

FunkyDexter (7/11/2012)

---

I don't think that's what I'm after but I might be miss-understanding you.

To be clear, when the user picks e.g. row 8 in the drop down box, I want...

Any answer can be valid as anything unspecified can follow - any alter table, drop table, even drop database.

It's like a question "Guess what I'm thinking about".

Your case looks like list partitioning.

http://msdn.microsoft.com/en-us/library/ms345146%28SQL.90%29.aspx#sql2k5parti_topic25

This article should be helpful

Limit Groups by Number Using Transact-SQL

http://www.devx.com/dbzone/Article/41808

It depends on frequency and size of updates. For most cases transactional replication is ok. Snapshot replication is usually used for initial data. If transactions are big and very frequent,...

This theory may hold for some developers. Sincerely, I don't understand this distinction between developers and dbas.

Besides knowing how to write/test code in my development tool, I have to design...

You should investigate which task causes this as the problem may escalate.

First step would be to find out what changed in last week. If nothing pops up, decompile transaction log.

The...

If I understand the problem, you want to raise error if flags contains a bit not in table1.

CREATE TRIGGER [dbo].[BitTrigger]

ON [dbo].[Table2]

FOR INSERT, UPDATE

AS BEGIN

DECLARE @AllFlags ...

Well, this won't work properly, when @SortBy='Days desc' or @SortBy='FrstName, days' or ....

Also, you're paging on m.CreateDate and sort within page using @SortBy.

Try something like this:

EXEC('select .... SELECT ROW_NUMBER()...

Of course.

Instead of select....order by @sortby

you execute this:

exec('select....order by '+@sortby)

Jeff Moden (5/15/2009)

I agree that SORTs can use a fair bit of TempDB, but not a 550GB TempDB. Credits to Navy Beans says we'll find out that this was...

See if there is any kind of sort in execution plan. Cross join can produce a huge result, but not necessarily anything in tempdb.

If you have an "order by"...

Imo worst problem of old geeks is lack of physical activity. Physical fitness strengthens mental fitness.

Next thing is lack of motivation, unless you're your own boss.

So, if you think your...

It does not create a database. The problem is not the .MP3 extension, but syntax.

I get Msg 102, Level 15, State 1, Line 3

Incorrect syntax near 'name'.