Hi Dom

I did a lot of Crystal reports from 3 to 2 years ago. Stored procedures were far away the best data source then, but I can't even remember the...

Trouble

Dom Horton (11/18/2010)

---

Hello,

Can anyone point me in the right direction? I'm after a 'self contained' select statement that will simply return a list of the last 30 days. It cannot...

SELECT Fridays = DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)

FROM (SELECT TOP 366 num = ROW_NUMBER() OVER(ORDER BY a.NAME)-1 FROM dbo.syscolumns a, dbo.syscolumns b) n

WHERE DATENAME(weekday, DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), n.num)) =...

Jack Corbett (11/17/2010)

---

For any chapter leaders that may not be on Twitter but are here, I started a thread on the chapter leaders forum about handling money, http://tinyurl.com/3ywxkbq. I'm...

jcrawf02 (11/17/2010)

---

Stefan Krzywicki (11/17/2010)

---

Brandie Tarvin (11/17/2010)

---

Stefan Krzywicki (11/17/2010)

---

I need to pick one blog to tart up as once I've done it on one of them, the others will be...

DROP TABLE #Employee

CREATE TABLE #Employee (ID INT, Name VARCHAR(10), Age INT, Country CHAR(2), Manager VARCHAR(10), Status CHAR(1));

INSERT INTO #Employee (ID, Name, Age, Country, Manager, Status)

SELECT 1,'Ravi',29,'IN','Anil','A' UNION ALL

SELECT 2,'Balaji',30,'IN','Siju','A' UNION...

jcrawf02 (11/16/2010)

---

At the...

Try running the batches between the GO statements individually. It worked for me, using the same script which you've just posted. Running the whole script raised a single error.

No idea, Wayne.

That really freaked me out, it came straight...

Richard Warr (11/16/2010)

---

WayneS (11/11/2010)

---

GilaMonster (11/11/2010)

---

WayneS (11/11/2010)

---

Well, I'm off to give my first presentation of "Comparing Tables Variables and Temporary Tables" to my UG tonight. Wish me good tidings, smooth talk,...

Is that all we are to you Paul? Wow!

Paul White NZ (11/16/2010)

---

Stuck on another problem, rather than bored exactly...but it comes to the same thing.

I even copy-and-pasted that guy's sample data into a text...

Paul White NZ (11/16/2010)

---

Greg Edwards-268690 (11/16/2010)

---

Paul White NZ (11/16/2010)

---

Hah! No, seriously then, I would have given up on that thread a good while ago....

Thanks guys. I'll leave him be, he's had enough prompting.