I think this will work regardless of the date you pass in.

SELECT DateAdd(Day, -1, DateAdd(quarter, DatePart(Quarter, getdate())-1, '1/1/' + Convert(char(4), DatePart(Year, getdate()))))

I don't think that there is a way to do this in SSIS. In SSIS you would compile the function in a DLL and then reference the DLL....

It looks like you are running the same code in IF and the ELSE. If your goal is to remove Line Feeds from the value column then you all...

Simple minds only see the simple solutions

scott.w.white (7/31/2008)

---

Not really you control your access still...

I'm not saying that this is the best way, but I have always had (in the US) address tables with Address_1, Address_2, Address_3, although in the US it is rare...

I think I have a workable solution that is relatively simple. Create your daily job and do not schedule it and your first of the month job with a...

I can't say that I have actually done it, but not only can you replay a trace after creating indexes but you can use a saved trace as the workload...

The code should work in an update statement as well. I notice in the code you have posted you are missing the 'END' for the CASE statement and I...

sgoldman (7/31/2008)

---

- Do you find yourself writing a substantial new set of Stored Procedures for each new application? Or do you normally set up the bulk of the...

I'm glad we got you up and running. Now it's time for you to dive into BOL (Books On Line) and read up on sp_trace_create. It has all...

Are you sure that SQL Express was installed as a named instance and not as the default instance? With 2005 you can install SQL Express as the default instance....

Is there only 1 instance of SQL Express running on the server? Did the default port get changed?

If your Windows user is a login to the box and a...

antonio's solution and my solution are very similar, either should be a major improvement. I like the CTE syntax because I find it cleaner and easier to read.

You can definitely eliminate the sub-queries if I understand what you need. I would probably do this in a couple of passes, just to make it easier to read...