maybe worth a read ....

http://www.sqlservercentral.com/stairway/72494/

etirem (9/22/2013)

---

Sorry! May be I`m not explaining it properly.

One more CID=333 is added below SQL.

IF OBJECT_ID('Tempdb..#tTable')...

maybe something along these lines.....???

WITH cte AS

(

SELECT CID,

CDate,

Dept,

...

RamSteve (8/15/2013)

---

I would need any Simple Query for generating 4-4-5 calendar that most of the companies use in USA .. My Company was not using it before and i...

for how many years...

not sure if this will help, buy may set you on your way

http://www.sqlservercentral.com/articles/T-SQL/71550/

mario.rbrandao (8/13/2013)

---

More accurate than the first part of the name:

foundations

banks

Any suggestions on how we can identify that the first word is the foundation or bank bring full name?

TABLE

FUNDAÇAO XXX ...

remove the "SELECT"

ok...sleep well

try running the "simplified" queries I posted earlier, when you are able.

Beniamin Joke (7/14/2013)

---

Hi

the expected result should be where the gmso colums is equal to 003 from GLMSO table and which have in table GLCTA the column KCTR equal to 01...

s_v_narayanan (7/14/2013)

---

Hi,

Is that possible to write in single query to get the below results -

I need to get the month wise records from the transaction table. If records for that...

shohelr2003 (7/13/2013)

---

Dear,

I have a customer table containing many duplicate names and custid is the unique key. But the customer names are not 100% similar. For example,

CustIDCustName

--------------------

100ABC CO

101ABC CO.

102ABC CO&

103ABC...

jcobb 20350 (7/13/2013)

---

I want to match the year field in a table and pull out all that are a year old. I'm trying to use the GETDATE and look back...

Beniamin Joke (7/14/2013)

---

i want the result for which :

table GLMSO which has the

gmso colum 0003 and has both of bot

of KCTR's in GLCTA table

06...

in an effort to try and understand what you require, I have attempted to simplify your query and just return relevant columns....based on code below...what results do you want?

SELECT...