Viewing 15 posts - 2,836 through 2,850 (of 3,396 total)
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
What's totally odd is that MS does that with their examples of CTEs - all of them begin with a semi-colon, which was really weird to me. Gotta love...
July 22, 2014 at 9:04 am
Sounds like a good time to use Integration Services. If you created a package, you could then use SQL Agent to run the package you created on some interval...
July 17, 2014 at 7:49 pm
If you disallow nulls, the checkbox will not be displayed. But you want to allow nulls but still hide it, right?
July 14, 2014 at 2:29 pm
I need to count the number of times the supplier name is used but only display each supplier name once.
If you imported this from Access, you probably have some...
July 14, 2014 at 2:17 pm
so if you create the standard hierarchy and get a level, filter for the difference in Levels = 2 for the non-CEO types, and for the CEO, set the levels...
July 14, 2014 at 10:03 am
I don't think you can do that in a report. I would think you would need something like a .NET GUI to do that, because SSRS generates a read-only...
July 7, 2014 at 1:07 pm
TG-
I learned to do it by using a big whiteboard. If you need to test your designs by loading some data and then trying to query, you could use SQL...
July 7, 2014 at 1:06 pm
Eliza,
<cheat sheet>Region | Yr1 - Sales | Yr2 - Sales | Yr3 - Sales | Yr1 - Numbers | Yr2 Numbers | Yr3 - Numbers
What if you had a tablix...
July 7, 2014 at 12:06 pm
Viewing 15 posts - 2,836 through 2,850 (of 3,396 total)