you can get in if you are A an administrator on the box and you selected mixed or windows authentication mode during install. if you selected something other then...

k I am sure there is a better solution for this that would require less code and no temp tables but this works at anyrate.

declare @t table

(PartNum varchar(3), ServerA char(1),ServerB...

you can certainly veiw all of those in SSMS. as for getting a description you really would have to look at each one and see what it does....

get the rows affected by what?

I have a SP as follows I have been running this for a while. It is combined with a few other scripts that run on a daily basis and...

Do you have a question about that or are you just makeing a random comment?

your case statement is not structured quite right. Try the below it should work fine.

SELECT

CASE

WHEN i is NULL THEN 'Is Null' -- This will never...

I don't think this is a yes or a no answer. There are times when I can achieve something very effectivly though a stored procedure and there are also...

if you change it to datetime and then change your insert to inlcude the nano seconds it will break.

that is why the convert was needed. When you instert 06/22/10...

falgunoza,

If the data was stored as smalldatetime I doubt he would be having this problem to start with. It is fairly typical to have to do a convert in...

you had one two many criteria in your group by also I would move the having to a where clause.

declare @table table (AdId int, class int, Origdate datetime,totalpaid numeric (10,2))

insert...

I am not sure what you mean by convienant but the tools are far more powerful than dts.

I also understand about it being a simple job I am...

move the date parameter to a where clause and that should take care of it.

SELECT DISTINCT A.Class,

CAST( CONVERT( CHAR(8), A.Origdate, 112) AS DATETIME),

SUM(A.totalpaid) As AmtPaid

FROM dbo.ad A

where CAST( CONVERT( CHAR(8),A.Origdate,...

All those in favor of screeaming say I

Knock

The screaming passes!

I think that depends on how much data you are copying and what is going on in yoru servers. for my money though I would strongly encourage you to write...