You would have to deal with the non-dummy dates first. (Or if you can do it with a join?)

Then you could just use something like

UPDATE <tablename>

SET someDate = '01-01-1900'

WHERE...

I would do it with a Calendar table. Then you can query for Mondays within your date range and then do the insert.

Here's a link:

http://www.sqlservercentral.com/articles/T-SQL/70482/

You're missing the DelimitedSplit8K function, which is here[/url]. If you read all the way to the bottom, the code is in one of the downloads at the bottom of...

Is this a test database where you need to just generate a bunch of random records? Jeff Moden has an article or two on it I'm sure. Chris...

Is SSRS 2012 pretty much the same (in terms of setup procedure) as SSRS 2008? I know that there are good videos and information on that. Have not seen...

Thanks for the feedback/response. I was thinking about checking out Paul Turley's book. (Getting harder now that brick & mortar bookstores are pretty much a thing of the...

If you go to PragmaticWorks.com, they post their videos on various SQL topics. Brian's stuff on SSIS is really good.

http://stackoverflow.com/questions/1179082/ssrs-tracking-report-usage was interesting and probably will help you.

It mentions that once you determine the reports that nobody uses that you can move them to unclutter your RS instance.

What is the source of your EDI data? Whoever supplies the data should have the format for you. I think there are folks that write EDI parsers too....

Did you specify a collation on one or more columns in one of your tables? It sounds like you're trying to get the collations to match, and they don't.

This exercise is a lot easier to understand if you have some data to work with. It's easier to see repeating fields if you have a table structure. ...

sounds like you need to union one result to another so that they end up in the same dataset.

Jason Selburg wrote something that does that:

http://db-pub.com/news-10013929/data-driven-subscriptions-in-sql-rs-standard.html

Ideally, you would have someone fix the dirty data for you, and your problems would go away. But if that's not an option, you could create a calculated field...

Welcome!,

Did a little digging around both on here and the internet and found a couple of really good examples showing how to do exactly what you are asking about.

Kathi Kellenberger's...