j.portolese (6/26/2015)

---

Thanks for the replies Steve and Alvin. Steve in an ideal world my source would hand deliver to me data in a format that works best but unfortunately...

erics44 (6/26/2015)

---

hi

say i have a report with 3 pages, each page has a different dataset and takes some processing time.

is it possible to give the user the option to just...

Not sure if this is going to produce the desired result, but looking at your code, you have an OUTPUT statement, and that isn't going to be part of a...

Sounds like the format of the input file is changing every month. The source of that file needs to realize how much effort is involved for you and use...

ScottPletcher (6/25/2015)

---

I prefer this approach [Edit: Because of its clarity, and to avoid using functions in the WHERE clause, which should be avoided whenever (reasonably) possible]:

WHERE

...

ScottPletcher (6/25/2015)

---

Why does everyone keep repeating that? Of course NOLOCK hints make queries run faster,...

a4apple (6/25/2015)

---

It sounds like this structure is for a company that uses network marketing for its sales force. The problem here is that I'm not sure quite what...

kathy.plamann (6/25/2015)

---

Thanks Steve!

I found out that the table's data is deleted based on date so all the data may not necessarily be deleted. I suggested that when select count(*) from...

cory.bullard76 (6/24/2015)

---

Thanks! So, are you saying something like this?

Select column A, column B, max (case when) as Drug, max (case when) as Reason

From.....

Group by column A, column...

kathy.plamann (6/25/2015)

---

Hi

I have a table that has a primary key that is auto incremented by 1. This table's data is cleared out periodically and as data gets added the...

One thing you might want to do at night with no load is to drive the SAN I/O through the roof with some kind of giant test query that gets...

a4apple (6/25/2015)

---

Steve,

Thanks for that but my question was different. Let me explain it much better.

I have an accounts table like below

DECLARE @Accounts TABLE

(

AccountID INT,

ParentAccountID INT,

ServerModifiedDate DATETIME

)

ParentAccountID Can keep changing due...

Let's take a close look at the info we have as well as what we don't:

1.) The two procs have differing parameter sets, which suggests strongly they have entirely different...

a4apple (6/25/2015)

---

sgmunson (6/24/2015)

---

I hope you're not using this data structure as the basis for accounting data. There is way too much other maintenance that would get very tricky...

blarson 11072 (6/25/2015)

---

Thanks again for the help. This is close but I don't think it will work. Here is some output from my data.

111340Fri7:00 AM - 5:00 PM

111340Tue - Thu7:00...