Red Gate probably has a tool that will do that. I know SQL Data Compare will generate the data script when doing a comparison. I don't think it...

Because you are naming the file with an "XLS" extension, Excel thinks it is a native file and is not looking for a delimiter.

I would use "," for...

Lynn Pettis (2/29/2008)

---

Jeff,

Okay, sorta helps, but still I'm not quite there. Does that shoot me down from working with you or do I at least understand enough that they...

The thing about functions in where clauses is that, if on a column, you have to run every row through the function while using them on a parameter or constant...

You cannot index a text datatype. The TEXT datatype is stored as binary data and was intended mainly to store documents, etc.. and is being deprecated. It also...

If this is how you will most often be querying your data you should have month and year columns in table with an index. Or, write your queries with explicit...

Grant Fritchey (2/29/2008)

---

I don't know, I've seen your posts, Jack. You look pretty knowledgeable. I know I could learn from you.

BTW, we are hiring over here in the Island of...

GilaMonster (2/28/2008)

---

When I'm interviewing, I ask questions on any or all of the below topics, depending what position I'm interviewing for.

Indexes - types, differences.

Statistics - what, why

Database corruption - how...

Jeff Moden (2/29/2008)

---

Mark Markov (2/29/2008)

---

Dear Ms. Gila Monster,

NO, I am not being honest about my lack of knowledge of SQL Server! Think about it!! If my resume is junior level,...

I would venture to say that just because you are creating the steps in that order, SQL Server is not sequencing that way. You can provide the parameter @step_id...

salinasalina2001 (2/29/2008)

---

sorry i am not dealing with colors

i am tryin to match parameterid of the first table to second table

if the datas are int i convert it to int...

In the DDL trigger you have access to the EVENT_DATA function which returns an XML document that includes a the node (/EVENT_INSTANCE/TSQLCommand/CommandText that has the T-SQL run. You would...

I do not use any encrytpion on my personal laptop. Several people I know do. I have never used encryption in SQL Server because I have worked on...

Here's how I would do it:

Step 1 - determine if the tables with the same names be merged into a single table in a new db or do is the...

Your problem probably has to do with the blue/italic code below. Because of the blue/bold code (setting the _val variables to null) means the red/italic code never runs.

set @f_val...