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.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
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...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
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...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
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...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 13, 2009 at 7:34 am
Check out this entry in BOL: http://msdn.microsoft.com/en-us/library/ms187901.aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
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...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
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"...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
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...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 12, 2009 at 12:43 pm
raviq123 (2/12/2009)
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 12, 2009 at 9:50 am
Look up PatIndex in BOL.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 12, 2009 at 9:48 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
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
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...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
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...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
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...
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
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....
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
February 12, 2009 at 8:57 am
Viewing 15 posts - 6,001 through 6,015 (of 9,643 total)