It turned out that the server's time was a little bit ahead. When I set the reports to run in the next 2 minutes, the subscriptions were created....
I used .Net<br /><br />= "Run Date: " & CDate(Globals.ExecutionTime).ToString("MM/dd/yyyy HH:mm<img src='/community/emoticons/emotion-7.gif' alt=':s'...
Since yesterday, new subscription will not fire. However old subscirpitons are still running as scheduled. Any ideas? Thanks.
substitute Getdate() to your date, you will get the first date of the week: select dateadd(d, 0, datediff(d,0 ,DATEADD(d, -DATEPART(dw, getdate()) +...
Here is how to get no 4 same entries for each FileID. You can modify the query from here to get what you want. select * from FileData where FileID...
Create View ViewName as Select p1.ProductID, P2.ProductTypeName From dataBaseName1.dbo.Product p1 join dataBaseName2.dbo.ProductType p2 on...
Hello, I want to save the XML output into a table but apparently the following didn't work (also menitoned in the BOL). insert#tmp select*...
if you parameters are pStartDate and pEndDate, add the following code to your textbox: = "In the Period of: " &...
Actually that's what I am avoiding to do - loop through my record set to insert into the textfile one by one...
I guess the answer is I can't do it from Reporting Services.
I checked the VB Script. I saw that I can only append to the end. So I can probably take care of the row count, but still couldn't add the filename...
I determine the dates in the SP according to the passed in parameter: DECLARE @MyStartDate SMALLDATETIME DECLARE @MyEndDate SMALLDATETIME IF...
I don't see the option of exporting to .txt. Can I?
Hello, Can i export to text file from DTS with header and footer? What I am looking for is: MyFileName20050901 Data1, Data2, Data3, Data4, Data5...
echi, yes. Let me know if this works on you.
How about doing some tricks? declare @i int declare @TableKey int set @loop = 1 while (1 = 1 ) begin -- random key SELECT @TableKey =...
It happened to me before. Well, I just backup the log file several times, then shrunk the file. If not enough space is release, repeat the...
Can you put the 3 millions record in a tmp table first, update, and then insert the results into the final table?
1. DatabaseID<img src='/community/emoticons/emotion-3.gif' alt=':O' />bjectID<br />2. DatabaseID:FileID<img src='/community/emoticons/emotion-4.gif'...
Thanks to all of you!!
Separate names with a comma.
