Hi John,

I am glad for your reply,  I need to use this conversion of time and their time difference as well, I believe STUFF function might not able...

HI Phil,

I am glad for your reply, this is not off requirement, we are going arrange Sql Job status monitor report in TV, where everyone can see what report is...

Hi,

I need to copy folders from location A to Location B.

1) Copy Folders from A[Eg: Folder 1, Folder 2....Folder 100] to B location, by checking location B folders[Eg: Folder1, Folder2...Folder30...

Hi,

I am trying to create view dynamically using sys.tables and sys.columns with filtering required tables.

For that I am using multiple variables.

Eg

Declare @varaiable nvarchar(max)

Declare @varaiable2 nvarchar(max)

Declare @varaiable2 nvarchar(max)

Declare @varaiable3 nvarchar(max)

select...

we are getting nulls because, if the columns are in two tables that mean in Application we have moved particular column from one window to other window. When we moved...

Hi,

I am using sys.tables and sys.columns to bring a tablename+'.'+columnname as one column[MasterColumn] , but I have encounter there are few same columns are available in the different tables in...

I have working on two assumptions:

1) If there are two columns are same, one column will be null in one table, so bring only one column whichever it is...

Example Scripts for storing existing table structure and data into temp table, and drop the table and create same table with additional column and repopulate data from temp table.

Hi Lowell,

Could you share your script.

Thank you

Raj

Can you give suggestions how to write this script in SQL for above code.

Many Thanks in advance

Yes, they are columns of two tables, the requirement is all they what this batch of code run in ssis package or job.

They are expecting to run with...

Nearly I am trying to achieve like this:

http://www.mssqltips.com/sqlservertip/1657/get-active-directory-users-and-groups-with-sql-server-integration-services/

But without using Script/.Net can we do some other way.

Many Thanks in advance

Hi SQLBill,

I have checked with select col1,col2,col3, col4 from table, it works fine, but i have more than 130 columns and moreover when the MANAGERS access with excel or ssas,...

If I create new view with only selected columns and assign to role, then it will work either in excel or ssas or ssrs. But I am wondering without creating...

Hi Orlando,

If I need to give access more than 300 users only on two views, these views going to be used in SSRS and Tabular Model. So I need to...