Viewing 15 posts - 2,926 through 2,940 (of 3,501 total)
Did you specify a collation on one or more columns in one of your tables? It sounds like you're trying to get the collations to match, and they don't.
August 13, 2014 at 1:19 am
This exercise is a lot easier to understand if you have some data to work with. It's easier to see repeating fields if you have a table structure. ...
August 12, 2014 at 10:21 pm
sounds like you need to union one result to another so that they end up in the same dataset.
August 11, 2014 at 4:19 pm
Jason Selburg wrote something that does that:
http://db-pub.com/news-10013929/data-driven-subscriptions-in-sql-rs-standard.html
August 9, 2014 at 12:53 am
Ideally, you would have someone fix the dirty data for you, and your problems would go away. But if that's not an option, you could create a calculated field...
August 7, 2014 at 9:46 pm
Welcome!,
Did a little digging around both on here and the internet and found a couple of really good examples showing how to do exactly what you are asking about.
Kathi Kellenberger's...
August 7, 2014 at 8:46 pm
First things first - remove the NOLOCK hints. It's not a magic "accelerate my query" command. Do you get correct answers if you do that?
August 7, 2014 at 2:59 pm
Looks like your example data is wrong. Without an explanation of the rules, this is as close as I could get:
SELECT x.*, y.productID
FROM
(SELECT xState
, MAX(Sales) AS MaxSales
FROM salesData
GROUP BY...
August 6, 2014 at 4:05 pm
How can you get to 3NF if you don't go through 1NF and 2NF first? Interesting concept.
Here's a pretty easy primer on Normal Forms. If you apply them...
August 5, 2014 at 3:13 pm
Help us help you. Could you post some dummy data? Just something for us to start with instead of starting from scratch?
July 30, 2014 at 9:17 pm
If you make the parameter get its values from a dataset, it's pretty easy.
Right-click the parameter you want to show as a value list, go to Parameter Properties.
Select "Get values...
July 29, 2014 at 6:20 pm
I think you mean a tablix, but anyway...
If you click on one of two right columns (one of the Hours ones), you can right-click and from the context menu dropdown,...
July 29, 2014 at 5:25 pm
amadeu_j (7/29/2014)
need date for weeks, beginning the week and end of week format. ie for week 1 week 2 week ... 52. how do I?
Could you give an example of...
July 29, 2014 at 4:58 pm
If you post proper CREATE TABLE scripts and INSERT scripts to populate your table(s), you will probably get an answer...
July 25, 2014 at 9:39 pm
Viewing 15 posts - 2,926 through 2,940 (of 3,501 total)