asranantha (10/18/2013)

---

Hi friends i have small doubt in sql server how to handled nulls and empty values and replac other values in sql server

table data look like below

table :emp

id...

wwwarp (10/18/2013)

---

Sean Lange, hi.

This is my job.

How can I realize output as many rows with all id but not one last id output that I have?

And if I do...

OK I see what you are trying to do now. Why do you need to generate the insert statements like this? Wouldn't it be easier to just insert the data...

I don't see anything wrong here either. I created your table and function and received no error.

If you want to learn about APPLY you might want to look at this...

Hi and welcome to the forums. In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Please don't create new threads for the same issue. It fragments your replies and makes it harder for those of us trying to help you.

The original thread is here. http://www.sqlservercentral.com/Forums/Topic1505867-2799-1.aspx

Take a look at this article. http://blogs.msdn.com/b/conor_cunningham_msft/archive/2008/08/27/no-seatbelt-expecting-order-without-order-by.aspx

arosenbaum (10/18/2013)

---

Even Better I took data from all 3 and dumped them into one table. Now I need to Crosstab as such:

Dealer District ...

Jeff Moden (10/17/2013)

---

Gosh... I have to disagree with that statement that you and Sean made. What if the task is...

dhananjay.nagarkar (10/18/2013)

---

one more help- I just started as a SQL Server 2008 /SSRS report programmer, wanted help to define next steps in this field to grow and learn, any tips...

Yes you need the case expression in your group by. You also should really consider using aliases in your queries. It would make this a lot more legible. And your...

DaveDB (10/17/2013)

---

Hello all,

I have to say that once again Microsoft has fallen short with their attempt at creating a reporting tool. I have spend the past 2 days trying to...

In order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form of INSERT INTO statements

3. Expected results...

As we have said already. Provide ddl and some sample data. This isn't a difficult query but with nothing to work with it is next to impossible.

arosenbaum (10/17/2013)

---

I need help I'm am stuck an need to complete today. Here's the set up

I have 3 tables Confirmed, Released, and Dlr Inventory. Each can have upto 8 different...