Use this bit to get the results without using a cursor. Replace <<mydb>> with a database that exists on your server.

if not exists (select * from dbo.sysobjects where id...

Can you explain what you mean by "End Of Day process"

"What u think i am playing with sql server or i am joking."

I don't know what to think, that's why I asked the question "Are you really serious that you...

Are you really serious that you want all this "in one QA window with one sql query" ??

Closest you're going to get if this is a definate requirement is DBCC...

Looks like your copy and paste didn't work. There should be a line break or space in between @tbl and GROUP

"... but was looking into other option for a divider inside a drop downlist"

Another method to skin that cat it to use union queries.

DECLARE @tbl table ( grp varchar(4),...

I doubt you'll get anything in SQL Server to provide client details. From SQL Servers perspective the client could be a server, workstation, web page, application, etc...

You might be able...

How about a different approach,

1) Bulk Insert into a staging table so you can easily get your rowcount.

2) Insert into production table so your triggers fire.

So are you executing the BULK INSERT via an ExecuteSQL task, or are you using the in-built Bulk Insert task? I can't confirm it at the moment, but I believe...

The presentation format of the data should be done on the client that is displaying the data. eg: Excel, Crystal Reports, Reporting Services, etc...

This is very clunky and NOT...

"1. i want to remove both the hyphen and whiite space

2. but there are 10000 records which has has got this trouble in that field (Phone_Number). do you mean...

What account does the SQL services run under? Do the have permissions on the ...\MSSQL\LOG directory? Are you able to stop the SQL services and manually rename the file.

Maybe...

"also don't use a function on a column on a where condition. You don't allow any indexes to be used in the query"

Hmmm ... guess I've just got a super...

The Operating System Command step starts in c:\windows\System32 directory because that's where the cmd.exe resides. I don't think you're going to change the startup location without some serious OS hacking,...

Have you tried Log PI http://www.logpi.com/

I seem to recall that had the functionality to load log backups. Could get you somewhere maybe