If you go into Windows Services (Control Panel | Administrative Tools | Services), what do you see under SQL Server? there should be a SQL Server service for each...

asranantha,

Review CharIndex (http://msdn.microsoft.com/en-us/library/ms186323.aspx), this will help you to search for the value you are looking for:

select charindex('m' /*search value*/, 'sas programer ' /*column to search*/)

from SomeTable

Well, I'll be, I thought it was 2008. Thanks

This solution would work and anything you can run...

jbloes (4/29/2013)

---

I'm planning on moving around 4 or 5 MS Access databases to SQL Server and need some insight on what might be the best approach in regards to the...

Evil, for us old timies that still work on sql 2005 most of the time, the Year() might not have been the first thing that came to mind. None-the-less,...

Depending on what your recovery model is, you may not be able to truncate any data from the transaction log until a transaction log backup has been run. What...

With that data, you can't group by what you've asked.

Some more sample data from your tables would be extremely helpful, not just the results.

Hogpen,

Next time it would be helpful to present the data like this, then we could easily duplicate the data and write the queries:

CREATE TABLE Accounting

(ProdDate DateTime,

AcctDate DateTime,

MtrNo int,

MtrSfx char(1),

TrnxID int,

RecCode...

You just needed to change up your on statement just a bit:

select a.name, b.[DATE], b.[ORDER]

from dbo.Table_A a

left outer join dbo.Table_B b on a.id = b.ID

and b.[DATE] = (select...

What version of SQL are you running? I know that different versions of SQL run shrinking the transaction log differently. When was the last time you did a...

Mick,

Can you give us some kind of idea what your data looks like within the table? This will help us with a query. I've used CHARINDEX on a...

dba.sql29 (4/25/2013)

---

Hi Experts

I am trying to delete my publication from my Publication server and i am getting error. I have already dropped distribution database and none of the jobs...

The best option would be to normalize your database. Have one table that has the general order information (total items ordered, etc.) and have another table that contains the...