Why do need to make a new copy of the same table every single day? It would seem to be a lot less headache (and clutter) to add a column...

2sbhagat (4/9/2015)

---

3 tables : 1. POS (Material, Customer, day, POS) 2. Material (Material, MATL_TYPE, MATL_GROUP, MKTG_LABEL_DESC, MKTG_CATG) 3. Customer (customer, DMA, DIVISion, state, country, corp_cust, DMA_DESC)

?Using join on customer and...

It won't display here. Says the image contains errors. :w00t:

Somebody with more SSIS knowledge than me (which isn't hard to accomplish) want to lend a hand?

http://www.sqlservercentral.com/Forums/Topic1675814-392-1.aspx

This sounds like a job for SSIS and I can barely spell it. Let me call in some reinforcements.

Marcus Farrugia (4/9/2015)

---

Hi Sean, I am receiving data from many different types of file sources. The data from the each source is being transformed into a comma delimited string...

This scream of poor design to me. How can you not know what columns are in your table? If you go down this path I don't think there is any...

Zohaib Anwar (4/9/2015)

---

I am trying to do it with CTE as mentioned above but not sure why it is not working. I haven't join CTE any where does that work...

Zohaib Anwar (4/9/2015)

---

Thanks for the reply Sean

Can I do it following way ??

WITH ACOALERTCTE

AS (

SELECT a.lastprdate

,a.lastprtime

FROM acoalert a

WHERE a.coalertid = 3000

)

SELECT TOP 1000 f.foordno AS "Order #"

,f.foprogno AS "Program #"

,f.alertmssg...

Zohaib Anwar (4/9/2015)

---

I’m trying to do a SQL statement in our application and having some issues.

What I’m struggling with is a compare on the alertmsgdt (Date field) + alertmsgtm...

You might want to test your script before you post them.

ProjectAssignment table inserts.

Msg 213, Level 16, State 1, Line 5

Column name or number of supplied values does not match table...

Just a suggestion. I would avoid using ambiguous parameter names. @p1, @p2 are meaningless. Give them some context so that maintenance on this down the road is a lot simpler....

They both...

I suspect this is because the ISDATE function has been around since before we had the date datatype and the values you posted here are not valid as datetime. Once...

MadAdmin (4/7/2015)

---

Sean Lange (4/7/2015)

---

MadAdmin (4/7/2015)

---

Read committed also has it's issues.

It is possible to read the same row twice with read committed, once before a change, then after the change.

All isolation...