hmmm, no. Several starwars films I saw...

Peso (1/9/2009)

---

Lynn Pettis (1/8/2009)

---

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...

Sorry, had a few meetings, and then had to leave work for another meeting (non-work related). Let us know if that helps your performance issue.

Also, if you copy the...

Amazing, isn't it? Three days ago I scraping ice off my car, today I walked at lunch without a jacket!

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...