Outlaw

Theory

Soda

Pestle

It can be done but I'm not entirely sure what you want. Are the LastName, FirstName and EmployeeEmailAddress' coming from a query? Can you give us a bit...

Are there any...

You're welcome. It's not actually something I've got personal experience of using but several of the reports our company run use them. I'm waiting for a chance to...

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...