Criminals

duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1579265-1044-1.aspx

duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1579265-1044-1.aspx

Miser

I understand you have Access pulling data from Oracle. But then you mention wanting to do this from sql...

azhar.iqbal499 (6/10/2014)

---

when I run below query I got Error of Arithmetic overflow error converting numeric to data type numeric

declare @a numeric(16,4)

set @a=99362600999900.0000

the 99362600999900 value before numeric is 14 and variable...

clifford.sweeney (6/10/2014)

---

That's the question. Everything I do is in Access. I don't write any SQL at all. To produce a listing of all our customers, I have to write some...

clifford.sweeney (6/10/2014)

---

Sorry if I wasn't clear enough: The 1st Access database has a number of queries and macro which interrogates our oracle database. The 2nd Access database queries the results...

abhishekcs.patil (6/9/2014)

---

Hi,

What am trying to do is, am dynamically creating a CSV template using SQL Stored procdure, result of the SP is shown below

SlNo CM_Name...

BlackIceAngel (6/10/2014)

---

Hi

I've found a solution but would still like to learn how to optimize it.

This is what's worked for me. I've changed the date as you suggested and for...

TheSQLGuru (6/9/2014)

---

Can you tell us what you were trying to solve with this?

I note you get the same output with this:

SELECT

Country ,

MAX(CustID) ...

vasuarjula (6/9/2014)

---

Hi,

I have a procedure where after processing, i am required to send multiple message to calling application.

For ex:

create procedure test as

(@a as int,

@b-2 as int

@c as int )

/*

some...

abhishekcs.patil (6/9/2014)

---

Hi All,

I want to generate dynamic temp table so, from one strored procedure am getting an some feilds as shown below

CM_id,CM_Name,[Transaction_Month],[Transaction_Year],''[Invoice raised date],''[Payment Received date],''[Payout date],''[Payroll lock date]

for i...

SQLKnitter (6/9/2014)

---

Copying the data in without the headers seems to be the answer, since there was a text field immediately above the pasted data. The odd thing is that I...

BlackIceAngel (6/9/2014)

---

Good Day

This is my SQL Query. Everything after the 3rd line is required due to dependancies.

SELECT Customer.EMail, Amount=SUM(ABS((SELECT Top 1 Amount+VATAmount FROM Kitty WITH(NOLOCK)

Where Kitty.ResID=FreeWinners.ResID AND TransType='PZ')))

FROM FreeWinners...