slunt01 (5/10/2013)

---

I wish I could show screen shots for further help but I am unable to because of the company policies. I will try and post more details about it....

mtillman-921105 (5/10/2013)

---

I like rich, strong, red, beers, but...

Smithwick's is one my favorites too!!!!

kapil_kk (5/10/2013)

---

Hi, I have a scenario...

I have a table Table1 with columns ID, Names, WorkLocation

I have created a trigger which onupdation insert a data in some audit table...

Update table1

SET Name...

gopalk32 (2/25/2013)

---

Hi Guys,

Need your inputs to proceed the ETL from Tally6.3 source to Sql server Database using

ODBC method (with out TDL/XML methods)

Require a Steps to achieve the above task.

Thanks...

GilaMonster (5/9/2013)

---

Sean Lange (5/9/2013)

---

The difference between delete and truncate is that delete is a dml operation that is fully logged and truncate is DDL operation and is minimally logged. What...

tonyarp05 61903 (5/9/2013)

---

I am sorry for not given clear input.

In #variableta table, txt_bh_assessment1,txt_bh_assessment2,txt_bh_assessment3,txt_bh_assessment4 fields data will be availble in #testing1, #testing2,#testing3 tables.

We need to find code-id for txt_bh_assessment1,txt_bh_assessment2,txt_bh_assessment3,txt_bh_assessment4 fields.

suppose,...

jamesscott2005 (5/10/2013)

---

Just stumbled across this post, and loving the replies. Many a new beer for me to try!

My favourite has got to be Samuel Adams. It's from Boston I think,...

Lynn Pettis (5/9/2013)

---

You may be right there.

Just a...

Assuming that you really want 4 rows...

Is this close???

create table Something

(

ID int,

ActiveFlag bit,

SomeDate datetime

)

insert Something

select 1, 0, '1/1/2013' union all

select 1, 0, '2/1/2013' union all

select 1, 1, '3/1/2013' union...

jagat.patel (5/9/2013)

---

I have following table

IDActiveFalgDate

10 1/1/2013

10 2/1/2013

11 3/1/2013

10 ...

Sean's of the world unite!!!

You are quite welcome. Hope my answers helped clear up some of your confusion.

TeraByteMe (5/9/2013)

---

And below are the rest of the questions. BTW, I took myself out of being considered for candidacy for the role so I am not be considered for the...

TeraByteMe (5/9/2013)

---

Hello All,

I was prescreened for a Senior SQL Program Analyst position and one of the questions asked is shown below. I have been around SQL quite a while but...

You could try adding that index but often the suggestions for missing indexes are actually worse. I have very often seen that adding the suggested indexes actually slows down the...