Viewing 15 posts - 2,911 through 2,925 (of 3,480 total)
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
What do (Name, Project, Date) represent? Some event? If you explain that part, we can help you sort out the design of your table. (As Jeff mentioned, are you...
July 23, 2014 at 11:12 pm
Problem:
-> I'm checking if the record exist in Contact table or not. If it exist then I will insert into employee table else I will insert into contact table then...
July 23, 2014 at 10:32 pm
I vote for normalizing too... then this query becomes trivial. Been down the unnormalized path once before and it was not a place I want to go again. ...
July 23, 2014 at 5:57 pm
The way I used to do it was to pull it from SQL Server using Access, but if you can push it from SQL Server, you can create a job...
July 23, 2014 at 9:50 am
How do you retrieve the data in SQL Server that you want? And how often do you need to insert it?
July 23, 2014 at 9:40 am
What if you pull (from Access) instead of push (from SQL Server)? The easiest way, if it's a one-off, might be to create a stored procedure and run it...
July 23, 2014 at 9:30 am
Viewing 15 posts - 2,911 through 2,925 (of 3,480 total)