Ok sir, I'll do it.

Thanks again!

This is actual path of one of the sub-folder:

\\pinnacleserver1\FILE MANAGEMENT\asg\asg1

Root Folder is: \\pinnacleserver1\FILE MANAGEMENT

How to set share access policies in MS SQL Server??

Dear MidBar; Jeff Moden,

Thanks for quick reply.

I tried, but not working, but when am using the following procedure: exec xp_dirtree '\\server1\FILE_MANAGEMENT\air\air11', 0, 1, it's working properly, why is it so??

Thank You Sir.

I have 2 Query on this:

1: This T-SQL is not accessible in network, works only in Local Machine, if I tried with local path, I am getting...

Hello MidBar,

Am using MS SQL Server 2005 and I know about xp_cmdshell and sp_ListFiles:

exec xp_dirtree '\\server1\FILE_MANAGEMENT\air\air11', 0, 1

create table #BACKUPS

(

subdirectory varchar(255),

depth int,

isfile int

)

INSERT #BACKUPS exec xp_dirtree '\\server1\FILE_MANAGEMENT\air\air11', 0, 1

SELECT *...

No..not a homework. I am preparing a HelpDesk Solution for my Company..where they want to assign the call logs (by End-User) automatically to the Hardware Engineers according to their status...

Dear Jeff Moden,

I skip this thought of inserting 100rows at a time..:crying:

And I'll be firing the same from a TABLE name as USER_PROBLEM:

---------------------------

ID | USERNAME | PROBLEM

---------------------------

1 | ...

Thank You for your Guidance!!!

I did this & it works....:-)

, CONSTRAINT [UNQ_name_email] UNIQUE...

I want to know, what can be the combined insert/update trigger for this!!

TABLE:

CREATE TABLE [candidate_details] (

[candidate_ID] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,

[name] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[dob] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[mobile] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

...

Thank You Sir/Madam.

Even I manage to create a following Trigger:

Create TRIGGER my_tgr ON Heading

FOR INSERT

AS

BEGIN

declare @min-2 int

declare @max-2 int

declare @heading int

declare @i int

select...

Yes Sir, Following link helped me a lot and sorry, I didn't replied you back!

I tried like this with your reference:

SELECT

sum(case when Qs1='1' then 1 else 0 end)*100.0/count(ID) as no_of_1,

sum(case when Qs2='2' then 1 else 0 end)*100.0/count(ID) as no_of_2,

FROM dbo.feedback

Showing following errors:

Server: Msg 156, Level 15, State 1, Line 2

Incorrect syntax near the keyword 'Select'.

Server: Msg 137, Level 15, State 1, Line 3

Must declare the variable '@Totcount'.

Server: Msg 137,...