What you want to do is called Cascading Parameters and if you have a look at this article[/url] it'll explain it better than I can.

You're welcome. I think we've...

INSERT INTO dbo.ACCTING_ADJUST (stlmnt_instr_id, instr_id, postdate, postype, gl_num, acct_num, crncy, usdamt,

cost_cntr)

SELECT '', 'SB9104520001', '2010-05-24', 'GLC', '8039581', NULL, 'USD', '40122.00', '4251'

UNION ALL

SELECT '', 'SB9104520001', '2010-05-24', 'GLD', '8058581', NULL There's a comma...

Could you post some sample data please? It will make it much easier to help if we can see the exact table format and the query you're running. ...

Thanks once again. I've got one of Lynn's articles about dates saved, I've got one by Jeff Moden and I've got a really useful article about converts that I...

Thanks Chris. I got my date formats well and truly mixed up there! I'd put date in as the target but because I mis-read the styles it gave...

I'm guessing a bit here but is this something like what you're after?

create table #mytable

(

Locationvarchar(20)

,shipqtyint

,late_qtyint

,po_datevarchar(10)

)

insert into #mytable (Location,shipqty,late_qty,po_date)

select 'Home',2,3,'02/24/2012' union all

select 'Town',2,5,'01/20/2012' union all

select 'City',5,5,'01/20/2012' union all

select 'Home',4,5,'01/20/2012' union all

select...

How is the date formatted as varchar? Is it in words or 'yyyy-mm-dd', 'dd-mm-yyyy' or 'mm-dd-yyyy' or some variation of that? If you could post some sample data...

We've still got a lot of guesswork to do to help out, and that's what we're here to do. If you read this article and post some samples like...

Could you post some sample data and your expected results please? It will make it a lot easier to answer your questions.

gpascanu (4/11/2014)

I have the following values in a Float column

266.5

280.98

127.558

How do I set the precision in a SELECT? I need to display two digits after the decimal point. My problem...

Charm

Stuart beat me to it!

Club

BWFC (4/10/2014)

With the Numeric data type, the first digit in the bracket gives the maximum number of digits for the complete figure and the second is the maximum number of digits...

Ice-pop