Viewing 15 posts - 106 through 120 (of 143 total)
Your question is very unclear.
Maybe you mean something like.
SELECT MAX(Val)
FROM Table
WHERE Val < (SELECT MAX(Val) FROM Table)
November 14, 2012 at 1:07 am
With containment type partial I also get the error.
Can workaround with:
WHEN $action COLLATE SQL_Latin1_General_CP1_CI_AS = 'DELETE' THEN 'REMOVED'
I found these articles which might be of help :
November 13, 2012 at 7:08 am
Your code works for me on both
2008 (10.50.1600) Enterprise
2012 (10.0.2100) Evaluation
Both results are the same.
$action ACTION name name
INSERT ADDED case NULL
I can reproduce your error by forcing an incorrect collation:
CASE
WHEN $action COLLATE Latin1_General_CI_AS = 'INSERT'...
November 13, 2012 at 6:26 am
Ok thanks anthony.green, much clearer now!
The point of the query would be to find the parents / grandparents, but your inclusion of the new column helped my understanding a lot.
Cheers...
November 13, 2012 at 5:52 am
I think that is reserved blob space. That is to say that it gets handled differently after it excedes 8000 characters.
check out this post:
http://qa.sqlservercentral.com/Forums/Topic647815-145-1.aspx
When copying'n'pasting the this last result into...
November 13, 2012 at 5:44 am
Thanks for your replies!
I nearly heard the click of comprehension.
@anthony.green
Indeed no level 2 with that data.
Adding in:
('Svr4', 'DB1', 'Rep_DB1_b', 'Svr5', 'DB1'),
('Svr4', 'DB3', 'Rep_DB3', 'Svr5', 'DB3')
Does give a level...
November 13, 2012 at 5:15 am
Hi,
The only thing I can think of is replacing:
ON ( Target.name = Source.name )
with
ON ( Target.name COLLATE Latin1_General_CI_AS = Source.name COLLATE Latin1_General_CI_AS )
Hope this helps.
November 13, 2012 at 3:17 am
Maybe this'll help.
INSERT INTO Parent
SELECT LastName, FirstName, Address, City, State, Zip
FROM Original
INSERT INTO Child
SELECT P.ParentID, 1 DocType, O.SSN
FROM Parent P
INNER JOIN [Original] O
ON P.[FirstName] = O.[FirstName]
AND P.LastName = O.LastName
AND P.Address = O.Address
AND P.City = O.City
AND P.State =...
November 12, 2012 at 8:31 am
Just google "top SQL books", you'll find plenty. No one can tell you which one is the best for you. You'll have to decide youself. You could alway get another...
November 12, 2012 at 6:16 am
Assuming you are using Full Recovery, backing up you log regulary will keep it from growing out of hand.
November 12, 2012 at 5:00 am
Hi,
If space is an issue you can archive data from you biggest tables and make them accessible via a view.
When you archive data based on years to seperate DBs,...
November 12, 2012 at 4:53 am
Hi,
You can also add sqlserver.exe to your firewall exception (Without any ports). That'll allow you to use dynamic ports.
November 12, 2012 at 4:37 am
Hi maruthipuligandla,
The requirement is to make your problem as clear as possible so that we can help you better.
Take the time to script a table and test data. That way...
November 12, 2012 at 3:08 am
If you have any other backup devices, check out where they are pointing to. Maybe the file you need is in the same location.
September 28, 2012 at 2:51 am
Ask to get permission, or ask someone else to look for you. 🙂
September 28, 2012 at 2:49 am
Viewing 15 posts - 106 through 120 (of 143 total)