Viewing 15 posts - 1 through 15 (of 16 total)
no worries, change the MAX(date) in both t0 and t1 queries to MIN(date) and that will get the first instance of the previous amount.
emp effdt seq hourly maxdt hourly
A 2016-06-05 00:00:00.000 0 42.370000 2015-08-16 00:00:00.000 41.540000
A 2016-06-05...
April 20, 2017 at 1:07 pm
try this:
DECLARE @hrly_chg TABLE
April 20, 2017 at 12:04 pm
I wanted to add that there are situations when a machine has an older version of the Oracle client and when you go to install the newer 11g version that...
June 14, 2012 at 9:30 am
Thank you for the response! Do you see any advantages/disadvantages of using embedded queries in the reports vs stored procedures on the sql server? I believe that stored procedures would...
June 13, 2012 at 4:20 pm
Thank you for your reply!
I did try using code that I had used in sql 2k days, but received the same error:
Select @sql='
EXEC sp_attach_db @dbname = N'''+@db+''',
@filename1 =...
June 2, 2008 at 1:13 pm
try using this link to your server: http://"laptop name" /reports/Pages/Folder.aspx
this is the normal way of addressing your ssrs server. I am not sure why you are trying to...
March 28, 2008 at 9:29 am
I was playign with this and noticed that the table population code misses setting the IsHoliday flag. Since the table has set that column to not null, the insert fails....
March 11, 2008 at 10:07 am
I have tried to get this report to work to no avail, either. I downloaded what I believe to be the latest code, I am using SSRS2005 from within...
December 14, 2007 at 1:34 pm
I tend to put college degrees right up there with MS Certifications; Nice to have, but if you cant do the work, then its not worth anything. To me, being...
October 16, 2007 at 8:35 am
I agree with Howard Johnson!!
Having once worked extensivly at Microsoft, and with the sql developers, It is always painfully obvious that the code that is presented in examples is half-assed...
April 4, 2007 at 7:49 am
great article, but I still have one question. why not use the included Network Service instead of a domain acct? there are no passwords to change. I know MS advises...
June 6, 2006 at 6:00 pm
nice summery, but is there a link to the actual results? I would like to see the numbers for myself, as I work in a medium size company in the...
May 24, 2005 at 7:48 am
If you are running Enterprise Edition, you can set up multiple indexes to build at the same time. Depending on your hardware, You could build your clustered index first, then...
May 12, 2005 at 8:35 am
here are some things I have wanted from SQL for a long time!!!
1.) Arrays! Why doesnt sql server handle arrays? Even Foxpro has them. This seems like a simple thing...
September 22, 2004 at 9:17 am
Viewing 15 posts - 1 through 15 (of 16 total)