please tell me if this logic is correct. I'm passing table name as parameter, the same tableName that will be used to create the *new table* called tempTable.

after the temp...

I edited your query to this:

DECLARE @SQLStatement NVARCHAR(2000);

SET @SQLStatement = 'CREATE TABLE dbo.Hosea_tblDATA_NOTE (';

SELECT @SQLStatement = @SQLStatement + ',' + c.name +' '+st.name +' '+cast(c.max_length as varchar(50))

FROM sys.tables t

JOIN...

Is that a dynamic sql, I'm just reading about it now and I haven't grasp it yet, can you explain your query to me please, also explaining dynamic sql.

I copied...

I want to create a new table with the about of that query, that output has to be my columns

How do I attach my bitmap picture to my report, on the conditions, e.g if Fields!Validation_Check.Value = Y, then watermark "Report In Error" on top of my report. And again...

I have created a picture so far, as to what I found so far through articles I found in the net, but then I'm not sure how to go on...

I thought maybe there could be another shorter way, I already implemented @startdate I was checking for other ways to implement it.

twin.devil (12/9/2013)

---

hoseam (12/9/2013)

---

twin.devil (12/9/2013)

---

you the maintaining your data Month wise, you need a way to segregate this data annual wise, you have PAD which represent month, which you do not...

twin.devil (12/9/2013)

---

you the maintaining your data Month wise, you need a way to segregate this data annual wise, you have PAD which represent month, which you do not have a...

Actually it was supposed to be SELECT CONVERT(DATETIME,'01' + @dt, 112) as [date], I still get the same error

A year will always be the current year. A day will always be '01'. I need a Month to start counting, which I get it from PAD, and the last...

If PAD is 4, then I know the Month is April. Then I need to pull data starting from April of 5 years back, which is 2008.

Thank you.

1. As many as it could

2. Not very often

twin.devil (11/4/2013)

---

place a parentID column ... following will be the values in...