Msg 207, Level 16, State 1, Line 1

Invalid column name 'pmDescription'.

Msg 207, Level 16, State 1, Line 1

Invalid column name 'smDescription'.

Msg 209, Level 16, State 1, Line 1

Ambiguous column name...

crazy_new (6/19/2014)

---

I have tested you code, it returns more than one row and then the B_L_SEQ_Number doesn't increment. That's why I wrote mine to return only one at a time,...

crazy_new (6/19/2014)

---

I'll try this code now thanks...If I may ask a stupid question that would make future queries easier for everyone, how do I post a block with the code...

you can check the following links

http://www.mssqltips.com/sqlservertip/3141/importing-xml-documents-using-sql-server-integration-services/

http://msdn.microsoft.com/en-us/library/ms191184.aspx

http://www.mssqltips.com/sqlservertip/2899/importing-and-processing-data-from-xml-files-into-sql-server-tables/

you need to convert your comparison dates instead of converting the date in the table

Like this:

declare @a varchar(12) = '14-03-2013'

select

@a, convert(date,substring(@a,charindex('-',@a)+1,2)+'/'+

left(@a,charindex('-',@a)-1)+'/'+

right(@a,charindex('-',reverse(@a))-1))

Following is the understanding

Cat_Transaction.ID should not be the part of the budget_line.Ref_Number Per Case_ID. all these rows needed to inserted into the budget_Line table.

if so then following is the...

First of all how can this query will know ? the value will be 121

SELECT

bl.CASE_ID

FROM

Patricia.dbo.BUDGET_LINE bl

JOIN cat_transaction ct ON bl.EXT_REFERENCE = ct.id

WHERE

ct.CASE_ID = bl.CASE_ID

what is your logic to get this...

Nice point mentioned by GilaMonster

but nice question Andy. Thanks for sharing !!!

You need to check what select query is returning. Select query should only return one result set. if its more then one then you will get this issue.

one other possibility...

is it me or ...

answer however, taught me a new thing, never work on SQL Azure 🙂

the trouble is that each iteration does the select statement and therfore it works really s-l-o-w

I thoght about command line Bulk Copy Program (BCP) but i'm not sure it suits...

do you need the old data, that is if you have created a file 1009.txt before,

in the new file do u need the old data + New data or...

Hmmmm you can set in sql server, but in mysql u cannot.

this might help you.

http://stackoverflow.com/questions/1202919/mysql-dayofweek-my-week-begins-with-monday

lclaassen (5/22/2014)

---

Hi All,

I'm just a little confused, when running the query

SELECT WEEKDAY(CURDATE( )) FROM dual

the current date being Friday, 23 May 2014, the weekday number returned is 4. Correct...

just voted, thanks for sharing the information Steve.