It sounds like you need to evaluate the individual date parts instead of the whole date. Something like this might work.

SELECT *

FROM #Month

WHERE DATEPART(dd, DateCreated) = DATEPART(dd, GetDate()) AND...

Srikanth,

Visio determines the relationships based on the primary/foreign key relationships that are in the database. Does the database that you are reverse engineering have those relationships? If...

In Visio, there is an option to reverse engineer a database. It works pretty well. I've never been a fan of the built-in database diagrams.

Greg

Another option is to pull those distinct values into their own table, basically a subset table, where the UNIQUEIDENTIFIER can be your primary key. Then you would have a...

The username needs to be in [brackets] like this:

GRANT EXEC ON dbo.plcStoredProc to [Domain\rptsqluser1]

Hope this helps,

Greg

You're right. CTEs are limited in that they are meant to be a one-time view that gets used immediately and then destroyed. To do what you intend, you...

CTEs can be used to replace derived tables, temporary tables or table variables. They tend to be more readable than using nested subqueries. In fact, they're very good...

JohnG (11/6/2008)

---

G² (11/6/2008)

---

It was my understanding that varchar(max) was meant to be a replacement to the text data type because of the issue that this question raises as well as...

It was my understanding that varchar(max) was meant to be a replacement to the text data type because of the issue that this question raises as well as other like:

Being...

I didn't see the answer in the link provided. I found this:

"The data collector stores data in two places: msdb and the management data warehouse."

On this page:

http://msdn.microsoft.com/en-us/library/bb677355.aspx

I'm confused as well. The question asked if the queries were the same, not if the result sets were the same. According to the link you supplied, the...

That's it. Thanks, Matt.

Greg

The second example that you gave is syntactically correct. The colors have to be in double quotes. For some reason, it seems like it's having an issue with...

If the other developer is connecting to your SQL Server, he can use the linked server that you created. If your intention is for him to connect to the...

This isn't a registerable DLL. But I've tried replacing it with no luck. It's doesn't seem to be this DLL specifically anyway. There's an underlying process that...