+1 🙂

Silverfox (7/22/2014)

---

I still don't understand how one person can work as a DBA for one company and then in next role at another company be a architect, it is the...

It more likely the designation you get from a given company then a role basically. if you are working in a organization especially IT related company, they are tends to...

I think you should consider Jeff suggestion, as he described above that if your 1st column have very low number of value, which i can see in the procedure, i-e...

1) Share table definition

2) Sample data

3) your desired output

This will help us to provide a better response against the question.

Check This

npittson (7/18/2014)

---

Thanks for your reply.

After I posting I began scouring the net trying to put something together, in the end I found this worked for me:

CREATE TRIGGER dbo.MyTrigLI ON dbo.MPanel

FOR...

If you are loading large data in that particular table where you have created the index, then you can use disable and restore approach which can increase your performance. When...

When i say create a variable you need to create a variable manually at designer level 1st. then reference that variable in the script component. then you will be able...

The answer is Yes.

Nice and easy...

select [cs_id],userid, SUM(DATEDIFF(dd,[assgn_dtm],[complet_dtm])) - count(*)

from (

select distinct [cs_id],userid,cast([assgn_dtm] as date) as [assgn_dtm], cast([complet_dtm] as date) as [complet_dtm]

from temp_tbl

) Z

group by [cs_id],userid

does it make any sense ?

Can you share the desire output in a result set its still not clear.

Tail log backup WITH CONTINUE_AFTER_ERROR works only if the database goes offline in case during the start up of the database is fail to come online due to some reasons...

Excellent question, Thanks for sharing

When you edit the script component, there is an option where you can reference the local variables to the script component.

1. Create a UserID variable

2. Assign it to script...