Please Google the nested set model for treason hierarchies. You're still writing procedural code with traversal instead of thinking in terms of declarative set-oriented code. Finding leaf nodes in the...

You've already learned your obvious problem of confusing a system function call with a string. But the truth is it's worse than that. You don't know the table must have...

Build a calendar table with one column for the calendar data and other columns to show whatever your business needs in the way of temporal information. Do not try to...

Have you looked at archive tools? This is not a SQL job.

I have a VARCHAR(n) field [sic: columns are not fields!] that is the description of my product like these 2 ones:

Ref Design

2566000 Sandália BEBE 19/24 Cx12

2578995 Chinelo M/ Dedo SENHORA...

I would strongly recommend that you don't take this approach SQL is a declarative language in this kind of recursion is based on tree traversals and procedural code. After 30+...

I think you should throw out everything you've done and start over. You don't seem to know that by definition a table must have a key, so you've declared temp...

>> Table_A has following rows: <<

Why do you think that's a good name for a table? Do you find it clear and precise? Just offhand it looks like shipments, not...

Why are you doing display formatting in a database? That's supposed to be done and presentation layer. The leading comma is an old trick we used to use back in...

We have no idea what any of the tables involved in this procedure look like. Since the procedure does something, its name should be a verb but instead you have...

http://tdan.com/data-mining-on-a-budget/5343

Here's a link to an old article I wrote of my adventures in barbecue land. It's easy enough to find the various shades of relational division pick which one is...

Google around for the term "relational division" as a solution. Many years ago (well maybe decades now) I did this for a mail-order barbecue company (Corky's). Their products are gift...

>> I have a stored proc that uses table pivot to dynamically create the value for a column name called EventYear and then uses that value as column name <<

I...

> You can return a random number of rows using CHECKSUM and NEWID <<

Is this method a uniform random thing? I think I remember that a lot of these SQL...

>> I have the following dataset: <<

And thanks to your lack of netiquette, we have no DDL. When you're at work do you ask other people to do the basic...