Viewing 15 posts - 31 through 45 (of 56 total)
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...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 30, 2013 at 9:54 pm
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
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 30, 2013 at 9:48 pm
Well, I'll be, I thought it was 2008. Thanks
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 30, 2013 at 11:53 am
Jeff Moden (4/29/2013)
I can't help here because I don't use SSIS. A thoughtful but simple DOS "rename" would do this, though.
This solution would work and anything you can run...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 29, 2013 at 9:47 pm
jbloes (4/29/2013)
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 29, 2013 at 9:41 pm
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,...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 29, 2013 at 9:35 pm
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...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 27, 2013 at 11:28 pm
With that data, you can't group by what you've asked.
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 27, 2013 at 11:23 pm
Some more sample data from your tables would be extremely helpful, not just the results.
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 27, 2013 at 11:17 pm
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...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 27, 2013 at 11:13 pm
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...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 27, 2013 at 10:55 pm
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...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 25, 2013 at 6:55 pm
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...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 25, 2013 at 6:46 pm
dba.sql29 (4/25/2013)
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...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 25, 2013 at 6:39 pm
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...
--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455
April 25, 2013 at 11:43 am
Viewing 15 posts - 31 through 45 (of 56 total)