have your dba create a procedure that features EXECUTE AS OWNER that adds missing permissions.

have the procedure loop through each database on the dev server, and do a classic if...

bumping this for the morning, hopefully someone may remember what counts as a transaction per second.

you altered the table and added a new column [date1]

the table [Metrics].[dbo].[x64_Restore_Metrics_All_Temp] now has four columns, but your insert has only three.

if you do insert into table without a column...

i think it's just a select of three queries, which inserts into the new table.

INSERT INTO NEWTABLE(ColumnList)

SELECT RecordID,ManagerID,ManagerApprovedDate,'ManagerApproved'

From OriginalTable WHERE ManagerID IS NOT NULL UNION ALL

SELECT RecordID,ClerkID ,ClerkApprovedDate,'ClerkApproved' ...

i built this proc from some examples i found here on SQLServerCentral:

IF OBJECT_ID('[dbo].[sp_dbspaceused]') IS NOT NULL

DROP PROCEDURE [dbo].[sp_dbspaceused]

GO

--#################################################################################################

--developer utility function added by Lowell, used in SQL Server...

mar.ko (8/28/2015)

---

Ed Wagner (8/28/2015)

---

The statement that contains the CTE needs to end with a query that uses the CTE. Like Luis said, please post the code; that should clear...

looks to me like the issue is in the complicated select that you left out of the post...

you not getting the data you expect, so it's gotta be in the...

the command prior to WITH MyCTE AS(...

must be terminated with a semicolon. that's probably where the issue likes.

that issue makes a lot of people precede their [WITH] to feature...

nothing within SQL. SQL doesn't do files, technically.

SSIS or SSRS subscriptions can export data to native excel format.

otherwise, not really.. you have to use something external, like a CLR, Excel...

my example i provided made sure the valuewas converted to date type. As Luis pointed out, converting the date to a string in this format:2015-04-01 is now ten characters, with...

SQL's bcp does not create native xls files.

it only creates flat files with the delimiters you specify(tab delimited/comma delimited/custom delimited.) so your file is a text file with the...

I user a CLR...

we'd have to see your trigger. is your trigger enabled? is it referencing the procedure by full path, ie master.dbo.yourproc?

aleksandra 81219 (8/27/2015)

---

I dont need a schedule, it only about data.

I have multivalue parameter @multiple_weeks with can be for example '20010101,20010108,20010115'

and i need to execute my procedure for 20010101...

you want to create a SQL job that calls your procedure.

that job has a schedule, so you can call it once day/hour whatever.

you can leave it to run forever, or...