carriem (2/11/2009)

---

I'm new to all this and I'm just beginning to learn how to create scripts for reports using SQL and Crystal reports. I found it interesting how some...

FWIW, the Simple-Talk Code Prettifier on SQLServerCentral gets it wrong (highlights PRINT '7' as executable). SSMS (2K5 SP3) shows

[font="Courier New"]PRINT '1' -- /* ;PRINT '2' */ ;PRINT '3' /*

PRINT '4'...

Great article. I too am having to do more and more work with SSIS and, naturally, don't have time/budget to go on training 🙁 hence learning about the tools described...

I've come up with a solution using the Execute SQL Task but it seems a bit of a kludge.

I've changed the SQL query in the task to something likeselect year,month,'select...

Sorry. But I don't see how this fits with accessing SSIS variables in tasks in a package. Could you explain further?

The data flow source task (where the SQL query is...

Bob Hovious (2/10/2009)

---

Other posts for other bulletin boards:

Engineering:

"How can I tell if my bridge is going to hold all the cars and trucks that will be driving on it?"

"How do...

David B (2/10/2009)

---

in a standard corporate network all AV's will probably be the same brand and version and so if the workstation AV cant stop it, neither will the server's...

venki (2/11/2009)

---

I am doing a vb program which requires this one.

I will first taking that employee name into a variable and checking for apostrophe(') and if it is there then...

A few comments.

Firstly, I try to avoid using GOTO as it can make the code difficult to figure out when someone comes back to it months later.

I also try to...

Sankar Reddy (2/10/2009)

---

This is written as a trivia question and to raise awareness that certain questionable features will not be supported in future versions of SQL Server. Follow the link...

OK, I learned about the IDENTITY function used with SELECT INTO.

But if I wanted to copy a table, except as a temporary hack, I'd still use 'Create Script..', edit, etc.

If you look at the definition of the table MSDB..SYSJOBSERVERS, it shows that [Last_run_date] is an int, so you need to convert it

I also did what you should have...

Are you building the statement in, for example, a web page?

If so, you need to do something like

Name = "Venkat R'Thota"

SQL = "select * from Employee where empname='" & replace(Name,"'","''")

The...

Assuming I interpreted your rules correctly (you could really do with explaining it better), I beleive your sample data is actually in the final state, so I made up some...

Sergiy (2/10/2009)

---

Yep, kind of.

Just missed his post.

So, the question then: what...