Viewing 15 posts - 601 through 615 (of 3,221 total)
Nice straight forward question --- Thanks Steve
February 27, 2012 at 8:34 pm
Oops here we go again .. blog postings show up in the Forums page, but this one is super special ..
It is wishing us all a Happy New Year...
February 26, 2012 at 7:21 pm
You stand a better chance of getting tested help if you would post your table definition, sample data and required results in a readily consumable format.
...
February 26, 2012 at 4:33 pm
Unfortunately I am not a fan of SSIS, the only further assistance I can suggest is to read the "Starways" articles for SSIS
February 26, 2012 at 7:55 am
First lets get some data into a table
CREATE TABLE #Order(Quantity INT,Placed DATETIME)
INSERT INTO #Order
SELECT 100,'1/20/2011' UNION ALL
SELECT 1,'2/7/2011' UNION ALL
SELECT 2, '3/1/2011' UNION ALL
SELECT 2, '2/5/2011' UNION ALL
SELECT 3, '4/18/2011'...
February 26, 2012 at 7:24 am
Probably not the best method, but you could use SSIS to import the data into a "Staging Table" and then execute a T-SQL statement to do what you want to...
February 25, 2012 at 7:57 pm
I would suggest using GOOLE, for example I entered
"temporary employment agencies in cleveland ohio". and found reference to 47 different agencies.
Clicked on a few to visit their...
February 25, 2012 at 7:38 pm
Whoops incorrect forum .. sorry about that
February 25, 2012 at 7:20 am
Here is something to get you started
CREATE TABLE #t(Empcode INT, BasicPay Money, Rent Money)
INSERT INTO #T
SELECT 65, 800, ...
February 25, 2012 at 7:02 am
Have you considered using the MERGE statement? Greatly modified to NOT change anything simple to find those rows.
MERGE dbo.Departments AS d
USING dbo.Departments_delta AS dd
ON (d.DeptID = dd.DeptID)
WHEN NOT MATCHED...
February 24, 2012 at 7:38 pm
tilew-948340 (2/23/2012)
February 24, 2012 at 6:49 am
Have you installed the lastest software updates for 2008R2 ?
http://www.sqlservercentral.com/articles/SQL+Server+2008+R2/70092/
and remember that ALTER DATABASE syntax replaces the sp_dbcmptlevel procedure
corrected spelling error
February 23, 2012 at 12:12 pm
L' Eomot Inversé (2/23/2012)
I guess that particular collation was chosen to demonstrate that not all T-SQL is case insensitive even when the collation...
February 23, 2012 at 9:14 am
Read this article by Jeff Moden about the "ISNUMERIC" function and how it can result in returning a field is numeric, when it fact it is not, much akin to...
February 22, 2012 at 12:42 pm
Hugo Kornelis Posted Today @ 9:19 AM
2. If model is read-only, newly created databases still default to read-write. However, the SSMS GUI "cheats" by sending an ALTER DATABASE to change...
February 22, 2012 at 7:55 am
Viewing 15 posts - 601 through 615 (of 3,221 total)