So I finally got there with some pain around data typing. I know my solution is not the best but it is working for me and I can acheive...

If any one is reading this I think I now realise where I've got it wrong, putting the quotes around the variable names. Unfortunately its now 10 pm down...

Thanks Craig,

I am now getting data typeing errors and it is the one thing that really frustrates me with integration into databases. I love the data types in DB's...

Koen and Phil (and anybody else who is able and willing to help),

I am trying and it is really showing my lack of knowledge, I have a book on order...

Woops, clicked the bottom one first hence two thanks ticks. That's just so easy I can't believe it. I knew that SSIS was built to help dummies like...

Have a look into the information_schema view.

This one will give you a list

select *

from information_schema.table_constraints

and you can glean extra information from other information_schema views for the constraint_name.

I agree with Jeff, too often in the past I became reliant on something that was then taken away or was not available in a move/restructure. So I've come...

Very nice, beautifully formatted, simple to understand and hopefully the op will say meats needs perfectly

How does this go?

select a.*

from #memberof a

inner join (select

from #memberof

...

You are missing the DDL so I am assuming your datestamp column is of datetime data type.

You will need to use between as wild cards don't work well with dates.

So...

Sqlraider (11/7/2013)

---

If you have fancy window dressing(s) but a weak foundation because you wanted to move into your house "yesterday". The foundation will crumble sooner. The house will be on...

Check the data types of the fields you are comparing, maybe the join fields. I'd focus on "G.Matter = DM.C2ALIAS" and "DM.DOCNUM+'-'+G.USER_GP_ID " sections of your query first.

What is...

Select <Field List>

Into <New Table Name>

From <Source table>

But why would you want to split things out, there is the issue that the new data will not be updated when their...

You could select the process from the information_schema.routines view then loop through them with a drop procedure TSQL statement.

Edit. Additional details.

Then just select out the procedure details from the...

Martin,

Make sure that there is a primary key defined on the column you are connecting to, it will have a yellow key displaying. From what I can read that...