This should be all you need. Come back and ask if you're stuck on anything.

I wouldn't say any one of them is "easy" or "best".

Go down whichever path you find yourself orienting to, I would say.
Its more important to be very...

jmlc1 (7/27/2016)

---

Hello. I have some database experience though I am somewhat new to SQL Server so I have what I think is a general question (I hope). it...

I believe comments should describe what a piece of code is setting out to do or trying to achieve at the high level.

Any other comments following that could be an...

Comes across as logic that might typically be encapsulated in a Script Task, yes.

Once you've created the Stored Procedure as has been suggested, in addition to using bcp you could also use the SQLCMD utility to execute the stored procedure and output the...

https://msdn.microsoft.com/en-us/library/mt204009.aspx

As has already been pointed out you are not providing enough information to get a useful response.

Take a step back and re-evaluate what you need to do and then post...

lynn.sferrino-foxworthy (5/15/2015)

---

I am using SQL and going through SQLServer Management Studio

I'm afraid you're not being that clear.

If you were doing this from SQL Management Studio then it is unlikely...

lynn.sferrino-foxworthy (5/15/2015)

---

the field value "txtCRType" is the column where the drop down list is being pulled from. i want to this field to display the word "MANDATORY" when a...

You are probably under a bit of pressure here and consequently not communicating your problem as well as you could?

I can't see how a loop can help you here as...

btudek (5/11/2015)

---

Hello,

I am would like for a Trigger to fire after an SSIS job finishes.

My understanding is that i would use a AFTER trigger.

I am confused by how my UPDATE...

You might want to try updating the statistics on that table prior to running that query.

I say this because there is quite a difference between the estimated and actual number...

Again, it is doing a clustered index scan (also known as a table scan) instead of using the nonclustered index you created on C6 (with no included columns) because the...

balushanmugham (4/8/2015)

---

I have separate scripts for Creation of Tables, Stored Procedures, Views, Triggers in different .sql files.

I have to execute thses scripts in batch in different servers and different databases...