As a general rule if you have to get the data from sql you are probably best served by using a select.

select @myVal = myVal from myTable where myPrimaryKey =...

I can get to that article but I wouldn't use it as a reference for anything current. It was written when 2005 was a baby and the tests were all...

alen teplitsky (7/15/2011)

---

we have a database with queries almost identical to the above. it's a nightmare a few times a year because when there is a big change in data...

The won't work because create view must be the first statement in a batch. What is wrong with dropping and recreating it? That would at least ensure that your view...

err...that won't actually get what you need. :blush:

something like this should work though.

if @company is null

SELECT * FROM test WHERE YEAR(date) = @year AND MONTH(date) =...

You could just change your select line like this.

SELECT * FROM test WHERE YEAR(date) = @year AND MONTH(date) = @month AND company LIKE '%' + isnull(@company, '') + '%'

This really won't let you get an accurate count. It will work until you delete a record. If you want an...

It does seem that the MS documentation is all over the place. There are places where they state it is only available in Enterprise and in other locations say Enterprise...

Would be easier with some ddl and sample data. I tossed this together which is really sparse but should show you an example of how to do this.

create table #test

(

ClientID...

Paul, the QotD-sneak-o-meter comment was hysterical. Thanks for clarifying what is being deprecated.

Steve, the question was a good one and taught lots of us about an aspect that many...

According to MSDN you probably have a datatype mismatch. If you have really big or small numbers in Access they may not fit in a float. The direct relation is...

I also got this wrong because I chose 1 -64 processors. This argument/discussion can go either way really. More importantly this feature is deprecated according to BOL. Good question about...

I hear you on automated tools. The authors of said tool should be ashamed!!! That is just plain lazy and causes their clients untold amount of anguish.

Seems to me like it is pretty hard to guess the performance of a new system by running sample queries that may or may not be relevant to the new...

Can't tell you how many time I have done that myself. I just wanted to clarify to avoid confusion for the OP. :hehe: