In your CALL query, you need to put an actual ? instead of the word Year so that Excel Query knows it's a parameter. The first time you do...

Sounds about right 😉

I worked in the IT department of a rental car company...

I think there is a very specific distinction...

I still see 2 foreign keys from the fact to Account table, and 2 foreign keys from the fact to Broker table. In a post on 11/16 you said...

DouglasH (11/21/2016)

---

Run both through SQL Profiler and compare.

Things to look out for : Differences in connection settings, parameter sniffing, parameter conversion issues. Also maybe you could post your .net code...

I'd...

I've found this technique to work in Excel 2013:

http://codebyjoshua.blogspot.com/2012/01/get-data-from-sql-server-stored.html

for the command text use the format:

{CALL dbname.dbo.GetData (?)}

in the Parameters dialog, there's an option to "Get the value from the following...

etl2016 (11/18/2016)

---

etl2016 (11/18/2016)

---

To quantify further, SELECT X, Y, z, count (*) GROUP BY X, Y, Z HAVING COUNT (*) = 1 should give...

tschuler-738392 (11/18/2016)

---

...

from docsadm.client as c

left join docsadm.matter as m

on c.client_id = m.client_id

where c.client_name <> ''

and m.matter_name <> ''

and c.client_id not like '%.%'

order by c.client_id

docsadm.client table columns client_name and client_id...

logon triggers can be found in sys.server_triggers

SELECT * from sys.server_triggers where name LIKE '%connection_limit%';

JohnNash (11/17/2016)

---

Hello All

I have created a windows service which will trigger a sql server agent job when a specific file arrives in to the file server folder, so that the...

in express edition, you still have access to things like BCP, SQLCMD, the BULK INSERT command, etc, so there are options. The challenging part would be dealing with 4...

Gaja (11/17/2016)

---

Hi All,

I am inserting data from customer table to fact_customer

customer table has duplicate records with Customer ids but some of columns having different data i want to combine this...

kevin.obrien 66193 (11/16/2016)

---

The question to the OP is ... are CounterpartyAccountKey and GenevaAccountKey mutualy exclusive? It appears to me from the reading that they may very well be (normally a...

to find out what's hurting your CPU is a different problem, you'll probably want to examine the dynamic management views to see what queries are causing the most CPU, such...