zeldakr (3/11/2014)

---

I have the following code in a SP. The 2 if statements for the @@ Error I added only for testing as I suddenly started get the following...

milutinke (3/11/2014)

---

CAN SOMEONE tell me what is wrong with this code

I have two tables LicParcela, and LicKo , I want, when i Draw ( insert) new Parcela ( Polygon type),...

PiMané (3/11/2014)

---

Our problem is that we can't change the software, it isn't ours...

The only thing we can do is change some SPs it uses to improve it's performance.

It's "impossible" to...

PRR.DB (3/10/2014)

---

Sean Lange (3/10/2014)

---

Let's pretend that after 999 we increment the last character.

So when we have ABC999 the next value will be ABD001.

Now consider what the next value will be...

j.green (3/11/2014)

---

free_mascot (3/11/2014)

---

Yes, initially I have drafted the question straight forward but it looks very simple. Deliberately make it complicated by tricky language to make challenging.

Usually everyone knows correct...

sharonsql2013 (3/10/2014)

---

I need to calculate average # of requests per week. The Year # and Week # both fields are Integer and Request # is Varchar

I understand that for the...

SQLRNNR (3/10/2014)

---

Greg Edwards-268690 (3/10/2014)

---

Pretty sad when they want someone to just do their homework.

Almost makes a...

Or 99 roots?

I'm with Jeff. If you can't actually properly normalize this data then I would add...

koti.raavi (3/10/2014)

---

Hi Mate I know that i'm doing wrong..but thing is like if i get some idea how to do it i can finish as early as possible. Well...

Tests are...

koti.raavi (3/10/2014)

---

I got task, Please help me out

The objective of this task is to create a report that will connect to the AdventureWorksDemo database on the “TESTPC” instance of Analysis...

Let's pretend that after 999 we increment the last character.

So when we have ABC999 the next value will be ABD001.

Now consider what the next value will be when the current...

PRR.DB (3/9/2014)

---

Hi

We have identity functionality for integer , Similarly i want for charters .i.e.

EX:

ID Name ...

Don't get stuck in the trap of thinking your caseno needs to be sequential with no gaps. I would do as Koen suggested and either use an identity or a...

twin.devil (3/10/2014)

---

Boy donot use Max(ID) +1, you will get into a very big and stinky hole if your application run in a multi-user environment. trust me on this one,

just...