SELECT DISTINCT title, installcount FROM table ORDER BY installcount

Forum Newbie

I tried and that doesn't work. the table will have duplicate values in title column that will have different values in...

Your going to need to post some error messages at least to get somesort of response.

DO you need to keep the spaces?

Say that you want to create a table for tracking where individuals were living at different times. I can see a couple of ways to design such a table, and...

Somewhat of a newbie when it comes to T-SQL so I will try my best to explain :). I have the following columns in a table (along with sample data):

Vendor...

I thought you were talking more about restore. I have worked some where before where we had to do some consistent restoring. So i used xp_cmdshell dir to make a...

you can use xp_cmdshell(not recommended on prod) and get the info through a query to build a script.

Not sure probably something close to Maximum Overdrive.:w00t:

kramaswamy in the original post he had both rctype =1 and rctype = 0 in the joins.

No it is not the exact query he wrote because it gives the output hes looking for his query did not give the expected results. I understand he did not...

I have got your expected results but not sure if this is what you want.

select a.rcID,a.rcClaimno,c.adt from Credit c

join rcclaim a on aclaimno = a.rcclaimno

and a.rctype = 0

left join...

effective communication

Your query would work better if you had some sort of id.

select distinct

T2.Number

from

table1 as T1

JOIN

table1 as T2

on T2.ID = T1.ID

where LTRIM(T2.Number) like '8%'

You need to figure out which database it is failing on. If you have to run the dbcc checkdb command on every db you have manually

What databases did you run it on? Do you know which one it failed on?