Viewing 15 posts - 18,871 through 18,885 (of 26,490 total)
Well, you did provide us with data, but unfortunately it isn't in a readily consummable format and I really don't have time to put it into a usable format at...
September 14, 2009 at 11:37 am
Not asking for actual data. You should be able to create a data set that is representative of your actual data that also reflects the problem you are trying...
September 14, 2009 at 11:12 am
This part is confusing:
The problem I have which I may need help with is that, the system I have is based on the year ending on the first Saturday of...
September 14, 2009 at 11:01 am
Now all that is missing is the sample data and expected results.
September 14, 2009 at 10:41 am
Paul White (9/13/2009)
Many of you might recognise Matt's name from...
September 13, 2009 at 9:55 pm
Paul White (9/13/2009)
Please direct pork chops to me rather than Matt. We had a very interesting discussion on the site earlier, and it came up that...
September 13, 2009 at 9:41 pm
setiv (9/13/2009)
-- ...
September 13, 2009 at 9:33 pm
Totally different subject.
Then you have this. Not only that, I seem to have a groupie. I found this post as the respondant PM'ed me the thread!
September 13, 2009 at 9:24 pm
Matt,
The best way to have requested such help would probably have been to post your requests in the Anything the is NOT about SQL forum in its own thread. ...
September 13, 2009 at 9:21 pm
If SQL Server is doing a table scan it means it doesn't think any of the indexes are useful. Please read and follow the instructions in the second article...
September 12, 2009 at 2:29 pm
I'd start with BOL (Books Online).
September 12, 2009 at 11:53 am
First, you probably shouldn't have created the trace table in the master database, but since you did, oh well.
You should be able to consume the data from the table directly...
September 11, 2009 at 10:46 pm
Have you updated the statistics on the SQL Server 2005 database?
September 11, 2009 at 3:24 pm
Please read the article I suggested. Unless I want to take the time to write CREATE TABLE and INSERT statements, there really isn't much in your latest post that...
September 11, 2009 at 2:58 pm
Does this help you get where you are trying to go?
declare @PayDate datetime;
set @PayDate = '2006-12-01';
select cast(year(dateadd(mm,3,@PayDate)) as char(4)) + '-' + right(cast(year(dateadd(mm,3,@PayDate)) - 1 as char(4)), 2)
September 11, 2009 at 12:55 pm
Viewing 15 posts - 18,871 through 18,885 (of 26,490 total)