Hello,my table contains 2 columns .EmpID varchar(10),ReportingToID varchar(10)how to write a query that returns all the employees under a ReportingToID ...?the key here is i want all the employees that are under a ReportingToID tree.i don't know the exact number of levels under a ReportingToID empID ManagerIDabc ""def abcghi abcjkl ghiklk jklmmm jkl Thank YouSai
2005-01-14
as long as you are using some predefined date format from TSQL you couldn't cast it.But if you are not sure about the format cast it or better convert it. Because with the convert you can exactly control the date (and time) format of your input
2004-08-26
Hi everybody:I'm receaving password protected Excel files. Those files my app reads and dumps data into SQL tables. How to decrypt (I knew a password) or make Excel file without password. Those files are encrypted because we are getting them from enternet. RGDS Sam
2004-08-19
1 reads
Well the links were really useful(infact i have already visited few of them earlier).I would really appreciate if somebody who had been exposed to such error in past can just pinpoint to something specific action items.
2004-07-20
As I alluded to in my original posting...Casting (or Converting) the date as INT or BIGINT may give you the wrong (next day) date because dates with times of 12:00 or later will be rounded up to the next day automatically. Don't use any form of INT.Further, any type of conversion to DECIMAL will cause […]
2004-02-25
Yes that should work. But you must be sure no transactions where made in the middle because they won't be replicated. Due to a bug in SQL 2000, sometimes you can get an error if you add subscribers with out applying the snapshot. Don't remember it exactly, what it was something like couldn't insert duplicate […]
2003-12-10
1 reads
quote: I was mistaken. We use this process for two main reasons: 1. If we have to change NULL to NOT NULL 2. For SQL Server 6.5 Boxes. I overlooked the "ADD" part... CREATE TABLE #Test( Id int NULL) INSERT #Test DEFAULT VALUES UPDATE #Test SET Id = 0 WHERE Id IS NULL ALTER TABLE […]
2003-11-18
quote: How big are these databases? Are there many schema changes? If you say small and not many, then check out Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net There are no schema changes and databases are small ... less than 2 GB each (B) and (C). (A) is just the interfacing database.. couple of MBs. Prateek. [HCL […]
2003-07-11
2003-06-22
1 reads
Same here: just after .NET framework along with VS Studio.NET were installed, EM became slower. This particular one also connects to both SQL7 and SQL2000, but that's pretty normal.
2003-06-04
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers