Is there a way to get the complete hierarchy for a single Employee?

declare @EmployeeID int

select @EmployeeID = 12

;WITH

cteDirectReports AS

(

SELECT EmployeeID, ManagerID, EmployeeName, EmployeeLevel = 1,

...

gary.strange-sqlconsumer (12/16/2013)

---

Thanks for the article,

Consider using strongly typed xml and discarding fuzzy checking like datalength > 10

So you're SP's input parameter might be something like @parmeters XML (DOCUMENT dbo.MyXSD)

Note, this article is an update from a previous (pre-Sql Server 2005) version, here:

http://www.sqlservercentral.com/articles/Stored+Procedures/thezerotonparameterproblem/2283/

My comment "dynamic SQL isn't a good idea" is directly related to injection attacks, as you state.

What I like about this solution is that everything (client side with a strong...

You are to undertake this assignment individually, although you may discuss ideas with your fellow

students. However, the final submission must be your own work.

Wow, dude didn't even take time...

Here is a good post with several options:

http://stackoverflow.com/questions/272816/what-is-a-good-visio-enterprise-architect-replacement

.........

Microsoft, open up this feature with some "normal" versions !

http://office.microsoft.com/en-us/visio-help/what-happened-to-the-generate-and-update-commands-on-the-database-menu-HA010148725.aspx

I agree with "minto.antony", this is your best...

True, but BE WEARY of element based xml depending on your Sql...

Charles Wannall (10/22/2010)

---

I can see immediate usefulness in a project where I intend to use it today: I have large tables in Access database spread all over the country. ...

I'm putting this in a separate post so it doesn't get buried.

For those of you who have conducted tests for various ways to do this......this article could be the reason...

//Difficult to create XML data at the application layer.//

I no longer use (strong) Datasets in my applications, EXCEPT I do use them as a way to create well formed xml.

EmployeeDS...

Here is a "trick"

casting as a char(XX) where XX is your fixed-width

bcp "SELECT cast(LastName as char(50)) , cast(FirstName as char(50)) , cast(MiddleName as char(50)) , cast(Suffix as char(50)) FROM...

Thanks for the work........

I have static files where I (try) to keep the order of table creation....but this makes finding an orphan very quick work.

Thanks again....

Microsoft SQL Server 2005 - 9.00.3042.00 (X64)

Feb 10 2007 00:59:02

Copyright (c) 1988-2005 Microsoft Corporation

Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

Microsoft SQL Server 2005 - 9.00.3054.00...

REMOVED: (Another poster showed me how to post xml code)