Using MS SQL Server

Return valuse based on multiple "if exists' conditions (Advanced)
Hi All, Here is a more challenging question derived from my last one in this thread: http://groups.google.com/group/comp.databases.ms-sqlserver/browse_thread/thread/6d105333a6be4865?hl=en# Here is the table: state source price NY A 1 NY B 2 NY C 3 CA B 4 CA C 5 TX C 6 How can I show by sta... 7 Feb 2010 20:54

Return valuse based on multiple "if exists' statements
Hi All, Hope someone can help to solve this SQL question. I have the following table called '#temptable' (it is a temp table) source price state A 1 NY B 2 NY C 3 NY B 4 CA C 5 CA C 6 TX I need a SQL statement that performs the following pesudo code: if source A exists then (select * ... 7 Feb 2010 19:48

Installation Problem SQL Server 2005 + Windows 7
I've installed SQL Server 2005 on a dozen machines before but now I'm stumped trying to install on Windows 7. I have installed the app, then installed SP3 and keep getting the same problem: there are no SQL Server services running. Using the Surface area Configuration tool I cannot add any privileges because there ... 6 Feb 2010 15:12

Sum Only Top 20 Customers?
Hi...I need to return the Top 20 customers by 'Accounts Receivable Balance' (= FutureBal + Per1Bal + ... + Per5Bal + Misc_Creds + Unapplied) in the and then in the select list sum a calculated value, Sum(Val1 -Val), and another. I am stuck on how to use TOP in a WHERE Clause.. TIA LB ... 3 Feb 2010 17:23

Backups without data?
Our organization made a preliminary decision to store data for all new projects in a single database because there is some commonality between projects and some tables can be shared and relationships can be maintained within a single database and PK/FK relationships cannot span databases. For readability and a... 3 Feb 2010 18:31

RUNNING VBA IN AN SSIS PACKAGE
I am running an SSIS job manually that I am trying to automate. To automate the task the job needs to run daily and execute when a condition is met. The condition is based on a maintenance table: r_apd that looks as follows: FY PER CLSD_FL 2009 11, 1 2009 12 1 20... 2 Feb 2010 23:35

Using @variable in WHERE clause when querying a view is horrible. Inline function is fine. Why?
Thanks all for the feedback and ideas. I am going to try the de- parallelization option when I come up for air. I'll let you know what happens. Thanks, Bill ... 2 Feb 2010 14:38

Using @variable in WHERE clause when querying a view is horrible. Inline function is fine. Why?
bill (billmaclean1(a)gmail.com) writes: 1. SELECT * FROM <view> WHERE invoice_no = '01234'; Performs FABULOUSLY, instant response. 2. DECLARE @invoice_no nvarchar(20) = '01234'; SELECT * FROM <view> WHERE invoice_no = @invoice_no; Performs HORRIBLY, 80 seconds to return data. This is not ver... 2 Feb 2010 14:38

Using @variable in WHERE clause when querying a view is horrible. Inline function is fine. Why?
I much prefer examples and apologize that this question doesn't have one. I unfortunately can't post CREATE TABLE statements for this problem becuase the issue doesn't show up until you get lots of rows in the tables, and the tables themselves are quite convoluted in structure (commercial system, I can't do any... 2 Feb 2010 14:38

Can Someone please help me with my Computer stuff? 21692
I use the computer and the Net on a regular basis but I don't know a whole lot about it all, especially when it gets technical. I have an Acer Aspire AM5100-U5300A. I would like to speed this computer up, I would like a very good grasphics card without spending a fortune. Once I find out what I need I willo just go t... 27 Jan 2010 14:52