I say it all...

change the cd.* to a list of the actual columns desired.

your status, I'm assuming is just one more field based on a case statement; you were not explicit on the...

it's the * for the column list.

there's no problem running that statement all by itself, but if ytry to create a VIEW of it, you'll have problems because the emp_id...

here's some consumable data to help look at the problem.

i think in your example you said one column was c_date, but int he SQL you referenced clocking_date; i added both...

then it is probably owned by a different schema than dbo, and needs to be identified by that.

what is the real, exact error message?

maybe if you have a user named...

if it literally says 'table name' , with a space, you'll need to wrap any name with spaces in double quotes or brackets:

SELECT * from [My Table Name] WHERE [First...

i tried creating a brand new post, and immediately deleting it.

http://www.sqlservercentral.com/Forums/Topic718433-433-1.aspx

i was unable to delete it.

i think if you create a brand new post, you can delete it , but if it's a reply to a post, instant-notification emails might have foreign keys to your...

more details from you before anyone can help; it's all specific to YOUR network.

what is the address of yout SSRS server? are you connecting to a .com address or a...

you can also establish a regualr ADODB connection and connect to the server, without having any SQL client tools installed. there are a lot sample apss that can do that...

you'll need to handle errors a s a separate email, something like this:

DECLARE @Results int

EXEC @Results = msdb.dbo.sp_send_dbmail

@profile_name = 'AdventureWorks Administrator',

@recipients = 'danw@Adventure-Works.com',

@body='Whatever the...

this was about the only thing that made sense to me;

SELECT

ID,

[month],

[year],

CASE

WHEN month(getdate()) IN...

this is actually a question for Network Solutions...if they expose their SQL Server to allow you to connect directly, then yes.

If it is hidden behind a firewall, then no.

I have...

the secret is to join the table against a copy of itself.

this example is most of the way there...the only problem is that it returns more than one row.

that can...

mcginn (5/14/2009)

---

I have a table where each row has a unique timestamp column. In many cases other then the timestamp column, all of the other values are dups of another...