Lynn Pettis (7/31/2015)

---

Sean Lange (7/31/2015)

---

I would offer that a prefix of any kind...

I would offer that a prefix of any kind is illogical since they...

Not sure what that means. Your table either does or...

You should avoid the sp_ prefix on your procedures. It is reserved for MS and denotes it as a system procedure. The performance issues are mostly corrected but ambiguity and...

LOL. And why should they do the research themselves if they can just come around here and...

Alvin Ramard (7/31/2015)

---

Lynn Pettis (7/31/2015)

---

The only thing that comes to my mind would require using Dynamic SQL. The difficult part would be knowing how to determine what is duplicated...

spectra (7/31/2015)

---

I need a script which will tell me Table name and column name where a given text is matching.

Example: search string = "I want to search something"

Output:...

tstagliano (7/30/2015)

---

still running into issues here. So if I leave the MAX function infront of my Case statement which contains the sum function for the values I need to...

tstagliano (7/30/2015)

---

Not sure I am following what you are asking. My current output would look something like this.

Country_code Local_client_code Local_client_name ...

tstagliano (7/30/2015)

---

WE have a query which pulls revenue by country and client for the last 3 years. Right now we have each year being reported in separate columns but...

thenewbee (7/30/2015)

---

Sorry but its something like this

with wftbl(

select col1,..col5 from objectA

inner join objectB

on cond1 =cond1

where ...

)

....

tbl2(

object c

inner join

objectA

where . ..

)

select col1 .. .

from

maintabl

....

left join (select...

spam reported

patla4u (7/29/2015)

---

Hello

I have a column name Classname and I would like to to Concatenate value.

ID ClassName

1 Class A

2 Class B

3 Class C

4...

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

Can you state what the actual datatypes are for these columns? I hope they are not all varchars. Is there a reason that In_Punch and Out_Punch aren't just a single...