Viewing 15 posts - 2,401 through 2,415 (of 2,905 total)
It might just be me, but I think you are making this more complicated than it needs to be.
The way I would do it would be to have...
July 18, 2017 at 2:35 pm
I can answer some questions too. I'm kind of like Danny_Dba though in that there are some questions I wont' be able to answer.
I have been a DBA...
July 18, 2017 at 12:02 pm
I had not read that, but it was a fun read. I do...
July 17, 2017 at 2:18 pm
July 17, 2017 at 11:22 am
Offhand, I am not entirely sure. Mark would be a better one to ask, but looking at his code, I'm not sure there is a nice way to match that...
July 17, 2017 at 8:38 am
I am working on this, I am just hitting snags. Think I need to re-think how to solve this.
I have it mostly working until a second COMP shows up....
July 14, 2017 at 12:52 pm
I think first, I would figure out some way to order the data.
Next, I wouldn't assume that 2 weeks means that it is a new request. I would assume...
July 14, 2017 at 9:47 am
The most interesting project I've worked on recently was building up a dynamic OData web server. You give it the database name and it grabs all of the tables and...
July 14, 2017 at 8:44 am
July 14, 2017 at 8:15 am
Your primary key cannot contain nulls. There is no way around that.
You can join on a table that has no primary key with no problem though. The hard...
July 13, 2017 at 4:31 pm
I think your Dataset1 is set up odd.
The way I am reading that error is that your Dataset1 has the text "EXEC dbo.Dataset1", which I imagine is not what...
July 13, 2017 at 4:25 pm
You have no primary key on any of the tables? That design looks painful to deal with. There is no nice way to set up a foreign key constraint...
July 13, 2017 at 4:17 pm
Running your query with the SUM removed gets you 1 row. So your sub-query is not working as you expect.
Looking at your data set though, are you sure...
July 13, 2017 at 3:57 pm
Viewing 15 posts - 2,401 through 2,415 (of 2,905 total)