Viewing 15 posts - 181 through 195 (of 621 total)
Thank you both for the feedback, I just wish I still had the time to hang out here like I used to. I think I have forgotten more in...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 20, 2010 at 8:09 pm
asbains8 (10/19/2010)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 19, 2010 at 1:52 pm
asbains8 (10/19/2010)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 19, 2010 at 11:22 am
Jim, you can use the data import wizard, or lookup OPENROWSET() in BOL. With OPENROWSET, you can select directly from the spreadsheet into a temp table, or any other...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 24, 2010 at 12:49 pm
Mitch, I'm not sure if you are still having a problem, since this is an older post. But I just couldn't resist pointing out that this is absolutely terrible...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 3, 2010 at 12:18 pm
michael.morse (8/9/2010)
Okay the table of tasks sounds like what I am trying to accomplish. How would I go about implementing this?
Michael, there are many places you could start, but...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 3, 2010 at 11:41 am
Martin, to Waynes point, you really need to give us more information to go on. Without it, we have to make assumptions about what you have, and what you...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
September 3, 2010 at 10:14 am
kschuler-851405 (8/18/2010)
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 18, 2010 at 7:36 pm
Andrew, I think I have mis-interpreted the BOL example, which is as follows...
DECLARE @document varchar(64)
SELECT @document = 'Reflectors are vital safety' +
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 18, 2010 at 6:45 pm
kschuler-851405 (8/18/2010)
DECLARE @string VARCHAR(100)
select @string = '08/01/2010 - J.Smith: just some text'
SELECT
[Date] = SUBSTRING(@string,1,10),
...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
August 18, 2010 at 6:09 pm
Gunjan (7/7/2010)
Hi,SELECT BI.BRCFORMID FROM BRCFORMITEM BI
inner join Lookupproducts L
on BI.productid = L.NDC
and L.Groupid in (1,3,6)
I think you want to change this to...
SELECT BI.BRCFORMID FROM BRCFORMITEM BI
inner join Lookupproducts...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 8, 2010 at 2:29 pm
You could search BOL or google for OPENROWSET and SELECT INTO.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 8, 2010 at 2:25 pm
tripri, search BOL(Books Online) for 'ALTER TABLE' for syntax, and you could probably find on google endless descriptions of what Jeff was talking about. Basically, here is how you...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 8, 2010 at 11:50 am
Novicejatt, again, this is a 2000 forum, and it seems like maybe you have 2008? Anyhow, as far as the one time uploads are concerned, I personally find OPENROWSET...
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 7, 2010 at 6:59 pm
Novicejatt (7/7/2010)
I only want to use SSIS
Are you sure you posted in the right forum? SSIS was new to SQL Server 2005. SQL Server 2000 has DTS.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
July 7, 2010 at 6:50 pm
Viewing 15 posts - 181 through 195 (of 621 total)