Viewing 15 posts - 2,401 through 2,415 (of 2,904 total)
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
Not sure on the warnings, but it sounds like the objects already exist and you are trying to drop something on top of them.
The error is because on the...
July 13, 2017 at 3:24 pm
Viewing 15 posts - 2,401 through 2,415 (of 2,904 total)