What does this data represent? Are Categories of items a store carries? Are Subcategories as it sounds, subcategories of Categories?

Vinu512 is on the right track, and there are ways that...

So forgive me if I'm missing what you're trying to do here, but let me know if I'm on the right track.

If you inner join all 3 tables together on...

rs-337036,

I think I have a rough idea what you're trying to do, but can you clarify a few things? First, you list a Parade table but reference a Festival...

I know you said you are not a coder, but if you can provide some example data, it would be helpful.

capn.hector (3/12/2012)

It's certainly a one-off scenario. Truthfully, the only reason I've ever come...

This is a very elegant analogy for what takes...

Now if only we could get 2012 on our production boxes before 2020. So excited for SS2012

This may or may not be relevant to your situation, but I have two distinct severs with a similar database layout and sometimes I forget to check which server I'm...

Forgive me, I know there are technical definitions which relate to set theory, but in laymens terrms, here are the distictions between a few key concepts

Column: Represents everything in on...

Can you provide the varchar string you are attempting to convert to datetime format?

There are a lot of ways to go about building a new database, and I think one of the first should be how its going to be used. Is this...

That's amazing. I've never seen something like that before. Thanks!

Interesting post and response as well. I just recently had to fight tooth and nail to get a linked server set up for my development work as well. In my...

Glad it helped 🙂

Try this:

if object_id('tempdb.dbo.#FolderDates') > 0 drop table #FolderDates

create table #FolderDates

(

FullString varchar(1000),

EditedString varchar(1000),

FolderName varchar(100),

TheDate...