Steve Jones - Editor (1/28/2009)

---

I'll admit to using Whizbang at some point in my life, but not regularly. At least I hope not.

I thought about posting a diff of the...

Unfortunately my company cut corners and we had to make due with the standard fiber-optic laser beam assemblers. They just wouldn't spring for the whizbang model. Stinks.

We're beginning a project to ASSESS the upgrade from 2000 to 2008 this year. I wouldn't sweat your skills being out of date. SQL Server 2000 is still going very...

kiman_keren (1/28/2009)

---

for question number 1: ow. i will try...

for question number 2: yup, i wanna know that.

for question number 3: wow. using clustered index for non clustered index... am i...

And you might want to talk to your instructor. That's a really poor example to show proper database use. Two tables with the same names, columns and data types? Serious...

I didn't get to see it. I wish I had. The discussion about it, prior to the plagiarism exposure, was pretty critical.

Sorry, I meant the example code. The explanation clearly mentioned two tables.

Yeah, I would have been curious to hear his side of the story too.

But I wouldn't throw rocks because he had few points when he posted an article. I posted...

Oops. Right. Forgot the N in front of the strings... sorry.

You can't pass parameters as column names, that's the error you're no doubt getting. To do something like this, you need to build the string and execute it:

DECLARE @y nvarchar(50)...

kiman_keren (1/28/2009)

---

Hello all,

i have some questions:

1. what's the different between clustered and non clustered? i've got a lot of answer in google, but i wanna know from this forum.

2. how...

KB (1/27/2009)

---

I have an insert statement and an update statement as follows:

INSERT INTO TableA

(

ColA1,

...

The unique constraint will keep duplicates from getting in. I'd suggest, in order to reduce contention, that you perform the INSERT statement without the pre-check and then check that the...

It looks like you're trying to return a list and a set of counts. You can do this without a cursor:

SELECT [name]

,COUNT([name])

FROM #DISTINCTC

GROUP BY [name]

You might want to pick up...

mbrady5 (1/27/2009)

---

Hello, I need help formulating the following.....

I would like to join cwm_cust table to cwm_cut_upload in the following query.. That part I am good with. What I cannot figure...