da -

since you are a self-admitted beginner, here's another technique that you may want to try here: use the search feature of this site - enter your keyword...

Is there a reason NOT to use two separate variables and place the view create in its own variable? Or do you end up then having the view placed...

As a general rule, unless there were features in 6.5 that were deprecated in 7 and then dropped in 2000, you run the risk of using deprecated features from...

Congrats! The explicit sense of 'sharing'.

One further note: 'C:\docume~1\...' is backwards commpatibility on directory naming in command lines to a time when each directory or file was limited...

Well, did you happen to ask the developer what he changed between the last time and this time he ran the query? Capturing the history after the fact -...

'Consider' is not the same term as 'implement'. In short, unless you have a very small usage, you need to open the question of 32 vs 64.

When dealing with...

Ryan - It was NEVER clear to me that in your initial posts you were NOT talking about system tables. By failing to give even one example of the...

Server is slow?  or query is slow?  Provide examples of code, information on keys, etc.  Probably either humongous table size or improperly formed query.  outer cross joins will require tons...

There are four parts to a fully qualified table name in SQL Server:

server, owner, database, and table.

In multiple threads on this forum, you will often see at least 3 of...

2005 and 2000 can coexist on the same box.  If you were installing the software, then, yes, you were (are?) impatient.  It's only after you've installed SS 2k5 that you can...

Can you provide more details? The more information you provide us, the faster and more effective we can reply.

Question was asked and answered after you posted, in a different thread:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=150&messageid=389554

And you can't use the query as a table, because? (I'm asking this seriously - I've not used SSRS at all, but the need for my knowing it is...

Finding the quartile marks for top and bottom quartile simply requires using either count(*) / 4 OR (3 * count(*)/4) instead of count(*)/2. and the work is done, no?

Jeff - I don't understand why you would NOT expect an arithmetic process to be faster than a string process. i would expect that all the date functions are...