Good question. Learned something new about creating types. :hehe:

db2mo (4/21/2011)

---

I've tried both ways so I must be doing something wrong because I still get an error. First, I looked again at the table and both fields are...

If I could count how many times I have done that myself...

Just to be silly I tweaked Dan's a little bit.

select t.fristname,t.lastname,t.Check_date,t.Checkno,t.Amount

from

(

select fristname,lastname,Check_date,Checkno,Amount,

ROW_NUMBER() OVER(PARTITION...

One of those fields must not be a character type field so you will have to cast it.

cast(QO01HIGHWAY_CLASS as (n)varchar(whatever length is appropriate here)) + cast(QO01ACCIDENT_LOCATION_HWY as (n)varchar(appropriate length))AS...

It is unclear what you want. You posted the details of the data you want from this table but...that data does not exist in the sample data. Maybe if you...

Login as that user and try to do some inserts and selects on objects that belong to that schema. You can do that directly in SSMS easily enough.

Please don't keep posting the same question over and over. It fragments the responses and makes it harder for everyone.

See the original thread here

Happy to help. I don't think you any other alternative because that column contains multiple datatypes. You could also try using each of those queries as an insert to a...

enzotoc (4/19/2011)

---

First of all, sorry for my english

but i have a good reason for open a link directly from t-sql query

Here the scenario

I have a query that lists the bugs...

Best guess is you will have to do 3 queries and union them.

something like this

SELECT a.ID,c.Dt_ID

FROM dbo.A a

INNER JOIN dbo.B b ON a.ID=b.ID

INNER JOIN dbo.C c ON b.ID=c.ID AND c.ID=a.ID

WHERE...

Unless your data is incredibly specific this will never work. You are only going to allow values in this field...

If you don't know the mime type it can still work as long as you know the extension. If it is just a binary and you don't know either the...

That is the way temp tables are designed to work. They are only visible to the connection that creates them. If you need to see a temp table from another...

Not quite gonna get you there. There are no hours that are >= 20...