Getting Column Name from table in SQL Server

select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS
where TABLE_NAME = 't_Customer'

Read More

SQL Server 2008 Reporting Services

Read More

Reporting Services 2008

Read More

Geting employees Manager by T-SQL query


CREATE TABLE emp
(
empid int,
mgrid int,
empname char(10)
)

select * from emp
INSERT emp SELECT 1,2,'Vyas'
INSERT emp SELECT 2,3,'Mohan'
INSERT emp SELECT 3,NULL,'Shobha'
INSERT emp SELECT 4,2,'Shridhar'
INSERT emp SELECT 5,2,'Sourabh'

SELECT t1.empname [Employee], t2.empname [Manager]
FROM emp t1, emp t2
WHERE t1.mgrid = t2.empid

--Here's an advanced query using a LEFT OUTER JOIN that even returns the employees without managers (super bosses)

SELECT t1.empname [Employee], COALESCE(t2.empname, 'No manager') [Manager]
FROM emp t1
LEFT OUTER JOIN
emp t2
ON
t1.mgrid = t2.empid


Read More