Viewing 11 posts - 46 through 56 (of 56 total)
Please explain again what exactly you need. I don't completely understand
--------
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 24, 2013 at 10:50 pm
This is a little tricky, because you are putting the same data across multiple rows (quantity requested is in each row for the particular headerid and product). Because of...
--------
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 24, 2013 at 10:38 pm
edward_hall76 (4/24/2013)
EXEC msdb.dbo.sysmail_stop_sp
EXEC msdb.dbo.sysmail_start_sp
SELECT * FROM msdb.dbo.sysmail_allitems;
it shows...
--------
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 24, 2013 at 10:01 pm
To me, it sounds like you want it be name and location. If so, it would look like this:
select name, location,COUNT(*)
from employees
group by name, location
having count(*)>3
If...
--------
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 24, 2013 at 9:55 pm
frdrckmitchell7 (4/24/2013)
Hi thereMy column is currently set up as varchar but will change it to the required field if need be.
Kind regards
Fred:-)
Have you changed the data type in the table...
--------
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 24, 2013 at 9:43 am
What are the settings for the column in the table you are trying to pull this data into?
--------
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 23, 2013 at 9:34 pm
What is the job trying to do? I've seen this error when I am trying to select too many records.
--------
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 23, 2013 at 9:21 pm
I would say try using "like" to the best you can and the different options given there. You could use something to the effect of:
where column like '%word1 %_...
--------
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 18, 2013 at 9:31 pm
How often is data written into this table? Is it on a schedule? This might help determine how you would deal with exporting/updating the data.
--------
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 18, 2013 at 9:25 pm
Having your code would be good here. If it isn't consistently backing up data (it sounds like it does back up the databases, but not on a regular basis),...
--------
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 18, 2013 at 9:19 pm
Don't know if you are still looking for an answer, but this should work for you:
Select MyColumn FROM
(
SELECT right(replicate('0',5) +CAST(CAST(0.10*100 AS numeric(10,2)) AS varchar(5)), 5) + '%' as MyColumn
Union
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 18, 2013 at 5:35 pm
Viewing 11 posts - 46 through 56 (of 56 total)