sasansamani (11/28/2012)

---

Our department wants to automatically generate permit numbers for our customers when they apply for a license.They want something similar to a key generator. Yes SQL Server is my...

sasansamani (11/28/2012)

---

Let me explain what exactly we are trying to do.

Waste Hauler Unique Number Example: 00000-V/C 0000- AT- YR

Requirements:

Hauler # = 00000 (permanent)- there may be 1000 hauler companies

Asset ...

Interview?

What does "average active sessions" mean? Is that the average active sessions in the course of...

Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1389914-338-1.aspx

What do you mean by this?

You posted this in the 2005 section so I assume...

It is nearly impossible to do much but guess because you didn't provide much detail. Please see the first link in my signature for bet practices when posting questions.

LoosinMaMind (11/28/2012)

---

I supppose we could add in a self gentrating row ID as we go along.???

This will eventually be imported from a csv/txt file via the import wizard in...

mike.littlewd (11/28/2012)

---

Hi,

I'd like to have a go at pivoting this small dataset to start with before applying to a larger set of data.

Can it be done?

This is the starting result...

goodtomorrow01 (11/27/2012)

---

We have a following table:

[Day] [Time]

Mon 07:00

Tue...

Easy enough.

create table #Handset

(

Something varchar(10),

ModelName varchar(10),

ManufacturingYear int

)

create table...

Run both queries and look at the actual execution plan. They will be pretty much the same, if not identical. I don't like to see filtering in a join condition...

Due the denormalized data and the very unique situation it is impossible to give a generic this is a set based way to do this. If what you have is...

If I came across as snarky I apologize....

Try typing your question in your native tongue and then use google translate...

Agreed there are better ways to do this. I doubt you need...