GilaMonster (2/17/2012)

---

Eugene Elutin (2/17/2012)

---

GilaMonster (2/17/2012)

---

Its length is anything from 2 bytes to 82 bytes depending...

I knew! We can make it!

CELKO (9/15/2011)

---

...

Rows are not records; records are not values it is a HUGE difference that you will nee to learn. Please post DDL and not a vague, useless narration (can...

Eugene Elutin (2/17/2012)

---

GilaMonster (2/17/2012)

---

Its length is anything from 2 bytes to 82 bytes depending on...

You have tried to write stored proc? - Good!

Could you please try to add tables DDL's with sample data insert script to help your helpers to help you 🙂

Link at...

Loundy (2/17/2012)

---

Hi All,

I'm trying to work out what's the best way to roll back specific objects. For my company we don't have any form of automation so we...

GilaMonster (2/17/2012)

---

Its length is anything from 2 bytes to 82 bytes depending on the data...

Because your WHERE condition are inside UPPER function. By default SQLServer is case insensitive. That should work:

SELECT dqid, DQFlag, DQLinkID INTO DMCDUPES

FROM OrangeDataDQ1

WHERE ([MANAGING COUNTRY] <> 'UK' OR [MANAGING COUNTRY]...

and its length is 80 bytes, to accomodate unicode...

I see now.

Ok my advise is:

If you want to achieve the best performance and make your reports neat, use a calendar table (in the datawarehouse world it usually...

select DATEPART(weekday, GETDATE())

Why in SQL? It's not a formatting tool!

You should do it in the UI or report.

If you insist on exact format requested (eg. no leading 0 for month part)...

ramyours2003 (2/17/2012)

---

Hi ,

Can any one answer these

1)What is meaning of switch -m and -c when we bring sql server in single user mode?

2)How can I change...

Replying...

Sorry mate, cannot understand your question at all. Which property are you looking for?

jflynn-735049 (2/16/2012)

---

I have a sql 2008 database that contains a list of users.

When any attributes change son the users I need to either insert or update the attributes on...