I don't use schemas everywhere for the sake of just using them but I DO use them and they are fantastic!  I have a datawarehouse that contains data from several...

There are two main ways to create and publish SSRS reports.  The first is to use Report Builder and the second is Visual Studio but you need to install SQL...

It's been just about two weeks and still haven't had any issues since I made the changes mentioned in my previous post.  This job was consistently failing at least a...

You will want to use a window funtion for this. If you provide some sample data I could make sure it comes out the way you expect it.  Or you...

Well the leading wildcard in that LIKE clause will guarantee it will have to do full scans.  Something LIKE 'text%' is fine though.  I guess it comes down to your...

Lynn's suggestion is the way the go.  Since your a little rusty here is an example on how to create a calendar table.

I normally have a dedicated Tally...

This seems to work fine for me unless I'm missing something...

DECLARE @guid UNIQUEIDENTIFIER, @binary VARBINARY(16)

SELECT @guid = NEWID()

SELECT @binary = CAST(@guid AS...

Ok, back in front of my computer.  Also I didn't originally scroll down and see your expected output.

I omitted eventid for grouping purposes but it's the same as...

Sorry but I’m doing this on mobile right now. Just follow my example for the window function where I use MIN but instead use FIRST_VALUE and change the column name...

I don't fully unserstand your requirements from your description but yes you can get the same result set without doing a self join and by using some window functions.

I'm going with converting the dates at the source and see if that buys me anything.

SELECT ID, somedate
FROM OPENQUERY(INFORMIX, 'SELECT ID, TO_CHAR(somedate, "%Y-%m-%d") somedate...