Viewing 15 posts - 31 through 45 (of 86 total)
Jpotucek (12/28/2012)
Sounds like I...
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
December 28, 2012 at 12:05 pm
Which 1200? Any 1200? Or 1200 selected on some criteria?
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
December 28, 2012 at 10:53 am
karthik M (12/26/2012)
I have often worked on the below requirement.
There are two tables and fetch the record from TableA which doesn't exists in TableB.
I use NOTEXISTS or else I use...
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
December 26, 2012 at 6:23 am
🙂
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
December 19, 2012 at 2:05 pm
jillk (12/19/2012)
SELECT Account
FROM Account_Table
WHERE Account IN
(
SELECT Account
FROM Account_Table
GROUP BY Account
...
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
December 19, 2012 at 1:21 pm
Yes, that will make for a slow-running query. Try writing two separate queries, one to check for each condition, then UNION ALL to combine the records.
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
December 11, 2012 at 9:08 am
My advice would be to stick with SSIS. For someone with an Access background, SSIS would be a much friendlier road to travel than bcp. Far simpler to map your...
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
December 10, 2012 at 8:09 am
ron.grace (12/10/2012)
Roland,That worked a treat, many thanks, I was obviously over complicating things
LOL! I've outsmarted myself many times, I know what you mean!
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
December 10, 2012 at 6:58 am
ron.grace (12/10/2012)
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
December 10, 2012 at 6:50 am
ALTER TABLE ADD CONSTRAINT [constraint_name] DEFAULT [default value] FOR [column]
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
December 7, 2012 at 12:57 pm
You bet. An extra pair of eyes never hurts...that's why I love code reviews!
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
November 16, 2012 at 7:26 am
Take away the extra apostrophes before and after the variable:
SET @Query = N'
INSERT INTO dev.dbo.ServerDetails ([MachineName] , [ServerName], [Instance], [Edition], [ProductLevel], [ProductVersion],[COLLATION], [IsClustered], [IsFullTextInstalled] , [IsIntegratedSecurityOnly])
SELECT * FROM OPENROWSET(''SQLNCLI'', ''Server='...
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
November 16, 2012 at 6:49 am
Hugo Kornelis (11/15/2012)
Roland Alexander STL (11/15/2012)
Use of DEFAULT keyword as default value.
...
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
November 15, 2012 at 8:50 am
Hugo Kornelis (11/15/2012)
Roland Alexander STL (11/15/2012)
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
November 15, 2012 at 7:18 am
Hugo Kornelis (11/15/2012)
Roland Alexander STL (11/15/2012)
Roland Alexander
The Monday Morning DBA
There are two means of refuge from the miseries of life: music and cats. ~ Albert Schweitzer
November 15, 2012 at 7:16 am
Viewing 15 posts - 31 through 45 (of 86 total)