BTW, I commented out "Dose" because it wasn't in your ddl and it didn't really have any bearing on this. Just don't want to overlook it if you end up...

At a glance you seem to be missing an index on DRUG_INFO_1. This is exposed in a nonSARGable predicate with your large value list in the where clause.

LEFT(drug_info_1,CHARINDEX(CHAR(32),drug_info_1))

...

Oh good grief...I put my implicit conversion outside the division. Thanks Lowell. My intention was something like this:

(count(item_keya) / count(snetworkname) * 1.0) * 100.0

I was not the person who made...

I bet you can make that quite a bit faster with some tweaking. If you are satisfied then...

Depending on what your actual query looks like that doesn't sound...

SQLWannabe (7/1/2013)

---

When I query a datetime field, the result is a date and time.

SELECT SentDate FROM MyTable.

Result = '2013-07-01 12:32:47.000', which is fine

When I use the following to...

(count(item_keya) / count(snetworkname)) * 100.0

or something ...

It seems that you missed the point of my previous post since none of this looks like any of the information that was requested.

SQL_TASK (7/1/2013)

---

I have 2 database tables.

1) From Production

2) From Dev.

The task is to move the data refresh from Production to Dev Server. But the table schema itself is changed is...

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

The problem here is that we don't know what you want. We have no idea what your tables look like or the data. It is unclear what you expect as...

True dat!!!

The point we...

ROFL. Glad you got it working. 🙂

This really isn't too bad but in order to help we will need a few things:

1. Sample DDL in the form of CREATE TABLE statements

2. Sample data in the form...

Thank you for posting ddl and sample data. Unfortunately your script doesn't work. There are a few syntax error, once I fixed those the inserts don't work because the number...

Eyes open, a$$ down. Good luck,...