Hope this helps you..

SELECT TableName, COUNT(*) [Dependency Count]

FROM (

Select Distinct

o.Name 'TableName',

op.Name 'DependentObject'

From SysObjects o

INNER Join SysDepends d ON d.DepId = o.Id

INNER Join SysObjects op...

Try with the following

Use "Your-DBNAME"

GO

SELECT DISTINCT o.name ,o.xtype

FROM syscomments c

INNER JOIN sysobjects o ON c.id=o.id and o.type='p'

WHERE c.TEXT LIKE '%SEARCH_TEXT%'

PS: type='p' is to retrieve only stored procedures from sysobjects.

Thanks

Kivan 😉

--------- some logic

--------- some logic

where empid=(select empid from #emp where deptid=2)

In this case as i said you can insert it (select empid from #emp where deptid=2) to an temptable so...

Probably you can assign this resultset to a table variable or a temp table and can make use of the same later when required.

Hi,

You can use this Query to add an character in between the value of an existing field

Select STUFF(ColumnName,4,0,'.') from TableName

Hope this helps.. 😉

Thanks

Kivan.G

As per my understanding Hope the following query'd return the No.of Reported Items of each Facility

Select distinct F.Facility,Count(ReportedItem) [No.of.Items] from ReportItems R

RIGHT Join Facility F on R.Facility= F.Facility

Group By...