David Burrows (8/4/2010)

---

Many, many moons ago, in the long distant past, I was told about Maud (not an acronym) which was carboard cutout of a person which stood in a...

Alvin Ramard (8/4/2010)

---

If you solve your own problem before posting the problem you should ask yourself if this is something others can benefit from. If so then consider posting...

Jack Corbett (8/4/2010)

---

So you know the search procedure you are working on is complex when you can't write up a question about it for the forums because it takes so...

What you've posted here is the equivalent of me defecating on your shoes. If...

itskumar2004 (8/3/2010)

---

I have tried your expression for the column request_date but i got error,there are nulls in the some of the date fields .

can anyone please tell me what expression...

dallas13 (8/3/2010)

---

Thanks for the reply. I can parse this statement successfully but when i hit execute i can see this

Msg 911, Level 16, State 1, Line 9

Could not locate entry...

tom 29037 (8/3/2010)

---

A side note and off this particular topic (maybe I should start a new thread) but I just upgraded our SQL Server from 2008 Express R2 to 2008...

dallas13 (8/3/2010)

---

it gives Msg 102, Level 15, State 1, Line 5

Incorrect syntax near ' +@CostCenterCode+ '.

i m not able to adjust these commas in this dynamic sql. i...

I'm not actually at my work...

I'll try an example that you can follow in your SQL window 🙂

First, set your results to text and execute this: -

SELECT TOP 5 t1.[name]

FROM sys.columns t1

INNER JOIN sys.columns...

Your dynamic SQL is producing what you've told it to produce.

DECLARE @sql AS VARCHAR(MAX)

DECLARE @CostCenterCode VARCHAR (MAX)

SET @CostCenterCode ='123'

PRINT @CostCenterCode

SET @sql ='SELECT FundingCostCenterId ' + 'FROM gtl_srf_funding C ' +

...

:hehe:

Eugene Elutin (8/3/2010)

---

Please note: As sys.columns is used for Tally-On-The-Fly table, this query will only work for the number of...

Glad I could help.

Seems to be a really common question on here, I think I've answered it 3 times with the CTE so far with the last time having...

I've not opened your source file to check your incoming data format, but this is how I do it with the flat-files I get sent every month

(DT_DATE)SUBSTRING(date,1,4)) + "-" +...

After executing your code, I get: -

ID Org

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

040677 100

Whilst the OPs requirement was:...