I'm firmly in the horses for courses camp here, I can see when you can get away with natural/business key as an Identity and also appreciate that at times you...

AS GSquared said change the OR to an AND and it will work.

In this case 'FON_smp1_D062012_1_' Passes the Second clause as it doesnt have _2_ in the name, the second...

Can you provide some sample data in regards to file names and expected results.

sathiyan00 (9/17/2012)

---

Hi friends,

I have problem in foreach loop.foreach loop doesn't show the for each file enumerator and foreach item enumerator...

When you say data warehouse do you mean a Kimbal Star/snowflake Schema?

Depending on the original developer you may find PK's but no FK's, although its not unheard of to...

One tool you might want to look at is Pragmatic works BI Documenter http://pragmaticworks.com/Products/BI-Documenter.aspx

It isnt too bad, and you can download a free 14 day evaluation.

We had mixed results in...

Well theres a possible typo in your code for the DATEMNAME(wk,DateValue)=29 which is repeated twice.

I dont know if this is by design or not, but it seems odd that...

I've seen the same thing in regards to ##tables.

I dont know its good to have those types of discussions.

Thanks Eugine, as I said I thought they were persisted even after the process that created them was closed,

I was actually confused with creating a specific fixed table,Eg Create...

I thought the ## temp tables persisted until they were explicitly dropped from the TempDb, or the SQL service was restarted.

ananda.murugesan (9/17/2012)

---

This data and execute statement working fine in SSMS.

whenever call application side working fine at first time, calling next time error throwing like "'Arithmetic overflow error converting numeric... "

Insert...

If you're new to data warehousing then books by Ralph Kimball (Data Warehousing Toolkit series by Wiley) and Bill inmon are good reads, though a little dry, but good for...

ChrisM@Work (9/17/2012)

---

ananda.murugesan (9/17/2012)

---

DDL statements...

exec ChangeTable 'SIL_TRAN_H','Tran_Code|Ref_No|Modify_By|Modify_Dt','1003|2012083014645|37100666|17 Sep 2012 12:25:45'

exec ChangeTable 'SIL_TRAN_H','Tran_Code|Ref_No|Modify_By|Modify_Dt','1004|2012083014645|37100666|17 Sep 2012 12:25:45'

exec ChangeTable 'SIL_TRAN_H','Tran_Code|Ref_No|Modify_By|Modify_Dt','1005|2012083014645|37100666|17 Sep 2012 12:25:45'

exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1003|2012083014645|1|1|4DA-TE-304A/B/C'

exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1003|2012083014645|1|2|30 Aug 2012-14645'

exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1003|2012083014645|1|3|JGDTA'

exec ChangeTable 'SIL_TRAN_D','Tran_Code|Ref_No|Rec_no|column_id|column_value','1003|2012083014645|1|4|FCC/PRU'

exec ChangeTable...

Is...

I'm guessing that the columns/values have some how manged to get out of sync or theres a rogue value that is larger than the scope of the associated columns Numeric...