It is hard to figure out which of your questions you want help with. Also there seems to be confusion about performance vs presentation. SQL server is NOT a presentation...

Also you said you wanted to display 0's for months with no data. You will need provide some sort of start and end dates for your query. It could be...

cool. What i was really hoping for...

matt_garretson (8/9/2013)

---

Hi there. Thank you for getting back to me. I basically need to combine the two above programs about so I get the amount budgeted for each waver...

wolfkillj (8/9/2013)

---

Sean Lange (8/9/2013)

---

Ed Wagner (8/9/2013)

---

Stefan Krzywicki (8/9/2013)

---

For me the investment is getting something that I won't have to spend much on during its lifetime. I drove my Pathfinder 276,000...

Ed Wagner (8/9/2013)

---

Stefan Krzywicki (8/9/2013)

---

For me the investment is getting something that I won't have to spend much on during its lifetime. I drove my Pathfinder 276,000 miles and kept...

Awesome job posting ddl and sample data. I did make a few modifications to make your datatypes numeric(9,2) for RATE_PER_UNIT_OF_SERVICE, PROJECTED_COST_PER_MONTH and total. You had them all as ints so...

This will do it.

if OBJECT_ID('tempdb..#Something') is not null

drop table #Something

create table #Something

(

SomeID int identity,

SomeValue varchar(25)

)

insert #Something

select '1,2,3,4,5' union all

select '6,7,8,9,10'

select MAX(Case when ItemNumber = 1 then Item else null end)...

sundayose (8/9/2013)

---

Dear members I have a query below;

use DBMUST

select

[dbo].[tbl_VOUCHER_CAPTURE].dt_VOUCHER_ISSUE_DATE AS Sales_Date,

[dbo].[tbl_VOUCHER_CAPTURE_DETAIL].str_BARCODE AS Voucher,

[dbo].[tbl_SALES_TEAM_MASTER].str_SALES_TEAM_NAME AS Team,

[dbo].[tbl_SALES_EXECUTIVE_MASTER].[str_SALES_EXECUTIVE_NAME] AS BCC,

[dbo].[tbl_DISTRIBUTOR_MASTER].[str_DISTRIBUTOR_NAME]AS CBD,

[dbo].[tbl_DISTRICT_MASTER].str_DISTRICT_NAME AS CBD_District,

[dbo].[tbl_VOUCHER_ISSUE].[dt_VOUCHER_ISSUE_DATE] AS Issuance_Date

from [dbo].[tbl_VOUCHER_CAPTURE]

left Join [dbo].[tbl_VOUCHER_CAPTURE_DETAIL]

on [dbo].[tbl_VOUCHER_CAPTURE].int_VOUCHER_CAPTURE_ID = [dbo].[tbl_VOUCHER_CAPTURE_DETAIL].int_VOUCHER_CAPTURE_ID

Left Join...

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1482812-146-1.aspx

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1482812-146-1.aspx

akshay9986 (8/9/2013)

---

thanks Sean Lange,

The 500 tasks are will be allocated to most top parents...

i m thinking that this 500 tasks can be stored in emp table itself...

These tasks will get...

Hi and welcome to the forums. Great job posting ddl for the emp table. You lost me when you started talking about tasks. There is no table here and I...

Generally speaking you can adjust the timeout like you said to "fix the problem". Actually this is more like a try/catch block with an empty catch. My guess is that...

Duplicate post. direct replies here. http://www.sqlservercentral.com/Forums/Topic1482598-392-1.aspx