this thread should be closed couz we have same one here

Closed for discussing!

:hehe:

Also you have many little applications that you can decrypt easily store procedures!

SQL Decryptor is one of them ...try in Google

Have a nice decrypting!

Dugi

Yea, great simple code Jeff...very nice combination DATEDIFF and DATEADD functions to generate the results ...once again great simple-little code here!

:hehe::hehe::hehe:

Do some search inside this forum and you...

GilaMonster (3/4/2009)

---

Same as any complex code. Deconstruct (or build it) piece by piece.

Broken down for explanation only:

DECLARE @dt datetime

SET@dt = '2009/03/04'

DECLARE @TwoMonthsFromNow DATETIME

DECLARE @StartOfMonthAfterNext DATETIME

DECLARE @EndOfNextMonth DATETIME

SET @TwoMonthsFromNow = DATEADD(mm,2,@dt)

SET...

GilaMonster (3/4/2009)

---

If the request is indeed for the last day of the following month, rather use this. Manipulating datetime using Dateadd and datediff is notably faster than converting pieces to...

nitinpatel31 (3/4/2009)

---

Dugi (3/4/2009)

---

Sorry man, now is correct little mistake during the test of your script! So sorry! But ok the declaration is not correct for this forum ( SQL Server...

Never it happened here ... all users are free but must follow some rules ..simple don't do double post! 😛

nazaninahmady_sh (3/4/2009)

---

hello;

i have a query: Query1

SELECT top 3 Error_ID,count(Error_ID),Kind

FROM Table_1

GROUP BY Error_ID,Kind

i have another table wich...

The_SQL_DBA (3/4/2009)

---

I have a table with a field called 'CallEntry' as Datetime.

I need to generate a report everyday during fixed time from 7 am to 2 pm. How do I...

Please add more explanation about your problem or read the article, link of this article is in my signature!

:w00t:

nitinpatel31 (3/4/2009)

---

Dugi (3/4/2009)[hr

Declaration of your variable here is wrong we are not in SQL Server 2008, please check the forum we are SQL Server 2000! So your code here will...

Again starting from beginning ...no it is not allowed (double posts)!

haahhahaahahah yea the code looks very nice with them ...hahahaa great job Grant! Little joke here :hehe::hehe::hehe:

Declaration of your variable...