Viewing 15 posts - 6,001 through 6,015 (of 9,643 total)
Have you tried creating the same report but hard-code the parameter in the query and see if you get the "junk" characters. Perhaps they are in the data.
February 13, 2009 at 8:07 am
I think you are going about this backwards. I don't think that you can add anything to the default Reporting Services web site other than reports. If you...
February 13, 2009 at 8:03 am
Yes, I also get this error, but it is simple to fix. Right-Click on your VFP source and select Show Advanced Properties. Then got to the COmponent Properties...
February 13, 2009 at 7:42 am
Another way to get an empty result set back is to issue the Set FMTONLY ON command at the start of the batch. Just remember to set it back...
February 13, 2009 at 7:34 am
Check out this entry in BOL: http://msdn.microsoft.com/en-us/library/ms187901.aspx
February 13, 2009 at 6:21 am
There is no disabled users in a database. There may be users with no permissions or with permissions explicitly denied, but you can't disable a database user, you disable...
February 12, 2009 at 1:18 pm
Yes it is poorly formed xml. I think in order to be formed the way you want the XML should be like this:
{questionset}
{question vo="" id="1"...
February 12, 2009 at 1:02 pm
Check out the IsDate() function in BOL.
I have had this issue in a data import where data was incorrectly entered like '12-31-0007' which is an invalid smalldatetime and...
February 12, 2009 at 12:43 pm
raviq123 (2/12/2009)
February 12, 2009 at 9:50 am
I prefer using the query plan as well, but you can also use the index related DMV's to help as well. Check out this in BOL: http://msdn.microsoft.com/en-us/library/ms187974.aspx
February 12, 2009 at 9:42 am
Are you really running SQL 7 or 2000? If you are then sys.database_principals does not exist.
In SQL Server 2005 ff you want to check to see if...
February 12, 2009 at 9:40 am
The first thing you need to do is look at the query plans for these queries. Until you see those you can't really get a feel for any changes...
February 12, 2009 at 9:26 am
It is certainly going to vary from company to company and industry to industry. It will also vary based on the abilities of the person. What may take...
February 12, 2009 at 9:06 am
Just to expand on what antonio said. By having the criteria plnt_deleted is null in the WHERE clause essentially changes your LEFT OUTER JOIN to an INNER JOIN....
February 12, 2009 at 8:57 am
Viewing 15 posts - 6,001 through 6,015 (of 9,643 total)