Decent job posting ddl and sample data (works with a slight modification).

However when you got to the description of the desired output you totally lost me.

I do not want to...

rarascon (4/9/2013)

---

I've been searching for something similar, but haven't quite found it. My dilemma is that this table was created with a TransDate of right(CONVERT(VARCHAR(10), TheDate, 103),7), which is...

Your other...

Did you...

I ran through a formatter so it is possible to see what is going on...

SELECT DISTINCT set_name

,a.seq_no AS set_id

FROM defulat_sets a

WHERE set_type = @set_type

AND ISNULL(qualifier1, '') = @qualifier1

AND ISNULL(qualifier2, '')...

jrestuccio (4/9/2013)

---

Did you look at all the sheets within the excel workbook?

It has the stored procedure (my code), also it is a SQL 2000 database and the save execution plan...

andrewalex.r (4/8/2013)

---

Hello,

I need syntax to get the all the values of one employee from the employee table, in a single column of...

jayoub1 (4/8/2013)

---

Thanks, but I may need an example to learn how to do this.

This is a typical query that I would have to run on each database in...

a_ud (4/8/2013)

---

Thanks Sean, I've modified the data type from text to a limited varchar + added an ID column. This last amendment now allows me to delete records, which was...

Interesting question. Unfortunately it is testing our knowledge of a deprecated datatype and its usage in a trigger. Like several others I managed to get it right but not necessarily...

Don't forget that temp table are in fact found in sys.objects BUT not in the current database. They will always be created in tempdb.

johnnyrmtl (4/5/2013)

---

I apologize for the vagueness 🙂

What I have is table1 which has been imported externally with 4 fields including an (AccountDescription) field

srvnameAccountAccountDescriptionDATE_CREATION

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

I need to be able to copy only...

Do you have primary key on the table? How did you setup in Access which field(s) make up the primary key?

Also, you should not use the text datatype. It is...

Duplicate post. Direct replies here. http://www.sqlservercentral.com/Forums/Topic1439245-392-1.aspx

chetan.aegis (4/5/2013)

---

A calculation is deliberate process that transforms one or more inputs into one or more results with variable change. The term calculation is used in a variety of...