stricknyn (1/8/2009)

---

Hello everyone,

Ok this is weird. When I run the statement below it is returning 1. Can someone explain to me why this is returning 1?

select datediff(year, '2008-01-09...

Didn't someone write an article that talked about how DATEDIFF and DATEADD worked? I can't find one on SSC, so it may have been an article on a different...

hmmm, got it you do

I don't have time at the moment to actually test your code, but a quick check of the code looks good. I'll try to double...

In a way, it reminds me of our problem which actually turned out to be a fairly large UNINDEXED table. The problem I had was that the table that...

Have you read the Article 'Solving the "Running Totals" & "Ordinal Rank" Problems in SS 2K/2K5'? It is the second link in my signature block below. If you...

srkreddy8,

As ambiguous as your questions may have been, you should really have left them in the thread. By removing the questions you simply have confused anyone else that may...

hmmm, this question gone too it seems....

hmmm, sense PM should on its way be....

Remember exactly, can't but think some like this:

check if an item exists in the table, if yes update it, else insert it.

After talking with our PeopleSoft Admin regarding the issues we had experienced and did to try to correct our issue, and seeing the results of the query I asked you...

Paul Perez (1/8/2009)

---

I'm doing a simple variable assignment from a "between quotes" text to nvarchar and I keep getting the following error:

Msg 257, Level 16, State 3, Line 1

Implicit conversion...

hmmm, hijacked this thread I think, back to topic I think we should...

hmmm, avatar I too have found

I have to second Seth on reading the article on Running Totals (also linked in my sig block). The method described in the article can update a 1,000,000 row...

Okay, I will look into that tomorrow morning (well, it is almost tomorrow morning now for me) when I get into work. I'll let you know what I find.

Thanks

Again, you really need to read this article: http://www.sqlservercentral.com/articles/Best+Practices/61537/

You only THINK you need to use a cursor at this moment. If you provide the information in the format recommended...