Search results

Thanks SQL, Did you receive my mail the other day? Regards

I have a field that contains data such as 'ACB00/02'. How would I write into a function that gathers a load of data together for me a peice of code that will grab only the first 2 chars of the afore mentioned value, So the result would be in the new created colum in a temp table 'AC'. This is...

Have manageed to answer this with SELECT CONVERT(char(11), MAX(src_date)) AS LatestMonth , CONVERT(char(11), dateadd(mm,-1, MAX(src_date))) AS [LatestMonth-1] FROM tbl_src_date and then dateadd(mm,-2, blah blah Works fine. Thanks for all your efforts SQL Hell Regards

Got this answer from a different forum which seems to work as expected SELECT CONVERT(char(11), MAX(src_date)) AS LatestMonth FROM tbl_src_date using that and changing the parameter for that field in the report from DateTime to String allowed me to successfully run the report. I wonder if I...

Problem Solved:- I noticed that in the properties for the textbox, under 'International' there was a setting for 'Language', so I selected all of the offending boxes and changed their International properties from Default (U.S. I guess) to English (United Kingdom), and bingo, problem solved...

Hi SQL Hell Thanks for your further responses. First code attempted still returned Sep 1 2005 Second peice of code displayed a unable to Parse Query error I don't get this Sep 1 2005 bit. Even if you reverse the date I have there to mm/dd/yyyy it still isn't Septemer. ?? I am going to run...

Not sure if this is relevant or not, but I have just been playing with that syntax you provided in SQL Server Query (not Reporting services) SELECT MAX(CONVERT(SMALLDATETIME, src_date, 103)) AS LatestMonth FROM tbl_src_date and no matter what style code I put in it is always the...

Ok this result has confused me I placed the code you suggested in the SQL window of the Dataset and was presented with the result of Sep 1 2005 The highest date I have in my DB is 01/01/2006 (dd/mm/yyyy) so how it came up with Sep 1st '05 is a mystery to me. Regards

If this does not work then what about the format command as the purpose of this is purely visual? If you say, 'Yeah, that would work!' You know what the next question is though don't you Hey nothing wrong with being a Geek if you are geeky enough to answer my dull questions. Keep up the...

Thank SQL, I have done that and will give it a try. This is by no means to look like a smarty pants or anything, more just to help others if they need to run the same commands. In SQL Server 2005 I had to run it like this EXEC sp_configure 'default language', 23; GO Then ran RECONFIGURE...

I ran it and this was the result allow updates 0 1 0 0 clr enabled 0 1 0 0 cross db ownership chaining 0 1 0 0 default language 0 9999 0 0 max text repl size (B) 0 2147483647 65536 65536 nested triggers 0 1 1 1 remote access 0 1 1 1 remote admin connections 0 1 0 0 remote login timeout (s) 0...

Thanks SQL H, I shall look forward to your next pearl of wisdom and insight into the murky confusing world of SQL Server. Kindest Regards

Hi SQL, It is still coming up with the hh:mm:ss in the query result. What have I done wrong here? Regards

Fantastic, Thanks SQL Hell. Tell me, do you just live in this Forum as 9 / 10 you answer any query in minutes ;) Thanks once again

I have a dataset in Reporting Services that basically just populates a report parameter field automatically for me. The small peice of SQL that I run is SELECT MAX (src_date) AS LatestMonth FROM dbo.tbl_src_date The problem I have is a visual one in that it all works but the output...

I am currently writing a report in SQL 2005 RS and have a problem with the format of a currency field. I am creating the report through the 'SQL Server Business Intelligence Development Studio' In the report preview (and live) it shows the prefix for the field to be $, and yet when I look at...

I have found out what was wrong. I had some =[fieldname].[value]/100 statements in some text boxes in Access which when imported into SQL 2005 confused these and marked them up as parameter fields. So problem solved until I post the next stupid question Regards

I posted a similar sort of question this a little while back although I was much greener then in 2005 than I am now(still green though, just not as green). I apologise if anyone classes this as a double post but it is not really. My problem is this. I have a MS Access 2003 database that hooks...

Damn, the one answer I did not want to hear. Thanks anyway! Regards

OK, I have just purchased the tutorial book Micorsoft SQL Server 2005 - Reporting Services (ISBN 0-07-226239-7). I have read it from the beginning to page 95 where I am now and it keeps referring to Galactic Delivery Services sample reports are going to be used for the rest of the book. Where...